I can see the cost of the particular item in the 'Item Cost History' form of Oracle Apps for a specified date.
If i wanted to see the same in back end table, what table should i refer?
MTL_CST_ACTUAL_COST_DETAILS, MTL_CST_TXN_COST_DETAILS & CST_LAYER_COST_DETAILS.
What is the relationship among these tables? Are there any relationship to these tables from other tables??
Edited by: Arun Prasath on Jan 21, 2013 8:21 PM
Me itself found the answer. Here i'm giving the query for others to use..
FROM MTL_CST_ACTUAL_COST_DETAILS MACD
WHERE COST_ELEMENT_ID IN (1,2,3,4)
AND MACD.ORGANIZATION_ID= 'Organization_id'
AND MACD.INVENTORY_ITEM_ID= 'Item ID'
AND TRANSACTION_ID= (SELECT MAX(MACD2.TRANSACTION_ID)
FROM APPS.MTL_CST_ACTUAL_COST_DETAILS MACD2
WHERE MACD2.INVENTORY_ITEM_ID= 'Item ID'
AND TRUNC(MACD2.TRANSACTION_COSTED_DATE) <= 'The desired date'
AND MACD2.ORGANIZATION_ID= 'Organization_id')
GROUP BY COST_ELEMENT_ID
This query will give the various costs like Material cost, Resource cost, Overhead cost, Outside processing cost and Material Overhead cost of a particular item.
Thank you.. :)