Customer Relation Query - Oracle EBS

 SELECT hcr.cust_account_id,
       hcr.related_cust_account_id,
       hcr.relationship_type, 
       hcr.customer_reciprocal_flag,
       hcr.status,
       hcr.org_id, 
       hcr.bill_to_flag,
       hcr.ship_to_flag,
       hca.account_name AS rel_act_desc, 
       hp.party_name AS rel_customer,
       hca.account_number AS rel_act_number, 
       hp.party_id
  FROM apps.hz_cust_acct_relate_all hcr,
       apps.hz_cust_accounts_all hca,
       apps.hz_parties hp
 WHERE 1=1
   AND hca.cust_account_id = hcr.related_cust_account_id
   AND hca.party_id = hp.party_id
 --  and hp.party_number=:PARTY_NUMBER
   and hca.cust_account_id = 213139 ;