1 Reply Latest reply: Feb 2, 2013 12:33 AM by Arun Prasath RSS

    What is cost of a particular item?

    Arun Prasath
      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
          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.. :)