iStore PL/SQL Back-end Queries for R12

Hi All,

Please see following Important R12 iStore Back-end query that will helps a lot for iStore.

1. Query to get the customer name, price list, account number associated to a user?

select distinct(HZR.Object_id) "Customer Id" , HZP.party_name "Customer Name",  HZC.account_number "Account Number", HZC.PRICE_LIST_ID "Price List Id" , QPTL.name "Price list name"

from fnd_user FUSR , HZ_PARTIES HZP,

HZ_RELATIONSHIPS HZR , HZ_CUST_ACCOUNTS HZC ,

QP_LIST_HEADERS_TL QPTL

where FUSR.person_party_id = HZR.subject_id

and HZP.party_id = HZR.object_id

AND HZC.PARTY_ID = HZR.object_id