VIEW: APPS.CST_ELEMENT_COST_VIEW

Source

View Text - Preformatted

SELECT USERENV('SESSIONID') , CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID , CICD.COST_TYPE_ID , NULL , NULL , NULL , NULL , NULL , SUM(CICD.ITEM_COST) , NVL(CICD.COST_ELEMENT_ID,-1) , SUM(DECODE(CICD.LEVEL_TYPE,'1', CICD.ITEM_COST,0)) , SUM(DECODE(CICD.LEVEL_TYPE,'2', CICD.ITEM_COST,0)) , CCE.COST_ELEMENT , NULL , NULL , CCE.COST_ELEMENT , CCE.DESCRIPTION , NULL , CCE.COST_ELEMENT , CCE.DESCRIPTION FROM CST_ITEM_COST_DETAILS CICD , CST_COST_ELEMENTS CCE WHERE CCE.COST_ELEMENT_ID (+) = CICD.COST_ELEMENT_ID GROUP BY USERENV('SESSIONID') ,CICD.INVENTORY_ITEM_ID , CICD.ORGANIZATION_ID , CICD.COST_TYPE_ID , CICD.COST_ELEMENT_ID , CCE.COST_ELEMENT , CCE.DESCRIPTION

View Text - HTML Formatted

SELECT USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, SUM(CICD.ITEM_COST)
, NVL(CICD.COST_ELEMENT_ID
, -1)
, SUM(DECODE(CICD.LEVEL_TYPE
, '1'
, CICD.ITEM_COST
, 0))
, SUM(DECODE(CICD.LEVEL_TYPE
, '2'
, CICD.ITEM_COST
, 0))
, CCE.COST_ELEMENT
, NULL
, NULL
, CCE.COST_ELEMENT
, CCE.DESCRIPTION
, NULL
, CCE.COST_ELEMENT
, CCE.DESCRIPTION
FROM CST_ITEM_COST_DETAILS CICD
, CST_COST_ELEMENTS CCE
WHERE CCE.COST_ELEMENT_ID (+) = CICD.COST_ELEMENT_ID GROUP BY USERENV('SESSIONID')
, CICD.INVENTORY_ITEM_ID
, CICD.ORGANIZATION_ID
, CICD.COST_TYPE_ID
, CICD.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, CCE.DESCRIPTION