APPS.OE_UPDATE_ACK_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 452: From hz_cust_acct_sites a, hz_cust_site_uses_all b

448: -- Get Sold To Information
449: Begin
450: Select /* MOAC_SQL_CHANGE*/ b.site_use_id
451: Into l_sold_to_site_use_id
452: From hz_cust_acct_sites a, hz_cust_site_uses_all b
453: Where a.cust_acct_site_id = b.cust_acct_site_id
454: And a.cust_account_id = l_header_acks_rec.sold_to_org_id
455: And b.org_id = a.org_id
456: And b.site_use_code = 'SOLD_TO'