Query to Get Customers in Oracle 11i Applications

 SELECT hp.party_name        customer_name,
         hca.cust_account_id  customer_id,
         hp.status            status
    FROM hz_parties hp, 
         hz_cust_accounts hca
   WHERE hp.party_id = hca.party_id 
   –AND hca.cust_account_id = 9999 –customer_id
ORDER BY hp.party_name, hca.cust_account_id