DBA Data[Home] [Help]

APPS.ARP_GROUP_INV dependencies on HZ_CUST_SITE_USES

Line 336: hz_cust_site_uses su,

332: AND l.orig_system_bill_customer_id IS NOT NULL
333: AND l.orig_system_bill_address_id IS NOT NULL
334: AND EXISTS (SELECT /*+ no_unnest */'X'
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

Line 377: hz_cust_site_uses su,

373: AND l.orig_system_bill_customer_id IS NOT NULL
374: AND l.orig_system_bill_address_id IS NOT NULL
375: AND EXISTS (SELECT /*+ no_unnest */'X'
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