CREATE TABLE cst_wo_cost_summary_s_gt (
    COST_ORG_ID                      NUMBER(18, 0)    NOT NULL,
    COST_BOOK_ID                     NUMBER(18, 0)    NOT NULL,
    CST_WORK_ORDER_ID                NUMBER(18, 0)    NOT NULL,
    WORK_ORDER_NUMBER                VARCHAR2(480)    NOT NULL,
    ASSET_ID                         NUMBER(18, 0),
    EXTERNAL_SYSTEM_REF_ID           VARCHAR2(120)    NOT NULL,
    ASSET_NUMBER                     VARCHAR2(320),
    WORK_ORDER_STATUS_ID             NUMBER(18, 0),
    WORK_METHOD_ID                   NUMBER(18, 0),
    WORK_DEFINITION_ID               NUMBER(18, 0),
    WORK_DEFINITION_VERSION_NUM      VARCHAR2(40) ,
    CLOSE_PROCESSING_PENDING_FLAG    VARCHAR2(4)  ,
    CONTRACT_MFG_FLAG                VARCHAR2(4)  ,
    WORK_ORDER_LESS_FLAG             VARCHAR2(4)  ,
    CONTAINS_OP_YIELD_OPERATION      VARCHAR2(4)  ,
    WORK_ORDER_TYPE                  VARCHAR2(120),
    WORK_ORDER_SUB_TYPE              VARCHAR2(120),
    ALLOW_MULTIPLE_ASSETS_FLAG       VARCHAR2(4)  ,
    COMPLETE_TO_INV_FLAG             VARCHAR2(4)  ,
    INVENTORY_ASSET_FLAG             VARCHAR2(4)  ,
    RELEASED_DATE                    TIMESTAMP(6) ,
    CLOSED_DATE                      TIMESTAMP(6) ,
    COMPLETION_DATE                  TIMESTAMP(6) ,
    INVENTORY_ORGANIZATION_ID        NUMBER(18, 0)    NOT NULL,
    INVENTORY_ITEM_ID                NUMBER(18, 0)    NOT NULL,
    MNT_TRANSFORM_TO_ITEM_ID         NUMBER(18, 0),
    PJC_PROJECT_ID                   NUMBER(18, 0),
    PJC_TASK_ID                      NUMBER(18, 0),
    COUNTRY_OF_ORIGIN_CODE           VARCHAR2(8)  ,
    CURRENCY_CODE                    VARCHAR2(80) ,
    OUTPUT_QUANTITY                  NUMBER       ,
    INPUT_COST                       NUMBER       ,
    OUTPUT_COST                      NUMBER       ,
    PRIMARY_OUTPUT_COST              NUMBER       ,
    WIP_BALANCE                      NUMBER       ,
    REWORK_AMOUNT                    NUMBER       ,
    SCRAP_IN_INVENTORY_COST          NUMBER       ,
    SCRAP_EXPENSE_COST               NUMBER       ,
    VARIANCE_COST                    NUMBER       ,
    VARIANCE_PERCENT                 NUMBER       ,
    SCRAP_PERCENT                    NUMBER       ,
    TOTAL_COST                       NUMBER       ,
    MATERIAL_COST                    NUMBER       ,
    RESOURCE_COST                    NUMBER       ,
    OVERHEAD_COST                    NUMBER       ,
    ENABLE_PARALLEL_OPS_FLAG         VARCHAR2(4)  ,
    COST_ORG_ID                      NUMBER(18, 0)    NOT NULL,
    COST_BOOK_ID                     NUMBER(18, 0)    NOT NULL,
    CST_WORK_ORDER_ID                NUMBER(18, 0)    NOT NULL,
    WORK_ORDER_NUMBER                VARCHAR2(480)    NOT NULL,
    ASSET_ID                         NUMBER(18, 0),
    EXTERNAL_SYSTEM_REF_ID           VARCHAR2(120)    NOT NULL,
    ASSET_NUMBER                     VARCHAR2(320),
    WORK_ORDER_STATUS_ID             NUMBER(18, 0),
    WORK_METHOD_ID                   NUMBER(18, 0),
    WORK_DEFINITION_ID               NUMBER(18, 0),
    WORK_DEFINITION_VERSION_NUM      VARCHAR2(40) ,
    CLOSE_PROCESSING_PENDING_FLAG    VARCHAR2(4)  ,
    CONTRACT_MFG_FLAG                VARCHAR2(4)  ,
    WORK_ORDER_LESS_FLAG             VARCHAR2(4)  ,
    CONTAINS_OP_YIELD_OPERATION      VARCHAR2(4)  ,
    WORK_ORDER_TYPE                  VARCHAR2(120),
    WORK_ORDER_SUB_TYPE              VARCHAR2(120),
    ALLOW_MULTIPLE_ASSETS_FLAG       VARCHAR2(4)  ,
    COMPLETE_TO_INV_FLAG             VARCHAR2(4)  ,
    INVENTORY_ASSET_FLAG             VARCHAR2(4)  ,
    RELEASED_DATE                    TIMESTAMP(6) ,
    CLOSED_DATE                      TIMESTAMP(6) ,
    COMPLETION_DATE                  TIMESTAMP(6) ,
    INVENTORY_ORGANIZATION_ID        NUMBER(18, 0)    NOT NULL,
    INVENTORY_ITEM_ID                NUMBER(18, 0)    NOT NULL,
    MNT_TRANSFORM_TO_ITEM_ID         NUMBER(18, 0),
    PJC_PROJECT_ID                   NUMBER(18, 0),
    PJC_TASK_ID                      NUMBER(18, 0),
    COUNTRY_OF_ORIGIN_CODE           VARCHAR2(8)  ,
    CURRENCY_CODE                    VARCHAR2(80) ,
    OUTPUT_QUANTITY                  NUMBER       ,
    INPUT_COST                       NUMBER       ,
    OUTPUT_COST                      NUMBER       ,
    PRIMARY_OUTPUT_COST              NUMBER       ,
    WIP_BALANCE                      NUMBER       ,
    REWORK_AMOUNT                    NUMBER       ,
    SCRAP_IN_INVENTORY_COST          NUMBER       ,
    SCRAP_EXPENSE_COST               NUMBER       ,
    VARIANCE_COST                    NUMBER       ,
    VARIANCE_PERCENT                 NUMBER       ,
    SCRAP_PERCENT                    NUMBER       ,
    TOTAL_COST                       NUMBER       ,
    MATERIAL_COST                    NUMBER       ,
    RESOURCE_COST                    NUMBER       ,
    OVERHEAD_COST                    NUMBER       ,
    ENABLE_PARALLEL_OPS_FLAG         VARCHAR2(4)  
);
