CREATE TABLE cst_rollup_reports (
    ROLLUP_REPORT_ID               NUMBER(18, 0) ,
    OP_CUM_YIELD_FACTOR            NUMBER        ,
    OP_REV_YIELD_FACTOR            NUMBER        ,
    OP_YIELD_FACTOR                NUMBER        ,
    CONTRIBUTE_TO_YIELD_FLAG       VARCHAR2(120) ,
    SCENARIO_ID                    NUMBER(18, 0)     NOT NULL,
    EFFECTIVE_START_DATE           DATE              NOT NULL,
    ROOT_ASSEMBLY_ITEM_ID          NUMBER        ,
    ROOT_ASSEMBLY_ORG_ID           NUMBER        ,
    ASSEMBLY_ITEM_ID               NUMBER        ,
    ASSEMBLY_ORG_ID                NUMBER        ,
    DISPLAY_NAME                   VARCHAR2(4000),
    ROLLUP_HEADER_KEY              VARCHAR2(480) ,
    ROLLUP_HEADER_TYPE             VARCHAR2(120) ,
    PARENT_ROLLUP_HEADER_KEY       VARCHAR2(480) ,
    PARENT_ROLLUP_HEADER_TYPE      VARCHAR2(120) ,
    STATUS_CODE                    VARCHAR2(120) ,
    CURRENCY_CODE                  VARCHAR2(320) ,
    MATERIAL_COST                  NUMBER        ,
    RESOURCE_COST                  NUMBER        ,
    OVERHEAD_COST                  NUMBER        ,
    UNIT_COST                      NUMBER        ,
    EXTENDED_COST                  NUMBER        ,
    COST_ALLOCATION_PERCENTAGE     NUMBER        ,
    COST_ALLOCATION_FIXED          NUMBER        ,
    OUTPUT_COST                    NUMBER        ,
    SUPPLIER_ID                    NUMBER(18, 0) ,
    SUPPLIER_SITE_ID               NUMBER(18, 0) ,
    SUPPLY_ALLOCATION              NUMBER        ,
    EXTRACTION_DATE                DATE          ,
    REFERENCE_TYPE                 VARCHAR2(320) ,
    ALTERNATE_BOM_DESIGNATOR       VARCHAR2(320) ,
    WD_OPERATION_ID                NUMBER(18, 0) ,
    WORK_DEFINITION_ID             NUMBER(18, 0) ,
    WORK_DEFINITION_NAME_ID        NUMBER        ,
    BATCH_QUANTITY                 NUMBER        ,
    BATCH_UOM_CODE                 VARCHAR2(12)  ,
    COSTING_BATCH_OUTPUT_SIZE      NUMBER        ,
    PROCESS_BATCH_TYPE             VARCHAR2(120) ,
    OPERATION_SEQ_NUMBER           NUMBER        ,
    PREDECESSOR_OPS_SEQ_NUMS       VARCHAR2(4000),
    OUTPUT_QUANTITY                NUMBER        ,
    UNIT_OF_MEASURE                VARCHAR2(480) ,
    BASIS_TYPE                     VARCHAR2(120) ,
    ABSORPTION_TYPE                VARCHAR2(120) ,
    OVERHEAD_RATE                  VARCHAR2(160) ,
    OVERHEAD_RATE_DETAILS          VARCHAR2(3000),
    OUTPUT_TYPE                    VARCHAR2(120) ,
    ENTERED_UNIT_COST              NUMBER        ,
    ALLOCATED_MATERIAL_COST        NUMBER        ,
    ALLOCATED_RESOURCE_COST        NUMBER        ,
    ALLOCATED_OVERHEAD_COST        NUMBER        ,
    ALLOCATED_EXTENDED_COST        NUMBER        ,
    ALLOCATED_UNIT_COST            NUMBER        ,
    ALLOCATED_UNIT_COST_SR         NUMBER        ,
    ALLOCATED_MATERIAL_COST_SR     NUMBER        ,
    ALLOCATED_OVERHEAD_COST_SR     NUMBER        ,
    ALLOCATED_RESOURCE_COST_SR     NUMBER        ,
    COST_ALLOCATION_SEQ            NUMBER        ,
    OUTPUT_SEQ_NUMBER              NUMBER        ,
    RUNNING_TOTAL                  NUMBER        ,
    CUMULATIVE_EXTENDED_COST       NUMBER        ,
    RESOURCE_SEQ_NUMBER            NUMBER        ,
    COST_BOOK_ID                   NUMBER(18, 0) ,
    COST_ORG_ID                    NUMBER(18, 0) ,
    COST_ELEMENT_ID                NUMBER(18, 0) ,
    EXPENSE_POOL_ID                NUMBER(18, 0) ,
    QUANTITY                       NUMBER        ,
    QTY_UOM_CODE                   VARCHAR2(12)  ,
    COST_UOM_CODE                  VARCHAR2(12)  ,
    OVERHEAD_RATE_DETAIL_ID        NUMBER(18, 0) ,
    WORK_METHOD_CODE               VARCHAR2(120) ,
    CST_MSC_SOURCE_RULE_ID         NUMBER(18, 0) ,
    UNALLOCATED_UNIT_COST          NUMBER        ,
    VAL_UNIT_ID                    NUMBER(18, 0) ,
    RESOURCE_ID                    NUMBER(18, 0) ,
    TRANSFER_PERCENT               NUMBER        ,
    CUM_TRANSFER_PERCENT           NUMBER        ,
    YIELD_FACTOR                   NUMBER        ,
    MATERIAL_INVENTORY_ITEM_ID     NUMBER(18, 0) ,
    MATERIAL_INVENTORY_ORG_ID      NUMBER(18, 0) ,
    ORGANIZATION_ID                NUMBER(18, 0) ,
    SOURCE_INV_ORG_ID              NUMBER(18, 0) ,
    SOURCE_ORG                     VARCHAR2(1040),
    SOURCE_TYPE                    VARCHAR2(120) ,
    COST_ORG_LEVEL_COST_FLAG       VARCHAR2(4)   ,
    CUMULATIVE_UNIT_COST           NUMBER        ,
    ITEM_DESCRIPTION               VARCHAR2(960) ,
    TRANSFER_CHARGE_RULE_NAME      VARCHAR2(800) ,
    PLANT_ORG_NAME                 VARCHAR2(960) ,
    WORK_METHOD_NAME               VARCHAR2(480) ,
    WORK_DEFINITION_HEADER_NAME    VARCHAR2(480) ,
    WORK_DEFINITION_NAME           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) ,
    ROLLUP_REPORT_ID               NUMBER(18, 0) ,
    SCENARIO_ID                    NUMBER(18, 0)     NOT NULL,
    EFFECTIVE_START_DATE           DATE              NOT NULL,
    ROOT_ASSEMBLY_ITEM_ID          NUMBER        ,
    ROOT_ASSEMBLY_ORG_ID           NUMBER        ,
    ASSEMBLY_ITEM_ID               NUMBER        ,
    ASSEMBLY_ORG_ID                NUMBER        ,
    DISPLAY_NAME                   VARCHAR2(4000),
    ROLLUP_HEADER_KEY              VARCHAR2(480) ,
    ROLLUP_HEADER_TYPE             VARCHAR2(120) ,
    PARENT_ROLLUP_HEADER_KEY       VARCHAR2(480) ,
    PARENT_ROLLUP_HEADER_TYPE      VARCHAR2(120) ,
    STATUS_CODE                    VARCHAR2(120) ,
    CURRENCY_CODE                  VARCHAR2(320) ,
    MATERIAL_COST                  NUMBER        ,
    RESOURCE_COST                  NUMBER        ,
    OVERHEAD_COST                  NUMBER        ,
    UNIT_COST                      NUMBER        ,
    EXTENDED_COST                  NUMBER        ,
    COST_ALLOCATION_PERCENTAGE     NUMBER        ,
    COST_ALLOCATION_FIXED          NUMBER        ,
    OUTPUT_COST                    NUMBER        ,
    SUPPLIER_ID                    NUMBER(18, 0) ,
    SUPPLIER_SITE_ID               NUMBER(18, 0) ,
    SUPPLY_ALLOCATION              NUMBER        ,
    EXTRACTION_DATE                DATE          ,
    REFERENCE_TYPE                 VARCHAR2(320) ,
    WD_OPERATION_ID                NUMBER(18, 0) ,
    WORK_DEFINITION_ID             NUMBER(18, 0) ,
    WORK_DEFINITION_NAME_ID        NUMBER        ,
    BATCH_QUANTITY                 NUMBER        ,
    BATCH_UOM_CODE                 VARCHAR2(12)  ,
    COSTING_BATCH_OUTPUT_SIZE      NUMBER        ,
    OPERATION_SEQ_NUMBER           NUMBER        ,
    OUTPUT_QUANTITY                NUMBER        ,
    UNIT_OF_MEASURE                VARCHAR2(480) ,
    BASIS_TYPE                     VARCHAR2(120) ,
    ABSORPTION_TYPE                VARCHAR2(120) ,
    OVERHEAD_RATE                  VARCHAR2(160) ,
    OVERHEAD_RATE_DETAILS          VARCHAR2(3000),
    OUTPUT_TYPE                    VARCHAR2(120) ,
    ENTERED_UNIT_COST              NUMBER        ,
    ALLOCATED_MATERIAL_COST        NUMBER        ,
    ALLOCATED_RESOURCE_COST        NUMBER        ,
    ALLOCATED_OVERHEAD_COST        NUMBER        ,
    ALLOCATED_EXTENDED_COST        NUMBER        ,
    ALLOCATED_UNIT_COST            NUMBER        ,
    ALLOCATED_UNIT_COST_SR         NUMBER        ,
    ALLOCATED_MATERIAL_COST_SR     NUMBER        ,
    ALLOCATED_OVERHEAD_COST_SR     NUMBER        ,
    ALLOCATED_RESOURCE_COST_SR     NUMBER        ,
    COST_ALLOCATION_SEQ            NUMBER        ,
    OUTPUT_SEQ_NUMBER              NUMBER        ,
    RUNNING_TOTAL                  NUMBER        ,
    CUMULATIVE_EXTENDED_COST       NUMBER        ,
    RESOURCE_SEQ_NUMBER            NUMBER        ,
    COST_BOOK_ID                   NUMBER(18, 0) ,
    COST_ORG_ID                    NUMBER(18, 0) ,
    COST_ELEMENT_ID                NUMBER(18, 0) ,
    EXPENSE_POOL_ID                NUMBER(18, 0) ,
    QUANTITY                       NUMBER        ,
    QTY_UOM_CODE                   VARCHAR2(12)  ,
    COST_UOM_CODE                  VARCHAR2(12)  ,
    OVERHEAD_RATE_DETAIL_ID        NUMBER(18, 0) ,
    WORK_METHOD_CODE               VARCHAR2(120) ,
    CST_MSC_SOURCE_RULE_ID         NUMBER(18, 0) ,
    UNALLOCATED_UNIT_COST          NUMBER        ,
    VAL_UNIT_ID                    NUMBER(18, 0) ,
    RESOURCE_ID                    NUMBER(18, 0) ,
    YIELD_FACTOR                   NUMBER        ,
    MATERIAL_INVENTORY_ITEM_ID     NUMBER(18, 0) ,
    MATERIAL_INVENTORY_ORG_ID      NUMBER(18, 0) ,
    ORGANIZATION_ID                NUMBER(18, 0) ,
    SOURCE_INV_ORG_ID              NUMBER(18, 0) ,
    SOURCE_ORG                     VARCHAR2(1040),
    COST_ORG_LEVEL_COST_FLAG       VARCHAR2(4)   ,
    CUMULATIVE_UNIT_COST           NUMBER        ,
    ITEM_DESCRIPTION               VARCHAR2(960) ,
    TRANSFER_CHARGE_RULE_NAME      VARCHAR2(800) ,
    PLANT_ORG_NAME                 VARCHAR2(960) ,
    WORK_METHOD_NAME               VARCHAR2(480) ,
    WORK_DEFINITION_HEADER_NAME    VARCHAR2(480) ,
    WORK_DEFINITION_NAME           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) ,
    OP_REV_YIELD_FACTOR            NUMBER        ,
    OP_YIELD_FACTOR                NUMBER        ,
    SOURCE_TYPE                    VARCHAR2(120) ,
    OP_CUM_YIELD_FACTOR            NUMBER        ,
    ALTERNATE_BOM_DESIGNATOR       VARCHAR2(320) ,
    CONTRIBUTE_TO_YIELD_FLAG       VARCHAR2(120) ,
    PROCESS_BATCH_TYPE             VARCHAR2(120) ,
    PREDECESSOR_OPS_SEQ_NUMS       VARCHAR2(4000),
    TRANSFER_PERCENT               NUMBER        ,
    CUM_TRANSFER_PERCENT           NUMBER        ,
    CONSTRAINT pk_cst_rollup_reports PRIMARY KEY (ROLLUP_REPORT_ID, ROLLUP_REPORT_ID)
);
