View: CST_LAYER_ACTUAL_COSTS_V

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

View Text

SELECT 'MCACD'
, MCACD.ORGANIZATION_ID
, MCACD.LAYER_ID
, 0
, MCACD.TRANSACTION_ID
, MCACD.COST_ELEMENT_ID
, MCACD.LEVEL_TYPE
, MCACD.ACTUAL_COST
FROM MTL_CST_ACTUAL_COST_DETAILS MCACD
WHERE MCACD.USER_ENTERED = 'Y' UNION SELECT 'MCTCD'
, MCTCD.ORGANIZATION_ID
, 0
, 0
, MCTCD.TRANSACTION_ID
, MCTCD.COST_ELEMENT_ID
, MCTCD.LEVEL_TYPE
, MCTCD.TRANSACTION_COST
FROM MTL_CST_TXN_COST_DETAILS MCTCD UNION SELECT 'CILCD'
, CIL.ORGANIZATION_ID
, CIL.LAYER_ID
, CIL.INV_LAYER_ID
, 0
, CILCD.COST_ELEMENT_ID
, CILCD.LEVEL_TYPE
, CILCD.LAYER_COST
FROM CST_INV_LAYERS CIL
, CST_INV_LAYER_COST_DETAILS CILCD
WHERE CIL.INV_LAYER_ID = CILCD.INV_LAYER_ID
AND CIL.LAYER_ID = CILCD.LAYER_ID

Columns