CREATE TABLE cmr_rcv_transactions_i_gt (
    CMR_RCV_TRANSACTION_ID            NUMBER(18, 0) ,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(240)     NOT NULL,
    EXTERNAL_SYSTEM_REF_ID            VARCHAR2(120)     NOT NULL,
    TXN_GROUP_ID                      NUMBER(18, 0)     NOT NULL,
    TRANSACTION_TYPE                  VARCHAR2(160)     NOT NULL,
    TRANSACTION_DATE                  DATE              NOT NULL,
    PARENT_TRANSACTION_ID             NUMBER(18, 0)     NOT NULL,
    RCV_PARENT_TRANSACTION_ID         NUMBER(18, 0) ,
    SHIP_TO_ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    PO_LINE_LOCATION_ID               NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    FISCAL_DOC_HEADER_ID              NUMBER(18, 0) ,
    FISCAL_DOC_LINE_ID                NUMBER(18, 0) ,
    FISCAL_DOC_SCHEDULE_ID            NUMBER(18, 0) ,
    FISCAL_DOC_ACCESS_KNUM            VARCHAR2(256) ,
    RETURN_FOR_CREDIT_FLAG            VARCHAR2(4)   ,
    REF_FISCAL_DOC_HEADER_ID          NUMBER(18, 0) ,
    REF_FISCAL_DOC_LINE_ID            NUMBER(18, 0) ,
    REF_FISCAL_DOC_SCHEDULE_ID        NUMBER(18, 0) ,
    REF_FISCAL_DOC_ACCESS_KNUM        VARCHAR2(256) ,
    RECEIPT_NUMBER                    VARCHAR2(200) ,
    PRIMARY_QUANTITY                  NUMBER        ,
    PRIMARY_UOM_CODE                  VARCHAR2(100) ,
    SECONDARY_TRANSACTION_QTY         NUMBER        ,
    SECONDARY_UOM_CODE                VARCHAR2(12)  ,
    TRANSFER_PRICE_QTY                NUMBER        ,
    TRANSFER_PRICE_UOM_CODE           VARCHAR2(12)  ,
    TRANSACTION_QUANTITY              NUMBER        ,
    TRANSACTION_UOM_CODE              VARCHAR2(100) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    SOURCE_DOCUMENT_CODE              VARCHAR2(100) ,
    SOURCE_DOC_QUANTITY               NUMBER        ,
    SOURCE_DOC_UOM_CODE               VARCHAR2(100) ,
    TRANSACTION_AMOUNT                NUMBER        ,
    DESTINATION_TYPE_CODE             VARCHAR2(100) ,
    CURRENCY_CONVERSION_DATE          TIMESTAMP(6)  ,
    CURRENCY_CONVERSION_RATE          NUMBER        ,
    PREPROCESSED_STATUS               VARCHAR2(20)  ,
    ERROR_CODE                        VARCHAR2(120) ,
    TXN_FLOW_HEADER_ID                NUMBER(18, 0) ,
    TAX_PROCESSED_FLAG                VARCHAR2(4)   ,
    ALLOCATED_FLAG                    VARCHAR2(4)       NOT NULL,
    PJC_CONTEXT_CATEGORY              VARCHAR2(160) ,
    PJC_PROJECT_ID                    NUMBER(18, 0) ,
    PJC_TASK_ID                       VARCHAR2(72)  ,
    PJC_EXPENDITURE_TYPE_ID           NUMBER(18, 0) ,
    PJC_EXPENDITURE_ITEM_DATE         DATE          ,
    PJC_ORGANIZATION_ID               NUMBER(18, 0) ,
    PJC_BILLABLE_FLAG                 VARCHAR2(4)   ,
    PJC_WORK_TYPE_ID                  NUMBER(18, 0) ,
    PJC_FUNDING_ALLOCATION_ID         NUMBER(18, 0) ,
    PJC_CONTRACT_ID                   NUMBER(18, 0) ,
    PJC_CONTRACT_LINE_ID              NUMBER(18, 0) ,
    PJC_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    PJC_CAPITALIZABLE_FLAG            VARCHAR2(4)   ,
    PJC_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE3           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE4           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE5           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE6           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE7           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE8           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE9           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE10          VARCHAR2(600) ,
    PJC_INTERFACED_STATUS             VARCHAR2(80)  ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    REQUEST_ID                        NUMBER(18, 0) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    INTERFACE_BATCH_NUMBER            VARCHAR2(200) ,
    INTERFACE_BATCH_NAME              VARCHAR2(1000),
    ROOT_RECEIVE_TXN_ID               NUMBER(18, 0) ,
    ROOT_DELIVER_TXN_ID               NUMBER(18, 0) ,
    CMR_ROOT_RECEIVE_TXN_ID           NUMBER(18, 0) ,
    CMR_ROOT_DELIVER_TXN_ID           NUMBER(18, 0) ,
    CMR_PO_DISTRIBUTION_ID            NUMBER(18, 0) ,
    CMR_PO_LINE_LOCATION_ID           NUMBER(18, 0) ,
    DEFAULT_TAXATION_COUNTRY          VARCHAR2(8)   ,
    FIRST_PTY_REG_ID                  NUMBER(18, 0) ,
    THIRD_PTY_REG_ID                  NUMBER(18, 0) ,
    FINAL_DISCHARGE_LOCATION_ID       NUMBER(18, 0) ,
    DOCUMENT_FISCAL_CLASSIFICATION    VARCHAR2(960) ,
    TRX_BUSINESS_CATEGORY             VARCHAR2(960) ,
    USER_DEFINED_FISC_CLASS           VARCHAR2(120) ,
    TAX_INVOICE_NUMBER                VARCHAR2(600) ,
    TAX_INVOICE_DATE                  DATE          ,
    PRODUCT_FISC_CLASS_ID             NUMBER(18, 0) ,
    PRODUCT_CATEGORY                  VARCHAR2(960) ,
    INTENDED_USE_CLASSIF_ID           NUMBER(18, 0) ,
    INTENDED_USE                      VARCHAR2(960) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    PRODUCT_TYPE                      VARCHAR2(960) ,
    ASSESSABLE_VALUE                  NUMBER        ,
    TAX_CLASSIFICATION_CODE           VARCHAR2(200) ,
    SHIP_FROM_LOCATION_ID             NUMBER(18, 0) ,
    INV_SHIPPING_TRANSACTION_ID       NUMBER(18, 0) ,
    SHIPMENT_NUMBER                   VARCHAR2(120) ,
    SHIP_FROM_INV_ORG_ID              NUMBER(18, 0) ,
    SHIPMENT_LINE_NUMBER              NUMBER(18, 0) ,
    TRANSFER_ORDER_HEADER_ID          NUMBER(18, 0) ,
    TRANSFER_ORDER_LINE_ID            NUMBER(18, 0) ,
    TRANSFER_ORDER_DIST_ID            NUMBER(18, 0) ,
    PHYSICAL_RETURN_REQD_FLAG         VARCHAR2(4)   ,
    ORIG_TF_ORD_INV_SHIP_TXN_ID       NUMBER(18, 0) ,
    CONSIGNED_FLAG                    VARCHAR2(4)   ,
    RECEIPT_LINE_NUMBER               NUMBER(18, 0) ,
    PRIOR_TRADE_INV_ORG_ID            NUMBER(18, 0) ,
    BILL_TO_BUSINESS_UNIT_ID          NUMBER(18, 0) ,
    FTR_ID                            NUMBER(18, 0) ,
    PROCESS_BY_CA_FLAG                VARCHAR2(4)   ,
    RECEIPT_CREATION_DATE             DATE          ,
    ROOT_DELIVER_TXN_DATE             DATE          ,
    DS_RECEIPT_SOURCE_LINE_ID         NUMBER(18, 0) ,
    DIRECT_TRANSFER_ORDER_FLAG        VARCHAR2(4)   ,
    CMR_RCV_TRANSACTION_ID            NUMBER(18, 0) ,
    EXTERNAL_SYSTEM_REFERENCE         VARCHAR2(240)     NOT NULL,
    EXTERNAL_SYSTEM_REF_ID            VARCHAR2(120)     NOT NULL,
    TXN_GROUP_ID                      NUMBER(18, 0)     NOT NULL,
    TRANSACTION_TYPE                  VARCHAR2(160)     NOT NULL,
    TRANSACTION_DATE                  DATE              NOT NULL,
    PARENT_TRANSACTION_ID             NUMBER(18, 0)     NOT NULL,
    RCV_PARENT_TRANSACTION_ID         NUMBER(18, 0) ,
    SHIP_TO_ORGANIZATION_ID           NUMBER(18, 0)     NOT NULL,
    PO_LINE_LOCATION_ID               NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    FISCAL_DOC_HEADER_ID              NUMBER(18, 0) ,
    FISCAL_DOC_LINE_ID                NUMBER(18, 0) ,
    FISCAL_DOC_SCHEDULE_ID            NUMBER(18, 0) ,
    FISCAL_DOC_ACCESS_KNUM            VARCHAR2(256) ,
    RETURN_FOR_CREDIT_FLAG            VARCHAR2(4)   ,
    REF_FISCAL_DOC_HEADER_ID          NUMBER(18, 0) ,
    REF_FISCAL_DOC_LINE_ID            NUMBER(18, 0) ,
    REF_FISCAL_DOC_SCHEDULE_ID        NUMBER(18, 0) ,
    REF_FISCAL_DOC_ACCESS_KNUM        VARCHAR2(256) ,
    RECEIPT_NUMBER                    VARCHAR2(200) ,
    PRIMARY_QUANTITY                  NUMBER        ,
    PRIMARY_UOM_CODE                  VARCHAR2(100) ,
    SECONDARY_TRANSACTION_QTY         NUMBER        ,
    SECONDARY_UOM_CODE                VARCHAR2(12)  ,
    TRANSFER_PRICE_QTY                NUMBER        ,
    TRANSFER_PRICE_UOM_CODE           VARCHAR2(12)  ,
    TRANSACTION_QUANTITY              NUMBER        ,
    TRANSACTION_UOM_CODE              VARCHAR2(100) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0) ,
    SOURCE_DOCUMENT_CODE              VARCHAR2(100) ,
    SOURCE_DOC_QUANTITY               NUMBER        ,
    SOURCE_DOC_UOM_CODE               VARCHAR2(100) ,
    TRANSACTION_AMOUNT                NUMBER        ,
    DESTINATION_TYPE_CODE             VARCHAR2(100) ,
    CURRENCY_CONVERSION_DATE          TIMESTAMP(6)  ,
    CURRENCY_CONVERSION_RATE          NUMBER        ,
    PREPROCESSED_STATUS               VARCHAR2(20)  ,
    ERROR_CODE                        VARCHAR2(120) ,
    TXN_FLOW_HEADER_ID                NUMBER(18, 0) ,
    TAX_PROCESSED_FLAG                VARCHAR2(4)   ,
    ALLOCATED_FLAG                    VARCHAR2(4)       NOT NULL,
    PJC_CONTEXT_CATEGORY              VARCHAR2(160) ,
    PJC_PROJECT_ID                    NUMBER(18, 0) ,
    PJC_TASK_ID                       VARCHAR2(72)  ,
    PJC_EXPENDITURE_TYPE_ID           NUMBER(18, 0) ,
    PJC_EXPENDITURE_ITEM_DATE         DATE          ,
    PJC_ORGANIZATION_ID               NUMBER(18, 0) ,
    PJC_BILLABLE_FLAG                 VARCHAR2(4)   ,
    PJC_WORK_TYPE_ID                  NUMBER(18, 0) ,
    PJC_FUNDING_ALLOCATION_ID         NUMBER(18, 0) ,
    PJC_CONTRACT_ID                   NUMBER(18, 0) ,
    PJC_CONTRACT_LINE_ID              NUMBER(18, 0) ,
    PJC_USER_DEF_ATTRIBUTE1           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE2           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE3           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE4           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE5           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE6           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE7           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE8           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE9           VARCHAR2(600) ,
    PJC_USER_DEF_ATTRIBUTE10          VARCHAR2(600) ,
    PJC_CAPITALIZABLE_FLAG            VARCHAR2(4)   ,
    PJC_RESERVED_ATTRIBUTE1           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE2           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE3           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE4           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE5           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE6           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE7           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE8           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE9           VARCHAR2(600) ,
    PJC_RESERVED_ATTRIBUTE10          VARCHAR2(600) ,
    PJC_INTERFACED_STATUS             VARCHAR2(80)  ,
    ATTRIBUTE_CATEGORY                VARCHAR2(120) ,
    ATTRIBUTE1                        VARCHAR2(600) ,
    ATTRIBUTE2                        VARCHAR2(600) ,
    ATTRIBUTE3                        VARCHAR2(600) ,
    ATTRIBUTE4                        VARCHAR2(600) ,
    ATTRIBUTE5                        VARCHAR2(600) ,
    ATTRIBUTE6                        VARCHAR2(600) ,
    ATTRIBUTE7                        VARCHAR2(600) ,
    ATTRIBUTE8                        VARCHAR2(600) ,
    ATTRIBUTE9                        VARCHAR2(600) ,
    ATTRIBUTE10                       VARCHAR2(600) ,
    ATTRIBUTE11                       VARCHAR2(600) ,
    ATTRIBUTE12                       VARCHAR2(600) ,
    ATTRIBUTE13                       VARCHAR2(600) ,
    ATTRIBUTE14                       VARCHAR2(600) ,
    ATTRIBUTE15                       VARCHAR2(600) ,
    CREATED_BY                        VARCHAR2(256)     NOT NULL,
    CREATION_DATE                     TIMESTAMP(6)      NOT NULL,
    LAST_UPDATED_BY                   VARCHAR2(256)     NOT NULL,
    LAST_UPDATE_DATE                  TIMESTAMP(6)      NOT NULL,
    LAST_UPDATE_LOGIN                 VARCHAR2(128) ,
    REQUEST_ID                        NUMBER(18, 0) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    JOB_DEFINITION_NAME               VARCHAR2(400) ,
    INTERFACE_BATCH_NUMBER            VARCHAR2(200) ,
    INTERFACE_BATCH_NAME              VARCHAR2(1000),
    ROOT_RECEIVE_TXN_ID               NUMBER(18, 0) ,
    ROOT_DELIVER_TXN_ID               NUMBER(18, 0) ,
    CMR_ROOT_RECEIVE_TXN_ID           NUMBER(18, 0) ,
    CMR_ROOT_DELIVER_TXN_ID           NUMBER(18, 0) ,
    CMR_PO_DISTRIBUTION_ID            NUMBER(18, 0) ,
    CMR_PO_LINE_LOCATION_ID           NUMBER(18, 0) ,
    DEFAULT_TAXATION_COUNTRY          VARCHAR2(8)   ,
    FIRST_PTY_REG_ID                  NUMBER(18, 0) ,
    THIRD_PTY_REG_ID                  NUMBER(18, 0) ,
    FINAL_DISCHARGE_LOCATION_ID       NUMBER(18, 0) ,
    DOCUMENT_FISCAL_CLASSIFICATION    VARCHAR2(960) ,
    TRX_BUSINESS_CATEGORY             VARCHAR2(960) ,
    USER_DEFINED_FISC_CLASS           VARCHAR2(120) ,
    TAX_INVOICE_NUMBER                VARCHAR2(600) ,
    TAX_INVOICE_DATE                  DATE          ,
    PRODUCT_FISC_CLASS_ID             NUMBER(18, 0) ,
    PRODUCT_CATEGORY                  VARCHAR2(960) ,
    INTENDED_USE_CLASSIF_ID           NUMBER(18, 0) ,
    INTENDED_USE                      VARCHAR2(960) ,
    COUNTRY_OF_ORIGIN_CODE            VARCHAR2(8)   ,
    PRODUCT_TYPE                      VARCHAR2(960) ,
    ASSESSABLE_VALUE                  NUMBER        ,
    TAX_CLASSIFICATION_CODE           VARCHAR2(200) ,
    SHIP_FROM_LOCATION_ID             NUMBER(18, 0) ,
    INV_SHIPPING_TRANSACTION_ID       NUMBER(18, 0) ,
    SHIPMENT_NUMBER                   VARCHAR2(120) ,
    SHIP_FROM_INV_ORG_ID              NUMBER(18, 0) ,
    SHIPMENT_LINE_NUMBER              NUMBER(18, 0) ,
    TRANSFER_ORDER_HEADER_ID          NUMBER(18, 0) ,
    TRANSFER_ORDER_LINE_ID            NUMBER(18, 0) ,
    TRANSFER_ORDER_DIST_ID            NUMBER(18, 0) ,
    PHYSICAL_RETURN_REQD_FLAG         VARCHAR2(4)   ,
    ORIG_TF_ORD_INV_SHIP_TXN_ID       NUMBER(18, 0) ,
    CONSIGNED_FLAG                    VARCHAR2(4)   ,
    RECEIPT_LINE_NUMBER               NUMBER(18, 0) ,
    PRIOR_TRADE_INV_ORG_ID            NUMBER(18, 0) ,
    BILL_TO_BUSINESS_UNIT_ID          NUMBER(18, 0) ,
    FTR_ID                            NUMBER(18, 0) ,
    PROCESS_BY_CA_FLAG                VARCHAR2(4)   ,
    RECEIPT_CREATION_DATE             DATE          ,
    ROOT_DELIVER_TXN_DATE             DATE          ,
    DS_RECEIPT_SOURCE_LINE_ID         NUMBER(18, 0) ,
    DIRECT_TRANSFER_ORDER_FLAG        VARCHAR2(4)   ,
    CONSTRAINT pk_cmr_rcv_transactions_i_gt PRIMARY KEY (CMR_RCV_TRANSACTION_ID, CMR_RCV_TRANSACTION_ID)
);
