Item cost history table in oracle apps r12

Item cost history table in oracle apps r12

In this post , we will be discuss about the item cost history table in oracle apps r12. We can get the item cost history for the inventory items from application itself but if we want to extract the item cost history information from backend then we need to know the item cost history table. Using item cost history table , we can track the history for the item cost in oracle apps. Here below , is the most important item cost history table and the sql query to extract the item cost history information’s in oracle apps r12.

Most Important item cost history table in oracle apps r12

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 Extract Item Cost History Information using Item cost history table in r12

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