Cost Management Tables in Oracle Fusion

Cost Management Tables in Oracle Fusion

Hi friends , we are going to discuss about the Cost Management Tables in Oracle Fusion. We will share some of the important cost management tables which helps to store the costing details in oracle fusion. Using these tables we can able to extract the costing information's for Inventory items in oracle fusion. We will also try to share some of the data extraction sql queries which helps to extract the costing details of inventory items in oracle fusion. We will also share some of the table joins too which helps you write the sql query for item costing details in oracle fusion. These queries are very important , if you want to develop the custom bip reports for costing reports in oracle fusion. Please fin below the complete detail about Cost Management Tables in Oracle Fusion.

Cost Management Tables in Oracle Fusion

5 Most Important Cost Management Tables in Oracle Fusion

Here below is the list of important tables which to store the oracle fusion item costing details in oracle fusion.

1.CST_TRANSACTION_COSTS

2.CST_INV_TRANSACTIONS

3.EGP_SYSTEM_ITEMS_B 

4.CST_PERPAVG_COST

5.CST_COST_ORGS_V

Detail SQL using Cost Management Tables in Oracle Fusion

Here below is the detail sql query which helps to extract the complete inventory item costing information's in oracle fusion. We can use these queries to develop a custom BIP report for cost related reports in oracle fusion.

Please check the below quires,

1)
SELECT * FROM CST_TRANSACTION_COSTS
WHERE 1=1
AND CST_INV_TRANSACTION_ID in (SELECT CST_INV_TRANSACTION_ID FROM CST_INV_TRANSACTIONS
WHERE 1=1
AND INVENTORY_ITEM_ID=(SELECT DISTINCT INVENTORY_ITEM_ID FROM EGP_SYSTEM_ITEMS_B WHERE ITEM_NUMBER='XX_ITEM'))

2)"cst_perpavg_cost" , It maintains unit cost per cost element for an item/cost org/cost book.

SELECT * FROM cst_perpavg_cost
WHERE 1=1
AND PERPAVG_COST_ID IN (55678573)---> This is obtained from above query

3)"cst_cost_orgs_v" Maintains the cost org name

select * from cst_cost_orgs_v
where 1=1
and COST_ORG_ID in (81)

Cost Management Tables in Oracle Fusion

Cost Management Tables in Oracle Fusion