View: CST_LAYER_COST_DETAILS_V

Product:	BOM - Bills of Material
Description:	Costs by layer, level and cost element
Implementation/DBA Data:	APPS.CST_LAYER_COST_DETAILS_V

View Text

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

Columns