VIEW: APPS.MTL_PAC_TXN_COST_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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