Cost Management tables in oracle apps r12

Cost Management tables in oracle apps r12

In this post , We will be discuss about Cost Management tables in oracle apps r12. Cost Management tables related to the Item costing details which helps to store the cost related informations in oracle apps. We do get the item costing details using cost management tables in oracle apps r12. I will share some of the important cost management tables and the sql query using the cost management tables to extract the item costing details in oracle apps. Using cost management tables , we can tract the item costing hosting history informations too in oracle apps r12. Please find below the Cost Management tables in oracle apps r12.

Cost Management tables 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 using Cost Management tables in oracle apps r12

Here below is the sql query which helps to extract the  item costing detail in oracle apps. 

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