Customer price list query in oracle apps

Customer price list query in oracle apps

In this post , We will be discuss about Customer price list query in oracle apps. Customer Prices List uses in the Sales Order to book the sales orders for the Customers. We cannot create Sales Orders with our the Oracle Price List in oracle apps.Price List is uses in the Oracle Sales Order. In Price List , we define the Finished Good Item Selling Price. Based on this Item Prices , Sales Order booking amount Calculates for the  Oracle customers. Here below I will share the Customer price list query in oracle apps.

 

7 Most Important Customer price list query in oracle apps

1.qp_list_headers qph,

2.qp_list_lines_v qpl,
3.mtl_system_items_b msi,

4.HZ_CUST_ACCOUNTS_ALL
5.HZ_CUST_ACCT_SITES_ALL
6.HZ_CUST_SITE_USES_ALL
7.HZ_PARTIES

 

Example of Customer price list query in oracle apps

 

select  HP.PARTY_NAME "Customer Name",
HCAA.ACCOUNT_NUMBER,
 HCAA.ACCOUNT_NAME,
qph.name  "Price List Name",
 msi.segment1  "Inventory Item Name",
qpl.operand,
qpl.product_precedence,
HCSUA.SITE_USE_CODE,
HCSUA.LOCATION           
from qp_list_headers qph,
apps.qp_list_lines_v qpl,
inv.mtl_system_items_b msi,
APPS.HZ_CUST_ACCOUNTS_ALL   HCAA,
APPS.HZ_CUST_ACCT_SITES_ALL HCASA,
APPS.HZ_CUST_SITE_USES_ALL  HCSUA,
APPS.HZ_PARTIES HP
Where qph.list_header_id = qpl.list_header_id
and msi.ORGANIZATION_ID =:P_ORG_ID
and msi.segment1 =:P_ITEM_NUMBER
and TO_CHAR(qpl.product_attr_value) = to_char(msi.inventory_item_id)
and HCAA.CUST_ACCOUNT_ID = HCASA.CUST_ACCOUNT_ID
and HCASA.CUST_ACCT_SITE_ID = HCSUA.CUST_ACCT_SITE_ID
AND HCSUA.PRICE_LIST_ID = QPH.LIST_HEADER_ID
AND HCAA.PARTY_ID=HP.PARTY_ID