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
3 comments:
Resource cost details needed to me, can anyone help me
okay great
Get Small Business Inventory Software For Your Business| ERP Gold
ERP Gold provides a low cost small business inventory software for small business to help them increase their operational efficiency and business profitability. It allows you to manage Inventory, Accounting, Sales, and CRM all through one simplified software.
It allows the flexibility to import your legacy data and manage your inventory without interrupting your business operations. We provide a fully customized inventory solution to run your business the way you want. It also simple categories with a customizable order management facility which keeps you updated with real-time accuracy.Smart-categories and easy quantity management ensures your inventoryis always up to date and accurate.
And for Report Generation, it generate instant reports for your inventory items. To check the full item history in a single click including item history, item valuation summaries and full detail lists. Order tracking for each product can be made through custom identification codes and printable reports can be generated for additional document keeping.
1-888-334-4472
support@erp.gold
Suite 183411, Shelby TWP, MI 48318
Small business inventory software,
https://www.erp.gold/small-business-inventory-software/
small-business-inventory-software
Post a Comment