Product: | BOM - Bills of Material |
---|---|
Description: | Item costs for each layer by element and by level |
Implementation/DBA Data: | APPS.CST_QUANTITY_LAYERS_V |
SELECT LAYER_ID
, SUM(DECODE(LEVEL_TYPE
, 2
, DECODE(COST_ELEMENT_ID
, 1
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 2
, DECODE(COST_ELEMENT_ID
, 2
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 2
, DECODE(COST_ELEMENT_ID
, 3
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 2
, DECODE(COST_ELEMENT_ID
, 4
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 2
, DECODE(COST_ELEMENT_ID
, 5
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, DECODE(COST_ELEMENT_ID
, 1
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, DECODE(COST_ELEMENT_ID
, 2
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, DECODE(COST_ELEMENT_ID
, 3
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, DECODE(COST_ELEMENT_ID
, 4
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, DECODE(COST_ELEMENT_ID
, 5
, ITEM_COST
, 0)
, 0))
, SUM(DECODE(COST_ELEMENT_ID
, 1
, ITEM_COST
, 0))
, SUM(DECODE(COST_ELEMENT_ID
, 2
, ITEM_COST
, 0))
, SUM(DECODE(COST_ELEMENT_ID
, 3
, ITEM_COST
, 0))
, SUM(DECODE(COST_ELEMENT_ID
, 4
, ITEM_COST
, 0))
, SUM(DECODE(COST_ELEMENT_ID
, 5
, ITEM_COST
, 0))
, SUM(DECODE(LEVEL_TYPE
, 2
, ITEM_COST
, 0))
, SUM(DECODE(LEVEL_TYPE
, 1
, ITEM_COST
, 0))
, SUM(ITEM_COST)
, SUM(DECODE(COST_ELEMENT_ID
, 2
, DECODE(LEVEL_TYPE
, 2
, ITEM_COST
, 0)
, ITEM_COST))
, SUM(DECODE(COST_ELEMENT_ID
, 2
, DECODE(LEVEL_TYPE
, 1
, ITEM_COST
, 0)
, 0))
FROM CST_LAYER_COST_DETAILS GROUP BY LAYER_ID