APPS.OE_INVOICE_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 6652: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6648:
6649: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6650: INTO p_x_interface_line_rec.ORIG_SYSTEM_BILL_CUSTOMER_ID
6651: ,p_x_interface_line_rec.ORIG_SYSTEM_BILL_ADDRESS_ID
6652: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6653: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
6654: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6655: AND SITE.SITE_USE_ID = p_line_rec.invoice_to_org_id;
6656:

Line 6683: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

6679:
6680: SELECT acct_site.cust_account_id, site.cust_acct_site_id
6681: INTO p_x_interface_line_rec.ORIG_SYSTEM_SHIP_CUSTOMER_ID
6682: ,l_orig_sys_ship_addr_id
6683: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
6684: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
6685: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
6686: AND SITE.SITE_USE_ID = p_line_rec.ship_to_org_id;
6687:

Line 7232: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

7228: WHERE organization_id = p_header_rec.invoice_to_org_id;*/
7229:
7230: SELECT acct_site.cust_account_id
7231: INTO l_hdr_inv_to_cust_id
7232: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
7233: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
7234: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
7235: AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;
7236: