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.MTL_CST_TXN_COST_DETAILS_V

Source

View Text - Preformatted


SELECT MCTD.rowid, MCTD.transaction_id, MCTD.inventory_item_id, MCTD.organization_id, MCTD.level_type, LU3.meaning, MCTD.transaction_cost, CCE.cost_element, MCTD.cost_element_id, MCTD.new_average_cost, MCTD.percentage_change, MCTD.value_change FROM CST_COST_ELEMENTS CCE, MTL_CST_TXN_COST_DETAILS MCTD, MFG_LOOKUPS LU3 WHERE CCE.cost_element_id = MCTD.cost_element_id AND LU3.LOOKUP_CODE = MCTD.level_type AND LU3.LOOKUP_TYPE = 'CST_LEVEL'

View Text - HTML Formatted

SELECT MCTD.ROWID
, MCTD.TRANSACTION_ID
, MCTD.INVENTORY_ITEM_ID
, MCTD.ORGANIZATION_ID
, MCTD.LEVEL_TYPE
, LU3.MEANING
, MCTD.TRANSACTION_COST
, CCE.COST_ELEMENT
, MCTD.COST_ELEMENT_ID
, MCTD.NEW_AVERAGE_COST
, MCTD.PERCENTAGE_CHANGE
, MCTD.VALUE_CHANGE
FROM CST_COST_ELEMENTS CCE
, MTL_CST_TXN_COST_DETAILS MCTD
, MFG_LOOKUPS LU3
WHERE CCE.COST_ELEMENT_ID = MCTD.COST_ELEMENT_ID
AND LU3.LOOKUP_CODE = MCTD.LEVEL_TYPE
AND LU3.LOOKUP_TYPE = 'CST_LEVEL'