APPS.OE_XML_PROCESS_UTIL dependencies on HZ_CUST_SITE_USES_ALL

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'