DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 195: FROM hz_cust_acct_sites_all acct_site,

191: IF g_invoice_to_org_id_tbl(i) IS NOT NULL and g_invoice_to_org_id_tbl(i) <> -99 THEN
192: SELECT acct_site.cust_account_id, site.cust_acct_site_id
193: INTO g_invoice_to_customer_tbl(i),
194: g_invoice_to_site_tbl(i)
195: FROM hz_cust_acct_sites_all acct_site,
196: hz_cust_site_uses_all site
197: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
198: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
199: AND SITE.SITE_USE_ID = g_invoice_to_org_id_tbl(i);