CST_ROLLUP_WORKCENTERS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
NODE_NAME ROLLUP_HEADER_KEY ROLLUP_HEADER_TYPE WORK_DEFINITION_NAME WORK_DEFINITION_ID PARENT_WD_ID PARENT_WO_ID PARENT_ITEM_ID INVENTORY_ITEM_ID WORK_CENTER_ID WORK_CENTER_CODE SCENARIO_ID SCENARIO_EVENT_ID UNIT_COST EXTENDED_COST

Query

SQL_Statement

select wc.WORK_CENTER_CODE node_name, wc.WORK_CENTER_ID ROLLUP_HEADER_KEY, 'WORKCENTER' ROLLUP_HEADER_TYPE, wc.WORK_DEFINITION_NAME, wc.WORK_DEFINITION_ID WORK_DEFINITION_ID , wc.WORK_DEFINITION_ID PARENT_WD_ID, null PARENT_WO_ID, wc.PARENT_ITEM_ID, wc.PARENT_ITEM_ID INVENTORY_ITEM_ID, wc.WORK_CENTER_ID WORK_CENTER_ID, wc.WORK_CENTER_CODE WORK_CENTER_CODE, wc.SCENARIO_ID, wc.SCENARIO_EVENT_ID, sum(wc.unit_cost) unit_cost, sum(wc.extended_cost) extended_cost from (select crov.WORK_CENTER_CODE node_name, crov.WORK_CENTER_ID ROLLUP_HEADER_KEY, 'WORKCENTER' ROLLUP_HEADER_TYPE, crov.WORK_DEFINITION_NAME, crov.WORK_DEFINITION_ID WORK_DEFINITION_ID , crov.WORK_DEFINITION_ID PARENT_WD_ID, null PARENT_WO_ID, crov.PARENT_ITEM_ID, crov.WORK_CENTER_ID WORK_CENTER_ID, crov.WORK_CENTER_CODE WORK_CENTER_CODE, crov.SCENARIO_ID, crov.SCENARIO_EVENT_ID, crov.unit_cost unit_cost, crov.extended_cost extended_cost from CST_ROLLUP_OPERATIONS_V crov where crov.USE_WORK_CENTER_FLAG='Y' union all select crov.WORK_CENTER_CODE node_name, crov.WORK_CENTER_ID ROLLUP_HEADER_KEY, 'WORKCENTER' ROLLUP_HEADER_TYPE, crov.WORK_DEFINITION_NAME, crov.WORK_DEFINITION_ID WORK_DEFINITION_ID , crov.WORK_DEFINITION_ID PARENT_WD_ID, null PARENT_WO_ID, crov.PARENT_ITEM_ID, crov.WORK_CENTER_ID WORK_CENTER_ID, crov.WORK_CENTER_CODE WORK_CENTER_CODE, crov.SCENARIO_ID, crov.SCENARIO_EVENT_ID, crov.unit_cost unit_cost, crov.extended_cost extended_cost from CST_ROLLUP_OVERHEADS_V crov where crov.USE_WORK_CENTER_FLAG='Y' and crov.ROLLUP_HEADER_TYPE = 'OVERHEADS_WORKCENTER' ) wc group by wc.WORK_CENTER_CODE, wc.WORK_CENTER_ID, 'WORKCENTER', wc.WORK_DEFINITION_NAME, wc.WORK_DEFINITION_ID, wc.WORK_DEFINITION_ID, null, wc.WORK_CENTER_ID, wc.WORK_CENTER_CODE, wc.SCENARIO_ID, wc.SCENARIO_EVENT_ID, wc.PARENT_ITEM_ID