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
341: AND su.site_use_code = 'BILL_TO'
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
341: AND su.site_use_code = 'BILL_TO'
342: AND su.status = 'A'
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
382: AND su.site_use_code = 'BILL_TO'
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
382: AND su.site_use_code = 'BILL_TO'
383: AND su.status = 'A'