View: CST_ACTIVITY_OP_COST_VIEW

Product:	BOM - Bills of Material
Description:	Item cost by activity and operation : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ACTIVITY_OP_COST_VIEW

View Text

SELECT USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, NVL(CICD.OPERATION_SEQ_NUM
, -1)
, NVL(CICD.OPERATION_SEQUENCE_ID
, -1)
, NULL
, NVL(CICD.ACTIVITY_ID
, -1)
, NULL
, SUM(CICD.ITEM_COST)
, NULL
, SUM(DECODE(CICD.LEVEL_TYPE
, '1'
, CICD.ITEM_COST
, 0))
, SUM(DECODE(CICD.LEVEL_TYPE
, '2'
, CICD.ITEM_COST
, 0))
, NULL
, NULL
, CA.ACTIVITY
, CICD.OPERATION_SEQ_NUM
, BOS.OPERATION_DESCRIPTION
, CA.ACTIVITY
, CICD.OPERATION_SEQ_NUM
, BOS.OPERATION_DESCRIPTION
FROM CST_ITEM_COST_DETAILS CICD
, BOM_OPERATION_SEQUENCES BOS
, CST_ACTIVITIES CA
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID
AND BOS.OPERATION_SEQUENCE_ID (+)= CICD.OPERATION_SEQUENCE_ID GROUP BY USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.OPERATION_SEQ_NUM
, CICD.OPERATION_SEQUENCE_ID
, CICD.ACTIVITY_ID
, CA.ACTIVITY
, BOS.OPERATION_DESCRIPTION

Columns