APPS.OE_INVOICE_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 6379: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6375:
6376: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6377: INTO p_x_interface_line_rec.ORIG_SYSTEM_BILL_CUSTOMER_ID
6378: ,p_x_interface_line_rec.ORIG_SYSTEM_BILL_ADDRESS_ID
6379: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6380: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6381: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6382: AND SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id;
6383:

Line 6410: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6406:
6407: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6408: INTO p_x_interface_line_rec.ORIG_SYSTEM_SHIP_CUSTOMER_ID
6409: ,l_orig_sys_ship_addr_id
6410: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6411: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
6412: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6413: AND SITE.SITE_USE_ID = p_line_rec.ship_to_org_id;
6414:

Line 6947: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6943: WHERE organization_id = p_header_rec.invoice_to_org_id;*/
6944:
6945: SELECT acct_site.cust_account_id
6946: INTO l_hdr_inv_to_cust_id
6947: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6948: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6949: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6950: AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;
6951: