[Home] [Help]
View: CST_LAYER_COST_DETAILS_V
View Text
SELECT MAX(CLCD.ROWID)
, CQL.INVENTORY_ITEM_ID
, CQL.ORGANIZATION_ID
, CLCD.LAYER_ID
, CLCD.LEVEL_TYPE
, LU3.MEANING
, SUM(CLCD.ITEM_COST)
, CCE.COST_ELEMENT
, CLCD.COST_ELEMENT_ID
FROM CST_LAYER_COST_DETAILS CLCD
, MFG_LOOKUPS LU3
, CST_COST_ELEMENTS CCE
, CST_QUANTITY_LAYERS CQL
WHERE LU3.LOOKUP_CODE (+) = CLCD.LEVEL_TYPE
AND LU3.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND CCE.COST_ELEMENT_ID = CLCD.COST_ELEMENT_ID
AND CLCD.LAYER_ID = CQL.LAYER_ID GROUP BY CQL.INVENTORY_ITEM_ID
, CQL.ORGANIZATION_ID
, CLCD.LAYER_ID
, CLCD.LEVEL_TYPE
, LU3.MEANING
, CCE.COST_ELEMENT
, CLCD.COST_ELEMENT_ID
Columns
Name |
ROW_ID |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
LAYER_ID |
LEVEL_TYPE |
LEVEL_TYPE_DSP |
ITEM_COST |
COST_ELEMENT |
COST_ELEMENT_ID |