DBA Data[Home] [Help]

APPS.OE_ACCEPTANCE_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 209: hz_cust_site_uses_all site

205: SELECT acct_site.cust_account_id, site.cust_acct_site_id
206: INTO g_invoice_to_customer_tbl(i),
207: g_invoice_to_site_tbl(i)
208: FROM hz_cust_acct_sites_all acct_site,
209: hz_cust_site_uses_all site
210: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
211: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
212: AND SITE.SITE_USE_ID = g_invoice_to_org_id_tbl(i);
213: ELSE

Line 224: hz_cust_site_uses_all site

220: SELECT acct_site.cust_account_id, site.cust_acct_site_id
221: INTO g_ship_to_customer_tbl(i),
222: g_ship_to_site_tbl(i)
223: FROM hz_cust_acct_sites_all acct_site,
224: hz_cust_site_uses_all site
225: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
226: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
227: AND SITE.SITE_USE_ID = g_ship_to_org_id_tbl(i);
228: ELSE