CREATE TABLE cst_transactions_s_gt (
    TRANSACTION_ID                    NUMBER(18, 0) ,
    PROPAGATE_TXFR_COST_ADJ_FLAG      VARCHAR2(4)   ,
    UNREFERENCED_RMA_COST_CODE        VARCHAR2(120) ,
    DS_SOURCE_LINE_ID                 NUMBER(18, 0) ,
    LE_TIMEZONE_CODE                  VARCHAR2(200) ,
    COST_ORG_ID                       NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID                      NUMBER(18, 0)     NOT NULL,
    VAL_STRUCTURE_ID                  NUMBER(18, 0) ,
    STRUCTURE_INSTANCE_NUMBER         NUMBER(18, 0) ,
    VAL_UNIT_ID                       NUMBER(18, 0) ,
    VAL_UNIT_COMBINATION_ID           NUMBER(18, 0) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    INVENTORY_ORG_ID                  NUMBER(18, 0) ,
    COST_TRANSACTION_TYPE             VARCHAR2(40)      NOT NULL,
    ADDITIONAL_PROCESSING_CODE        VARCHAR2(960) ,
    LOGICAL_FLAG                      VARCHAR2(4)       NOT NULL,
    INTRANSIT_FLAG                    VARCHAR2(20)      NOT NULL,
    BASE_TXN_TYPE_ID                  NUMBER(18, 0)     NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID           NUMBER(18, 0)     NOT NULL,
    INV_TXN_SOURCE_TYPE_ID            NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID                NUMBER(18, 0)     NOT NULL,
    TRANSACTION_DATE                  TIMESTAMP(6)  ,
    COST_DATE                         TIMESTAMP(6)  ,
    USE_ITEM_COST_FLAG                VARCHAR2(4)       NOT NULL,
    MATCHED_TO_COST_FLAG              VARCHAR2(20)      NOT NULL,
    MATCHED_TO_ADDL_TAX_FLAG          VARCHAR2(16)      NOT NULL,
    ITEM_COST_PROFILE_ID              NUMBER(18, 0) ,
    COST_PROFILE_ID                   NUMBER(18, 0) ,
    EXPENSE_TRANSACTION_FLAG          VARCHAR2(4)   ,
    COST_METHOD_CODE                  VARCHAR2(120) ,
    NEGATIVE_QTY_CODE                 VARCHAR2(120) ,
    QUANTITY_FLOW_CODE                VARCHAR2(120) ,
    ENFORCE_TXN_DATE_ORDER_FLAG       VARCHAR2(20)  ,
    QUANTITY                          NUMBER        ,
    UOM_CODE                          VARCHAR2(12)  ,
    UOM_CONVERSION_FACTOR             NUMBER        ,
    PREPROCESSING_STATUS              VARCHAR2(120)     NOT NULL,
    ERROR_CODE                        VARCHAR2(400) ,
    POSTED_FLAG                       VARCHAR2(20)  ,
    REC_ONHAND_AVAIL_FLAG             VARCHAR2(4)   ,
    WO_LAYER_POSTED_FLAG              VARCHAR2(4)   ,
    RUN_MODE                          VARCHAR2(20)      NOT NULL,
    CST_INV_TRANSACTION_ID            NUMBER(18, 0) ,
    CST_INV_TRANSACTION_DTL_ID        NUMBER(18, 0) ,
    TRANSFER_COST_ORG_ID              NUMBER(18, 0) ,
    TRANSFER_BOOK_ID                  NUMBER(18, 0) ,
    OWNING_COST_ORG_ID                NUMBER(18, 0) ,
    TRANSFER_CST_INV_TXN_ID           NUMBER(18, 0) ,
    TRANSFER_VAL_UNIT_ID              NUMBER(18, 0) ,
    TRANSFER_UOM_CONVERSION_FACTOR    NUMBER        ,
    FOB_POINT                         NUMBER(1, 0)  ,
    RCV_TRANSACTION_ID                NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    WSH_DELIVERY_DETAIL_ID            NUMBER(18, 0) ,
    DOO_FULLFILL_LINE_ID              NUMBER(18, 0) ,
    CODE_COMBINATION_ID               NUMBER(18, 0) ,
    TXN_SOURCE_DOC_TYPE               VARCHAR2(200) ,
    TXN_SOURCE_DOC_NUMBER             VARCHAR2(960) ,
    TXN_SOURCE_REF_DOC_TYPE           VARCHAR2(200) ,
    TXN_SOURCE_REF_DOC_NUMBER         VARCHAR2(960) ,
    CST_WORK_ORDER_ID                 NUMBER(18, 0) ,
    CST_WORK_ORDER_OPERATION_ID       NUMBER(18, 0) ,
    SUPPLY_TYPE                       VARCHAR2(120) ,
    WORK_CENTER_ID                    NUMBER(18, 0) ,
    CST_WO_OPERATION_TXN_ID           NUMBER(18, 0) ,
    WO_UPDATE_EVENT_TXN_ID            NUMBER(18, 0) ,
    SERVICE_WIP_FLAG                  VARCHAR2(4)   ,
    SERVICE_COST_POSTED_FLAG          VARCHAR2(4)   ,
    DEBRIEF_LINE_ID                   NUMBER(18, 0) ,
    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_NAME               VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    TRANSFER_PERCENTAGE               NUMBER        ,
    PRICING_OPTION                    NUMBER(18, 0) ,
    BUSINESS_UNIT_ID                  NUMBER(18, 0) ,
    TRANSACTION_FLOW_TYPE             NUMBER(18, 0) ,
    INTERNAL_PROFIT_TRACKING          VARCHAR2(4)   ,
    VAL_UNIT_DETAIL_ID                NUMBER(18, 0) ,
    TRANSACTION_QTY                   NUMBER            NOT NULL,
    TRANSACTION_UOM_CODE              VARCHAR2(12)      NOT NULL,
    PROCESS_DATE                      TIMESTAMP(6)  ,
    COGS_POSTED_FLAG                  VARCHAR2(20)  ,
    COSTED_QTY                        NUMBER        ,
    COSTING_UOM_CODE                  VARCHAR2(12)  ,
    COSTING_STATUS                    VARCHAR2(4)   ,
    TRANSFER_CST_INV_TXN_DTL_ID       NUMBER(18, 0) ,
    STAGED_FOR_TXFR_COST_FLAG         VARCHAR2(20)      NOT NULL,
    COST_STATUS                       VARCHAR2(4)   ,
    ACCOUNTING_STATUS                 VARCHAR2(4)   ,
    PROPAGATE_COST_ADJ_FLAG           VARCHAR2(4)   ,
    RECEIPT_WITHOUT_COST_CODE         VARCHAR2(120) ,
    REFERENCED_RMA_COST_CODE          VARCHAR2(120) ,
    TRANSACTION_GROUP_ID              NUMBER(18, 0) ,
    TRANSFER_TRANSACTION_GROUP_ID     NUMBER(18, 0) ,
    INTERCOMPANY_INVOICING_FLAG       VARCHAR2(4)   ,
    CONSIGNED_FLAG                    VARCHAR2(4)       NOT NULL,
    CONSIGNED_ACCT_DIST_BASIS         VARCHAR2(120) ,
    CREATE_ACCT_FOR_CONS_TXNS         VARCHAR2(4)   ,
    PROVISIONAL_COMPLETION_TYPE       VARCHAR2(120) ,
    OPERATION_SCRAP_COST_TYPE         VARCHAR2(120) ,
    CST_TRANSFER_ORDER_LINE_ID        NUMBER(18, 0) ,
    CST_TRANSFER_ORDER_DIST_ID        NUMBER(18, 0) ,
    PARTIAL_COMPLETION_FLAG           VARCHAR2(4)   ,
    MANUAL_RECEIPT_REQD_FLAG          VARCHAR2(4)   ,
    REFERENCE_DOO_FULLFILL_LINE_ID    NUMBER(18, 0) ,
    REFERENCE_DELIVERY_ID             NUMBER(18, 0) ,
    REFERENCED_RETURN_FLAG            VARCHAR2(20)  ,
    SIMPLE_PROC_FLAG                  VARCHAR2(20)  ,
    PROJECT_FLAG                      VARCHAR2(4)   ,
    WO_COST_ALLOCATION_BASIS          VARCHAR2(120) ,
    DOO_SPLIT_FULFILL_LINE_ID         NUMBER(18, 0) ,
    PERIOD_NAME                       VARCHAR2(60)  ,
    PERIOD_START_DATE                 DATE          ,
    PAC_XFR_CO_FLAG                   VARCHAR2(4)   ,
    BASIS_TYPE                        VARCHAR2(120) ,
    TRANSACTION_ID                    NUMBER(18, 0) ,
    PROPAGATE_TXFR_COST_ADJ_FLAG      VARCHAR2(4)   ,
    UNREFERENCED_RMA_COST_CODE        VARCHAR2(120) ,
    DS_SOURCE_LINE_ID                 NUMBER(18, 0) ,
    LE_TIMEZONE_CODE                  VARCHAR2(200) ,
    COST_ORG_ID                       NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID                      NUMBER(18, 0)     NOT NULL,
    VAL_STRUCTURE_ID                  NUMBER(18, 0) ,
    STRUCTURE_INSTANCE_NUMBER         NUMBER(18, 0) ,
    VAL_UNIT_ID                       NUMBER(18, 0) ,
    VAL_UNIT_COMBINATION_ID           NUMBER(18, 0) ,
    INVENTORY_ITEM_ID                 NUMBER(18, 0)     NOT NULL,
    INVENTORY_ORG_ID                  NUMBER(18, 0) ,
    COST_TRANSACTION_TYPE             VARCHAR2(40)      NOT NULL,
    ADDITIONAL_PROCESSING_CODE        VARCHAR2(960) ,
    LOGICAL_FLAG                      VARCHAR2(4)       NOT NULL,
    INTRANSIT_FLAG                    VARCHAR2(20)      NOT NULL,
    BASE_TXN_TYPE_ID                  NUMBER(18, 0)     NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID           NUMBER(18, 0)     NOT NULL,
    INV_TXN_SOURCE_TYPE_ID            NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID                NUMBER(18, 0)     NOT NULL,
    TRANSACTION_DATE                  TIMESTAMP(6)  ,
    COST_DATE                         TIMESTAMP(6)  ,
    USE_ITEM_COST_FLAG                VARCHAR2(4)       NOT NULL,
    MATCHED_TO_COST_FLAG              VARCHAR2(20)      NOT NULL,
    MATCHED_TO_ADDL_TAX_FLAG          VARCHAR2(16)      NOT NULL,
    ITEM_COST_PROFILE_ID              NUMBER(18, 0) ,
    COST_PROFILE_ID                   NUMBER(18, 0) ,
    EXPENSE_TRANSACTION_FLAG          VARCHAR2(4)   ,
    COST_METHOD_CODE                  VARCHAR2(120) ,
    NEGATIVE_QTY_CODE                 VARCHAR2(120) ,
    QUANTITY_FLOW_CODE                VARCHAR2(120) ,
    ENFORCE_TXN_DATE_ORDER_FLAG       VARCHAR2(20)  ,
    QUANTITY                          NUMBER        ,
    UOM_CODE                          VARCHAR2(12)  ,
    UOM_CONVERSION_FACTOR             NUMBER        ,
    PREPROCESSING_STATUS              VARCHAR2(120)     NOT NULL,
    ERROR_CODE                        VARCHAR2(400) ,
    POSTED_FLAG                       VARCHAR2(20)  ,
    REC_ONHAND_AVAIL_FLAG             VARCHAR2(4)   ,
    WO_LAYER_POSTED_FLAG              VARCHAR2(4)   ,
    RUN_MODE                          VARCHAR2(20)      NOT NULL,
    CST_INV_TRANSACTION_ID            NUMBER(18, 0) ,
    CST_INV_TRANSACTION_DTL_ID        NUMBER(18, 0) ,
    TRANSFER_COST_ORG_ID              NUMBER(18, 0) ,
    TRANSFER_BOOK_ID                  NUMBER(18, 0) ,
    OWNING_COST_ORG_ID                NUMBER(18, 0) ,
    TRANSFER_CST_INV_TXN_ID           NUMBER(18, 0) ,
    TRANSFER_VAL_UNIT_ID              NUMBER(18, 0) ,
    TRANSFER_UOM_CONVERSION_FACTOR    NUMBER        ,
    FOB_POINT                         NUMBER(1, 0)  ,
    RCV_TRANSACTION_ID                NUMBER(18, 0) ,
    PO_DISTRIBUTION_ID                NUMBER(18, 0) ,
    WSH_DELIVERY_DETAIL_ID            NUMBER(18, 0) ,
    DOO_FULLFILL_LINE_ID              NUMBER(18, 0) ,
    CODE_COMBINATION_ID               NUMBER(18, 0) ,
    TXN_SOURCE_DOC_TYPE               VARCHAR2(200) ,
    TXN_SOURCE_DOC_NUMBER             VARCHAR2(960) ,
    TXN_SOURCE_REF_DOC_TYPE           VARCHAR2(200) ,
    TXN_SOURCE_REF_DOC_NUMBER         VARCHAR2(960) ,
    CST_WORK_ORDER_ID                 NUMBER(18, 0) ,
    CST_WORK_ORDER_OPERATION_ID       NUMBER(18, 0) ,
    SUPPLY_TYPE                       VARCHAR2(120) ,
    WORK_CENTER_ID                    NUMBER(18, 0) ,
    CST_WO_OPERATION_TXN_ID           NUMBER(18, 0) ,
    WO_UPDATE_EVENT_TXN_ID            NUMBER(18, 0) ,
    SERVICE_WIP_FLAG                  VARCHAR2(4)   ,
    SERVICE_COST_POSTED_FLAG          VARCHAR2(4)   ,
    DEBRIEF_LINE_ID                   NUMBER(18, 0) ,
    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_NAME               VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE            VARCHAR2(3600),
    TRANSFER_PERCENTAGE               NUMBER        ,
    PRICING_OPTION                    NUMBER(18, 0) ,
    BUSINESS_UNIT_ID                  NUMBER(18, 0) ,
    TRANSACTION_FLOW_TYPE             NUMBER(18, 0) ,
    INTERNAL_PROFIT_TRACKING          VARCHAR2(4)   ,
    VAL_UNIT_DETAIL_ID                NUMBER(18, 0) ,
    TRANSACTION_QTY                   NUMBER            NOT NULL,
    TRANSACTION_UOM_CODE              VARCHAR2(12)      NOT NULL,
    PROCESS_DATE                      TIMESTAMP(6)  ,
    COGS_POSTED_FLAG                  VARCHAR2(20)  ,
    COSTED_QTY                        NUMBER        ,
    COSTING_UOM_CODE                  VARCHAR2(12)  ,
    COSTING_STATUS                    VARCHAR2(4)   ,
    TRANSFER_CST_INV_TXN_DTL_ID       NUMBER(18, 0) ,
    STAGED_FOR_TXFR_COST_FLAG         VARCHAR2(20)      NOT NULL,
    COST_STATUS                       VARCHAR2(4)   ,
    ACCOUNTING_STATUS                 VARCHAR2(4)   ,
    PROPAGATE_COST_ADJ_FLAG           VARCHAR2(4)   ,
    RECEIPT_WITHOUT_COST_CODE         VARCHAR2(120) ,
    REFERENCED_RMA_COST_CODE          VARCHAR2(120) ,
    TRANSACTION_GROUP_ID              NUMBER(18, 0) ,
    TRANSFER_TRANSACTION_GROUP_ID     NUMBER(18, 0) ,
    INTERCOMPANY_INVOICING_FLAG       VARCHAR2(4)   ,
    CONSIGNED_FLAG                    VARCHAR2(4)       NOT NULL,
    CONSIGNED_ACCT_DIST_BASIS         VARCHAR2(120) ,
    CREATE_ACCT_FOR_CONS_TXNS         VARCHAR2(4)   ,
    PROVISIONAL_COMPLETION_TYPE       VARCHAR2(120) ,
    OPERATION_SCRAP_COST_TYPE         VARCHAR2(120) ,
    CST_TRANSFER_ORDER_LINE_ID        NUMBER(18, 0) ,
    CST_TRANSFER_ORDER_DIST_ID        NUMBER(18, 0) ,
    PARTIAL_COMPLETION_FLAG           VARCHAR2(4)   ,
    MANUAL_RECEIPT_REQD_FLAG          VARCHAR2(4)   ,
    REFERENCE_DOO_FULLFILL_LINE_ID    NUMBER(18, 0) ,
    REFERENCE_DELIVERY_ID             NUMBER(18, 0) ,
    REFERENCED_RETURN_FLAG            VARCHAR2(20)  ,
    SIMPLE_PROC_FLAG                  VARCHAR2(20)  ,
    PROJECT_FLAG                      VARCHAR2(4)   ,
    WO_COST_ALLOCATION_BASIS          VARCHAR2(120) ,
    DOO_SPLIT_FULFILL_LINE_ID         NUMBER(18, 0) ,
    PERIOD_NAME                       VARCHAR2(60)  ,
    PERIOD_START_DATE                 DATE          ,
    PAC_XFR_CO_FLAG                   VARCHAR2(4)   ,
    BASIS_TYPE                        VARCHAR2(120) ,
    CONSTRAINT pk_cst_transactions_s_gt PRIMARY KEY (TRANSACTION_ID, TRANSACTION_ID)
);
