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_INV_LAYER_COST_DETAILS_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_INV_LAYER_COST_DETAILS_V

View Text

SELECT CIL.INVENTORY_ITEM_ID
, CIL.ORGANIZATION_ID
, CILCD.LAYER_ID
, CILCD.INV_LAYER_ID
, CILCD.LEVEL_TYPE
, LU3.MEANING
, SUM(CILCD.LAYER_COST)
, CCE.COST_ELEMENT
, CILCD.COST_ELEMENT_ID
FROM CST_INV_LAYER_COST_DETAILS CILCD
, MFG_LOOKUPS LU3
, CST_COST_ELEMENTS CCE
, CST_INV_LAYERS CIL
WHERE LU3.LOOKUP_CODE (+) = CILCD.LEVEL_TYPE
AND LU3.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND CCE.COST_ELEMENT_ID = CILCD.COST_ELEMENT_ID
AND CILCD.LAYER_ID = CIL.LAYER_ID
AND CILCD.INV_LAYER_ID = CIL.INV_LAYER_ID GROUP BY CIL.INVENTORY_ITEM_ID
, CIL.ORGANIZATION_ID
, CILCD.LAYER_ID
, CILCD.INV_LAYER_ID
, CILCD.LEVEL_TYPE
, LU3.MEANING
, CCE.COST_ELEMENT
, CILCD.COST_ELEMENT_ID

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
LAYER_ID
INV_LAYER_ID
LEVEL_TYPE
MEANING
LAYER_COST
COST_ELEMENT
COST_ELEMENT_ID