CREATE TABLE cst_pac_wo_outputs_int (
    TRANSACTION_ID                 NUMBER(18, 0) ,
    COST_ORG_ID                    NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID                   NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID              NUMBER(18, 0)     NOT NULL,
    VAL_UNIT_ID                    NUMBER(18, 0) ,
    PERIOD_NAME                    VARCHAR2(60)  ,
    INVENTORY_ORG_ID               NUMBER(18, 0) ,
    CST_WORK_ORDER_ID              NUMBER(18, 0) ,
    CST_WORK_ORDER_OPERATION_ID    NUMBER(18, 0) ,
    COST_TRANSACTION_TYPE          VARCHAR2(40)      NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID        NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID             NUMBER(18, 0)     NOT NULL,
    BASE_TXN_TYPE_ID               NUMBER(18, 0)     NOT NULL,
    QUANTITY                       NUMBER        ,
    ALLOCATION_BASIS               VARCHAR2(120) ,
    ALLOCATION_PERCENTAGE          NUMBER        ,
    POSTED_FLAG                    VARCHAR2(20)  ,
    COST_DATE                      TIMESTAMP(6)  ,
    CST_INV_TRANSACTION_ID         NUMBER(18, 0) ,
    WORK_ORDER_NUMBER              VARCHAR2(960) ,
    WO_OUTPUT_TYPE                 VARCHAR2(120) ,
    COMPLETED_QUANTITY             NUMBER        ,
    UOM_CODE                       VARCHAR2(12)  ,
    PAC_TXN_GROUP_ID_1             NUMBER(18, 0) ,
    PAC_TXN_GROUP_ID_2             NUMBER(18, 0) ,
    PAC_TXN_GROUP_ID_3             NUMBER(18, 0) ,
    COST_PROFILE_ID                NUMBER(18, 0) ,
    DEFAULT_COST_ELEMENT_ID        NUMBER(18, 0) ,
    WO_CLOSE_FLAG                  VARCHAR2(4)   ,
    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),
    TRANSACTION_ID                 NUMBER(18, 0) ,
    COST_ORG_ID                    NUMBER(18, 0)     NOT NULL,
    COST_BOOK_ID                   NUMBER(18, 0)     NOT NULL,
    INVENTORY_ITEM_ID              NUMBER(18, 0)     NOT NULL,
    VAL_UNIT_ID                    NUMBER(18, 0) ,
    PERIOD_NAME                    VARCHAR2(60)  ,
    INVENTORY_ORG_ID               NUMBER(18, 0) ,
    CST_WORK_ORDER_ID              NUMBER(18, 0) ,
    CST_WORK_ORDER_OPERATION_ID    NUMBER(18, 0) ,
    COST_TRANSACTION_TYPE          VARCHAR2(40)      NOT NULL,
    BASE_TXN_SOURCE_TYPE_ID        NUMBER(18, 0)     NOT NULL,
    BASE_TXN_ACTION_ID             NUMBER(18, 0)     NOT NULL,
    BASE_TXN_TYPE_ID               NUMBER(18, 0)     NOT NULL,
    QUANTITY                       NUMBER        ,
    ALLOCATION_BASIS               VARCHAR2(120) ,
    ALLOCATION_PERCENTAGE          NUMBER        ,
    POSTED_FLAG                    VARCHAR2(20)  ,
    COST_DATE                      TIMESTAMP(6)  ,
    CST_INV_TRANSACTION_ID         NUMBER(18, 0) ,
    WORK_ORDER_NUMBER              VARCHAR2(960) ,
    WO_OUTPUT_TYPE                 VARCHAR2(120) ,
    COMPLETED_QUANTITY             NUMBER        ,
    UOM_CODE                       VARCHAR2(12)  ,
    PAC_TXN_GROUP_ID_1             NUMBER(18, 0) ,
    PAC_TXN_GROUP_ID_2             NUMBER(18, 0) ,
    PAC_TXN_GROUP_ID_3             NUMBER(18, 0) ,
    COST_PROFILE_ID                NUMBER(18, 0) ,
    DEFAULT_COST_ELEMENT_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),
    WO_CLOSE_FLAG                  VARCHAR2(4)   ,
    CONSTRAINT pk_cst_pac_wo_outputs_int PRIMARY KEY (TRANSACTION_ID, TRANSACTION_ID)
);
