[Home] [Help]
View: 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 |