VIEW: APPS.CST_INV_LAYER_COST_DETAILS_V

Source

View Text - Preformatted

SELECT CIL.inventory_item_id , CIL.organization_id , CILCD.layer_id , CILCD.inv_layer_id , CILCD.level_type , LU3.meaning , sum(CILCD.layer_cost) , CCE.cost_element , CILCD.cost_element_id FROM CST_INV_LAYER_COST_DETAILS CILCD , MFG_LOOKUPS LU3 , CST_COST_ELEMENTS CCE , CST_INV_LAYERS CIL WHERE LU3.lookup_code (+) = CILCD.level_type AND LU3.lookup_type (+) = 'CST_LEVEL' AND CCE.cost_element_id = CILCD.cost_element_id AND CILCD.layer_id = CIL.layer_id AND CILCD.inv_layer_id = CIL.inv_layer_id GROUP BY CIL.inventory_item_id , CIL.organization_id , CILCD.layer_id , CILCD.inv_layer_id , CILCD.level_type , LU3.meaning , CCE.cost_element , CILCD.cost_element_id

View Text - HTML Formatted

SELECT CIL.INVENTORY_ITEM_ID
, CIL.ORGANIZATION_ID
, CILCD.LAYER_ID
, CILCD.INV_LAYER_ID
, CILCD.LEVEL_TYPE
, LU3.MEANING
, SUM(CILCD.LAYER_COST)
, CCE.COST_ELEMENT
, CILCD.COST_ELEMENT_ID
FROM CST_INV_LAYER_COST_DETAILS CILCD
, MFG_LOOKUPS LU3
, CST_COST_ELEMENTS CCE
, CST_INV_LAYERS CIL
WHERE LU3.LOOKUP_CODE (+) = CILCD.LEVEL_TYPE
AND LU3.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND CCE.COST_ELEMENT_ID = CILCD.COST_ELEMENT_ID
AND CILCD.LAYER_ID = CIL.LAYER_ID
AND CILCD.INV_LAYER_ID = CIL.INV_LAYER_ID GROUP BY CIL.INVENTORY_ITEM_ID
, CIL.ORGANIZATION_ID
, CILCD.LAYER_ID
, CILCD.INV_LAYER_ID
, CILCD.LEVEL_TYPE
, LU3.MEANING
, CCE.COST_ELEMENT
, CILCD.COST_ELEMENT_ID