This discussion is archived
1 Reply Latest reply: Feb 1, 2013 10:33 PM by Arun Prasath RSS

What is cost of a particular item?

Arun Prasath Newbie
Currently Being Moderated
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
  • 1. Re: What is cost of a particular item?
    Arun Prasath Newbie
    Currently Being Moderated
    Me itself found the answer. Here i'm giving the query for others to use..

    SELECT COST_ELEMENT_ID,SUM(MACD.ACTUAL_COST)
         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.. :)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points