VIEW: APPS.CST_LAYER_COST_DETAILS_V

Source

View Text - Preformatted

SELECT max(CLCD.rowid), CQL.inventory_item_id, CQL.organization_id, CLCD.layer_id, CLCD.level_type, LU3.meaning, sum(CLCD.item_cost), CCE.cost_element, CLCD.cost_element_id FROM CST_LAYER_COST_DETAILS CLCD, MFG_LOOKUPS LU3, CST_COST_ELEMENTS CCE, CST_QUANTITY_LAYERS CQL where LU3.lookup_code (+) = CLCD.level_type AND LU3.lookup_type (+) = 'CST_LEVEL' AND CCE.cost_element_id = CLCD.cost_element_id AND CLCD.layer_id = CQL.layer_id GROUP BY CQL.inventory_item_id, CQL.organization_id, CLCD.layer_id, CLCD.level_type, LU3.meaning, CCE.cost_element, CLCD.cost_element_id

View Text - HTML Formatted

SELECT MAX(CLCD.ROWID)
, CQL.INVENTORY_ITEM_ID
, CQL.ORGANIZATION_ID
, CLCD.LAYER_ID
, CLCD.LEVEL_TYPE
, LU3.MEANING
, SUM(CLCD.ITEM_COST)
, CCE.COST_ELEMENT
, CLCD.COST_ELEMENT_ID
FROM CST_LAYER_COST_DETAILS CLCD
, MFG_LOOKUPS LU3
, CST_COST_ELEMENTS CCE
, CST_QUANTITY_LAYERS CQL
WHERE LU3.LOOKUP_CODE (+) = CLCD.LEVEL_TYPE
AND LU3.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND CCE.COST_ELEMENT_ID = CLCD.COST_ELEMENT_ID
AND CLCD.LAYER_ID = CQL.LAYER_ID GROUP BY CQL.INVENTORY_ITEM_ID
, CQL.ORGANIZATION_ID
, CLCD.LAYER_ID
, CLCD.LEVEL_TYPE
, LU3.MEANING
, CCE.COST_ELEMENT
, CLCD.COST_ELEMENT_ID