Oracle Business Intelligence Applications Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Business Intelligence Applications Forum

Categories

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

Closed
851
Views
8
Comments
Gorla Shiva
Gorla Shiva Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications Forum

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

image.png image.png
Tagged:

Answers

  • Gorla Shiva
    Gorla Shiva Rank 3 - Community Apprentice

    Hi Experts,

    May I pls get the tables and joins for the same.

  • Priyaranjan Shetty-Oracle
    Priyaranjan Shetty-Oracle Rank 1 - Community Starter

    Hi Shiva,

    Can you review below notes to see it helps

    Fusion CST: SQL That Can Fetch All The Records From Review Cost Accounting Distributions UI (Doc ID 2688621.1)

    Regards,
    Priyaranjan

  • Gorla Shiva
    Gorla Shiva Rank 3 - Community Apprentice

    @Priyaranjan Shetty-Oracle ,

    This will not help me. I need Cost Information in details(all lines) as shown above mentioned screenshot.

    image.png
  • Gorla Shiva
    Gorla Shiva Rank 3 - Community Apprentice

    Hi Experts,

    May I please get an answer on this?

  • Moeed
    Moeed Rank 1 - Community Starter
    edited Nov 6, 2024 6:54AM

    Please Look into the following query and modify it according to your needs.

    SELECT CLC.*
    FROM CST_LAYER_COSTS CLC
    ,CST_COST_DISTRIBUTIONS CCD
    WHERE 1=1
    AND CLC.DISTRIBUTION_ID = CCD.DISTRIBUTION_ID AND CLC.INVENTORY_ITEM_ID = :ITEM_ID
    AND CLC.COST_REFERENCE = :PO_NO

    Thanks.

  • suamanch-Oracle
    suamanch-Oracle Rank 1 - Community Starter

    Hi team,

    How can we get transaction number column details in 'review cost accounting distribution' page.

    Can anyone please help me.

    image.png

    Thansk & Regards,

    Supriya

  • Mahi_Ranjan
    Mahi_Ranjan Rank 1 - Community Starter
    Screenshot (1152).png


    Hy Experts. I am developing a Purchase Register Report where I have to fetch a column named Inventory Charge Account in which this value of Inventory Valuation account code needs to be fetched -

    01.01.00.000.000.2311.2104.000.00.000.000

    I am nowhere able to find the query for the same, somebody please help?

    Thanks!

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi @Mahi_Ranjan ,

    Welcome to the Oracle Analytics community and forum.

    Your question is not in the right forum. Fusion data (which table has what column etc.) is covered in the forum looking after the Fusion products: https://community.oracle.com/customerconnect

    It's a parallel but fully independent forum. If you look at the categories, you will see that the various Fusion "topics" have an analytics and/or reporting category as well. That's the place where to ask question about where to find some Fusion data for reporting.

    Thanks

This discussion has been closed.