View: MTL_PAC_TXN_COST_DETAILS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_PAC_TXN_COST_DETAILS_V

View Text

SELECT MPTCD.ROWID ROW_ID
, MPTCD.TRANSACTION_ID
, MPTCD.COST_TYPE_ID
, MPTCD.COST_GROUP_ID
, MPTCD.INVENTORY_ITEM_ID
, MPTCD.LEVEL_TYPE
, LU.MEANING LEVEL_TYPE_DSP
, MPTCD.TRANSACTION_COST PRIOR_PERIOD_COST
, CCE.COST_ELEMENT
, MPTCD.COST_ELEMENT_ID
, MPTCD.NEW_PERIODIC_COST
, MPTCD.PERCENTAGE_CHANGE
, MPTCD.VALUE_CHANGE
FROM MTL_PAC_TXN_COST_DETAILS MPTCD
, MFG_LOOKUPS LU
, CST_COST_ELEMENTS CCE
WHERE LU.LOOKUP_CODE (+) = MPTCD.LEVEL_TYPE
AND LU.LOOKUP_TYPE (+) = 'CST_LEVEL'
AND CCE.COST_ELEMENT_ID = MPTCD.COST_ELEMENT_ID

Columns