APPS.OE_XML_PROCESS_UTIL dependencies on HZ_PARTIES

Line 138: hz_parties c, hz_cust_accounts d

134:
135: Select /* MOAC_SQL_CHANGE */ a.ece_tp_location_code, c.party_name
136: Into x_edi_location_code, x_sold_to_name
137: From hz_cust_acct_sites a, hz_cust_site_uses_all b,
138: hz_parties c, hz_cust_accounts d
139: Where a.cust_acct_site_id = b.cust_acct_site_id
140: And a.cust_account_id = p_sold_to_org_id
141: And b.site_use_code = 'SOLD_TO'
142: And b.primary_flag = 'Y'

Line 244: Hz_Parties Party,

240: From Hz_Cust_Site_Uses Site,
241: Hz_Party_Sites Party_Site,
242: Hz_Locations Loc,
243: Hz_Cust_Acct_Sites_All Acct_Site,
244: Hz_Parties Party,
245: Hz_Cust_Accounts Cust_Accts
246: Where Site.Site_Use_Code = p_site_use_code
247: And Site.Cust_Acct_Site_Id = Acct_Site.Cust_Acct_Site_Id
248: And Acct_Site.Party_Site_Id = Party_Site.Party_Site_Id

Line 292: From hz_parties a, hz_relationships b,

288: End If;
289:
290: Select a.person_first_name, a.person_last_name
291: Into x_first_name, x_last_name
292: From hz_parties a, hz_relationships b,
293: hz_cust_account_roles c
294: Where c.cust_account_role_id = p_contact_id
295: And c.party_id = b.party_id
296: And b.subject_id = a.party_id

Line 297: And b.subject_table_name = 'HZ_PARTIES'

293: hz_cust_account_roles c
294: Where c.cust_account_role_id = p_contact_id
295: And c.party_id = b.party_id
296: And b.subject_id = a.party_id
297: And b.subject_table_name = 'HZ_PARTIES'
298: And b.object_table_name = 'HZ_PARTIES'
299: And c.cust_account_id = p_cust_acct_id
300: And b.directional_flag = 'F';
301:

Line 298: And b.object_table_name = 'HZ_PARTIES'

294: Where c.cust_account_role_id = p_contact_id
295: And c.party_id = b.party_id
296: And b.subject_id = a.party_id
297: And b.subject_table_name = 'HZ_PARTIES'
298: And b.object_table_name = 'HZ_PARTIES'
299: And c.cust_account_id = p_cust_acct_id
300: And b.directional_flag = 'F';
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;