APPS.OE_XML_PROCESS_UTIL dependencies on HZ_CUST_SITE_USES

Line 36: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b

32: oe_debug_pub.add( 'ENTERING OE_XML_PROCESS_UTIL.GET_SHIP_TO_ORG_ID' ) ;
33: END IF;
34: SELECT site_use_id
35: INTO l_site_use_id
36: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b
37: WHERE a.cust_acct_site_id = b.cust_acct_site_id
38: AND a.cust_acct_site_id = p_address_id
39: AND a.site_use_code = 'SHIP_TO'
40: AND a.status = 'A'

Line 71: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b

67: END IF;
68:
69: SELECT site_use_id
70: INTO l_site_use_id
71: FROM hz_cust_site_uses_all a, hz_cust_acct_sites_all b
72: WHERE a.cust_acct_site_id = b.cust_acct_site_id
73: AND a.cust_acct_site_id = p_address_id
74: AND a.site_use_code = 'BILL_TO'
75: AND a.status = 'A'

Line 137: From hz_cust_acct_sites a, hz_cust_site_uses_all b,

133: END IF;
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'

Line 240: From Hz_Cust_Site_Uses Site,

236: x_country,
237: x_postal_code,
238: x_edi_location_code,
239: x_customer_name
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,