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.

VIEW: APPS.CST_LAYER_ACTUAL_COSTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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