DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on HZ_PARTY_SITES

Line 247: hz_party_sites party_site,

243: decode(party.party_type,'PERSON',hp.person_name_phonetic, party.organization_name_phonetic ) alternate_name
244: FROM
245: hz_cust_site_uses_all site_uses,
246: hz_cust_acct_sites_all acct_site,
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

Line 314: hz_party_sites party_site,

310: FROM
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