[Home] [Help]
View: MTL_CST_TXN_COST_DETAILS_V
View Text
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'
Columns
| Name |
| ROW_ID |
| TRANSACTION_ID |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| LEVEL_TYPE |
| LEVEL_TYPE_DSP |
| ITEM_COST |
| COST_ELEMENT |
| COST_ELEMENT_ID |
| NEW_AVERAGE_COST |
| PERCENTAGE_CHANGE |
| VALUE_CHANGE |
APPS.MTL_CST_TXN_COST_DETAILS_V