Categories
SQL query for Review Cost Accounting Distributions information tab details in detail
Hi Support,
SQL query for Cost information tab details in detail
Review Cost Accounting Distributions - Could anyone help me to get the SQL query to get cost component wise amount.
SQL query for Cost information tab details in detail
CST_LAYER_COSTS - Table hold amount in summary level not in detail.
Please provide the sql qery/joins to get component wise cost details in Inventory module.
Navigation —> Supply Chain Execution —> Cost Accounting —> Task —> Review Cost Accounting Distributions —> Query item —> Click on View Details
Best Answer
-
@Gorla Shiva - Please post this query in the OTBI community for better suggestions.
This forum is specific to FAW/FDI.
0
Answers
-
What I know the table names and their joins to get in details(all lines details)
0 -
@Gorla Shiva - Please let us know if you need these details to be fetched from Fusion application side or at the warehouse side.
0 -
Hi Sumanth,
Fusion application - Supply Chain Execution —> Cost Accounting.
0 -
@Gorla Shiva - Yes, as said in my initial update OTBI forum will have more number of users who will be able to assist with the request. Kindly reach out here.
@John Hung-Oracle - Please assist by moving the same thread to OTBI if possible.
0 -
@Sumanth V -Oracle , Thanks.
I have posted same question in Oracle Transactional Business Intelligence.
Experts can I get answer on this as early as possible?
It is stopping to release CRP.
1