247: hz_party_sites party_site,
248: hz_locations loc,
249: hz_cust_accounts cust_acct,
250: hz_parties party,
251: hz_Person_profiles hp
252: WHERE
253: site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
254: AND acct_site.cust_account_id = cust_acct.cust_account_id
255: AND party.party_id = cust_acct.party_id
311: hz_parties party,
312: hz_cust_accounts cust_acct,
313: hz_locations loc,
314: hz_party_sites party_site,
315: hz_Person_profiles hp
316: WHERE
317: party.party_id = cust_acct.party_id
318: AND cust_acct.cust_account_id = cp_sold_to_org_id
319: AND party_site.party_id = party.party_id