VIEW: APPS.CST_PAC_ITEM_COSTS_V

Source

View Text - Preformatted

SELECT COST_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(ITEM_BUY_COST), SUM(ITEM_MAKE_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_PAC_ITEM_COST_DETAILS GROUP BY COST_LAYER_ID

View Text - HTML Formatted

SELECT COST_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(ITEM_BUY_COST)
, SUM(ITEM_MAKE_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_PAC_ITEM_COST_DETAILS GROUP BY COST_LAYER_ID