Query to get item cost history in oracle apps

Query to get item cost history in oracle apps

In this post, We will be discuss about the sql query to get item cost history in oracle apps. I will share the sql query to which will help to extract the complete item cost history details in oracle apps. We need to use the item cost history table to write the sql query to get item cost history table in oracle apps. Here below is the most important cost history table and the detail sql query to get item cost history in oracle apps r12.

5 Most Important used by Query to get item cost history in oracle apps

   1. mtl_cst_actual_cost_details

   2.cst_cost_types

  3.cst_item_costs

   4.mtl_system_items_b

  5.mtl_parameters

Detail SQL Query to get item cost history in oracle apps

Here below is the sql query to extract the item costing informations in oracle. We will get the complete item cost history details using this query.

SELECT   msb.segment1 item_name,

Msb.description item_description,

mmt.transaction_date,

mtt.transaction_type_name,

mmt.transaction_quantity,

mcd.prior_cost,

mcd.new_cost

FROM mtl_cst_actual_cost_details mcd,

mtl_system_items_b msb,

mtl_material_transactions mmt,

mtl_transaction_types mtt

WHERE 1 =

AND mcd.transaction_id = mmt.transaction_id

AND mmt.inventory_item_id = msi.inventory_item_id

AND mcd.inventory_item_id = msb.inventory_item_id

AND mmt.organization_id = msi.organization_id

AND mmt.transaction_type_id = mtt.transaction_type_id

AND mcd.organization_id = msb.organization_id

ORDER BY mcd.creation_date DESC