View: CST_AVG_ELEM_COSTS_V

Product:	BOM - Bills of Material
Description:	Used by average cost update form
Implementation/DBA Data:	APPS.CST_AVG_ELEM_COSTS_V

View Text

SELECT CLCD.LAYER_ID
, CCE.COST_ELEMENT_ID
, CCE.COST_ELEMENT
, SUM(DECODE(CLCD.LEVEL_TYPE
, 1
, CLCD.ITEM_COST
, 0))
, SUM(DECODE(CLCD.LEVEL_TYPE
, 2
, CLCD.ITEM_COST
, 0))
, SUM(CLCD.ITEM_COST)
FROM CST_LAYER_COST_DETAILS CLCD
, CST_COST_ELEMENTS CCE
WHERE CLCD.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID GROUP BY CLCD.LAYER_ID
, CLCD.COST_ELEMENT_ID
, CCE.COST_ELEMENT_ID
, CCE.COST_ELEMENT

Columns