DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 196: hz_cust_site_uses_all site

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);
200: ELSE