CST_WO_COSTS_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID PLANT_ID CST_WORK_ORDER_ID COST_BOOK_CURRENCY_CODE WO_SYSTEM_STATUS_CODE PRIOR_WO_SYSTEM_STATUS_CODE EVENT_DATE TOTAL_COST SCRAP_COST VARIANCE_COST

Query

SQL_Statement

SELECT CWOC.COST_ORG_ID, CWOC.COST_BOOK_ID, CWO.INVENTORY_ORGANIZATION_ID PLANT_ID, CWOC.CST_WORK_ORDER_ID, CWOC.CURRENCY_CODE AS COST_BOOK_CURRENCY_CODE, NVL(CWUE.WO_SYSTEM_STATUS_CODE,WWSV.WO_SYSTEM_STATUS_CODE) WO_SYSTEM_STATUS_CODE, PRIOR_WO_SYSTEM_STATUS_CODE, NVL(CWUE.EVENT_DATE,CWO.RELEASED_DATE) AS EVENT_DATE, SUM( WIP_TXN_SIGN * QUANTITY * DECODE(WIP_COST_TYPE,'RESOURCE',UNIT_COST,'COMPONENT',UNIT_COST,null) ) as TOTAL_COST, ABS(SUM( WIP_TXN_SIGN * QUANTITY * DECODE(WIP_COST_TYPE,'SCRAP',UNIT_COST,null) ) ) as SCRAP_COST, SUM( WIP_TXN_SIGN * QUANTITY * DECODE(WIP_COST_TYPE,'VARIANCE',UNIT_COST,null) ) as VARIANCE_COST FROM CST_WORK_ORDER_COSTS CWOC, CST_WORK_ORDERS CWO, CST_WO_UPDATE_EVENTS CWUE, WIE_WO_STATUSES_VL WWSV WHERE CWO.CST_WORK_ORDER_ID = CWOC.CST_WORK_ORDER_ID AND CWOC.CST_WORK_ORDER_ID = CWUE.CST_WORK_ORDER_ID(+) AND CWUE.LATEST_STATUS_FLAG(+) = 'Y' AND CWO.WORK_ORDER_STATUS_ID = WWSV.WO_STATUS_ID GROUP BY CWOC.COST_ORG_ID, CWOC.COST_BOOK_ID, CWOC.CST_WORK_ORDER_ID, CWOC.CURRENCY_CODE, CWO.INVENTORY_ORGANIZATION_ID, CWUE.WO_SYSTEM_STATUS_CODE, CWUE.EVENT_DATE, CWO.RELEASED_DATE, WWSV.WO_SYSTEM_STATUS_CODE, PRIOR_WO_SYSTEM_STATUS_CODE