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
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
|
|
|