Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

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

Received Response
508
Views
6
Comments
Gorla Shiva
Gorla Shiva Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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