eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CST_PAC_ITEM_COSTS_V

Product:	BOM - Bills of Material
Description:	Summarizes the cost elemental values in CST_PAC_ITEM_COST_DETAILS
Implementation/DBA Data:	APPS.CST_PAC_ITEM_COSTS_V

View Text

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

Columns

Name
COST_LAYER_ID
PL_MATERIAL
PL_MATERIAL_OVERHEAD
PL_RESOURCE
PL_OUTSIDE_PROCESSING
PL_OVERHEAD
TL_MATERIAL
TL_MATERIAL_OVERHEAD
TL_RESOURCE
TL_OUTSIDE_PROCESSING
TL_OVERHEAD
MATERIAL_COST
MATERIAL_OVERHEAD_COST
RESOURCE_COST
OUTSIDE_PROCESSING_COST
OVERHEAD_COST
PL_ITEM_COST
TL_ITEM_COST
ITEM_COST
ITEM_BUY_COST
ITEM_MAKE_COST
UNBURDENED_COST
BURDEN_COST