APPS.OE_XML_PROCESS_UTIL dependencies on HZ_CUST_ACCT_SITES

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 105: FROM hz_cust_acct_sites_all

101: END IF;
102:
103: SELECT cust_account_id
104: INTO l_sold_to_org_id
105: FROM hz_cust_acct_sites_all
106: WHERE cust_acct_site_id = p_address_id
107: AND status = 'A';
108:
109: x_sold_to_org_id := l_sold_to_org_id;

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 243: Hz_Cust_Acct_Sites_All Acct_Site,

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,
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