Most Important Price list Tables in Oracle Fusion

Price list Tables in Oracle Fusion

Hi friends, we are going to discuss about the Price list Tables in Oracle Fusion. In this post , we will share some of the important price list tables which helps to store the sales order price list information's in oracle fusion. Using these price list tables we can write sql queries which helps to extract and develop the custom BIP Oracle fusion reports for sales order price list. In Oracle fusion , Price list tables name  starts with the 'QP%'. We will also share one of the useful sql query which helps to extract the most useful price list information's from price list tables. In Oracle fusion, Price list tables names are quite changed as compared to oracle apps r12. Please find below the complete detail about Price list Tables in Oracle Fusion.

Most Important Price list Tables in Oracle Fusion

5 Important Price list Tables in Oracle Fusion

1.QP_PRICE_LISTS_VL

2.QP_PRICE_LISTS_TL

3.QP_PRICE_LISTS_ALL_B

4.QP_PRICE_LIST_CHARGES

5.QP_PRICE_LIST_ITEMS

Important SQL Query to extract the Price List data in Oracle Fusion

SELECT  QPLT.NAME "Price List Name"  ,

        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 Customer Item",

        QPLC.BASE_PRICE "Price List Item Price"     ,

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

FROM        QP_PRICE_LIST_ITEMS QPLI,

        QP_PRICE_LIST_CHARGES QPLC,

QP_PRICE_LISTS_ALL_B QPLB,

         QP_PRICE_LISTS_TL QPLT

WHERE   1=1

AND QPLT.NAME=:P_PRICE_LIST

AND QPLT.PRICE_LIST_ID = QPLI.PRICE_LIST_ID

AND QPLB.PRICE_LIST_ID=QPLI.PRICE_LIST_ID

AND QPLC.PARENT_ENTITY_ID (+) = QPLI.PRICE_LIST_ITEM_ID

ORDER BY 1

Most Important Price list Tables in Oracle Fusion

Most Important Price list Tables in Oracle Fusion