Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

SQL query for Review Cost Accounting Distributions information tab details in detail

Question
3
Views
0
Comments

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

Fusion application - Supply Chain Execution —> Cost Accounting.