APPS.ARP_GROUP_INV dependencies on HZ_CUST_ACCT_SITES

Line 315: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites

311:
312: /******************************************************************
313: *** Customer must be enabled to Import billing Number **
314: ******************************************************************/
315: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
316:
317: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1814');
318:
319: INSERT INTO RA_INTERFACE_ERRORS

Line 339: hz_cust_acct_sites ac

335: FROM
336: hz_cust_site_uses su,
337: hz_customer_profiles cp,
338: hz_customer_profiles sp,
339: hz_cust_acct_sites ac
340: WHERE su.cust_acct_site_id = l.orig_system_bill_address_id
341: AND su.site_use_code = 'BILL_TO'
342: AND su.status = 'A'
343: AND cp.cust_account_id = l.orig_system_bill_customer_id

Line 356: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites

352: /******************************************************************
353: *** You cannot import Billing Number for the customer using ***
354: *** Consolidated Billing functionality ***
355: ******************************************************************/
356: -- Bug 2501153: To avoid the merge join cartesian, added a table hz_cust_acct_sites
357:
358: l_message_text := arp_standard.fnd_message('AR_RAXTRX-1813');
359:
360: INSERT INTO RA_INTERFACE_ERRORS

Line 380: hz_cust_acct_sites ac

376: FROM
377: hz_cust_site_uses su,
378: hz_customer_profiles cp,
379: hz_customer_profiles sp,
380: hz_cust_acct_sites ac
381: WHERE su.cust_acct_site_id = l.orig_system_bill_address_id
382: AND su.site_use_code = 'BILL_TO'
383: AND su.status = 'A'
384: AND cp.cust_account_id = l.orig_system_bill_customer_id