eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_GROUP_INV dependencies on HZ_CUSTOMER_PROFILES

Line 337: hz_customer_profiles cp,

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'

Line 338: hz_customer_profiles sp,

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'

Line 378: hz_customer_profiles cp,

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'

Line 379: hz_customer_profiles sp,

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'