VIEW: APPS.CST_ACTIVITY_DEPT_COST_VIEW

Source

View Text - Preformatted

SELECT USERENV('sessionid') , CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID , CICD.COST_TYPE_ID , NULL , NULL , NVL(CICD.DEPARTMENT_ID,-1) , 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 , OD.DEPARTMENT_CODE , OD.DESCRIPTION , CA.ACTIVITY , OD.DEPARTMENT_CODE , OD.DESCRIPTION FROM CST_ITEM_COST_DETAILS CICD, BOM_DEPARTMENTS OD, CST_ACTIVITIES CA WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID AND OD.DEPARTMENT_ID (+) = CICD.DEPARTMENT_ID GROUP BY USERENV('SESSIONID'),CICD.INVENTORY_ITEM_ID, CICD.ORGANIZATION_ID,CICD.COST_TYPE_ID, CICD.DEPARTMENT_ID, CICD.ACTIVITY_ID, CA.ACTIVITY, OD.DEPARTMENT_CODE, OD.DESCRIPTION

View Text - HTML Formatted

SELECT USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, NULL
, NULL
, NVL(CICD.DEPARTMENT_ID
, -1)
, 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
, OD.DEPARTMENT_CODE
, OD.DESCRIPTION
, CA.ACTIVITY
, OD.DEPARTMENT_CODE
, OD.DESCRIPTION
FROM CST_ITEM_COST_DETAILS CICD
, BOM_DEPARTMENTS OD
, CST_ACTIVITIES CA
WHERE CA.ACTIVITY_ID (+) = CICD.ACTIVITY_ID
AND OD.DEPARTMENT_ID (+) = CICD.DEPARTMENT_ID GROUP BY USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.DEPARTMENT_ID
, CICD.ACTIVITY_ID
, CA.ACTIVITY
, OD.DEPARTMENT_CODE
, OD.DESCRIPTION