select HP.PARTY_NAME “Customer Name”,
HCAA.ACCOUNT_NUMBER,
HCAA.ACCOUNT_NAME,
qph.name “Price List Name”,
HCSUA.SITE_USE_CODE,
HCSUA.LOCATION
from qp_list_headers qph,
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 hcaa.account_number = –Customer Account Number
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
Recent Posts
