Price List SQL Query in Oracle Fusion

Hi Friends, we are going to discuss about the Price List SQL Query in Oracle Fusion. We will share the detail sql query which helps to extract the sales order price list informations in oracle fusion. Using this sql , we can find out the price list created in the Oracle Fusion and the price list items and their selling price. In this post , we will also share some of the important Price list tables which helps to store the most useful price list details in oracle fusion. The below sql query is also written with these price list tables. In oracle fusion , Price list tables are changed as compared to the oracle apps r12 price list tables. In Oracle fusion price list tables starts with the prefix 'QP%'. Please find below the complete detail about Price List SQL Query in Oracle Fusion.

Price List SQL Query in Oracle Fusion

Top 5 Price list tables in Oracle Fusion

1.QP_PRICE_LISTS_ALL_B

2.QP_PRICE_LISTS_TL

3.QP_PRICE_LIST_ITEMS

4.QP_PRICE_LIST_CHARGES

4.QP_PRICE_LISTS_VL

SQL Query to get Price List details in Oracle Fusion

Here below is the detail sql query which helps to extract the complete sales order price list information's in oracle fusion.

SELECT  QPLT.NAME "Price List Name"  ,

        QPLI.ITEM_ID "Price List Item Id" ,

        QPLB.CURRENCY_CODE "Price List Currency",

        (SELECT DISTINCT ITEM_NUMBER FROM EGP_SYSTEM_ITEMS ESI WHERE QPLI.ITEM_ID=ESI.INVENTORY_ITEM_ID and organization_id=85) "Price List Item Code",

        (SELECT DISTINCT DESCRIPTION FROM EGP_SYSTEM_ITEMS ESI WHERE QPLI.ITEM_ID=ESI.INVENTORY_ITEM_ID and organization_id=85) "Price List Item Desc",

        QPLC.BASE_PRICE "Price List ITem Price"               

FROM    QP_PRICE_LISTS_ALL_B QPLB,

         QP_PRICE_LISTS_TL QPLT,

        QP_PRICE_LIST_ITEMS QPLI,

        QP_PRICE_LIST_CHARGES QPLC

WHERE   QPLT.PRICE_LIST_ID = QPLI.PRICE_LIST_ID

AND QPLT.NAME=:P_PRICE_LIST

AND QPLB.PRICE_LIST_ID=QPLI.PRICE_LIST_ID

AND QPLC.PARENT_ENTITY_ID (+) = QPLI.PRICE_LIST_ITEM_ID

ORDER BY 1

Price List SQL Query in Oracle Fusion

Price List SQL Query in Oracle Fusion