APPS.OE_UPDATE_ACK_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 453: From hz_cust_acct_sites a, hz_cust_site_uses_all b

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