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.FII_AR_COLLECTORS_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 205: FROM hz_customer_profiles prof

201: FII_USER_ID,
202: SYSDATE,
203: FII_USER_ID,
204: FII_LOGIN_ID
205: FROM hz_customer_profiles prof
206: WHERE prof.cust_account_id > 0
207: AND prof.last_update_date <= g_collection_to_date
208: UNION ALL
209:

Line 221: FROM hz_customer_profiles prof,

217: FII_USER_ID,
218: SYSDATE,
219: FII_USER_ID,
220: FII_LOGIN_ID
221: FROM hz_customer_profiles prof,
222: hz_cust_accounts acct,
223: hz_cust_acct_sites_all sites,
224: hz_cust_site_uses_all uses
225: WHERE prof.site_use_id IS NULL

Line 233: FROM hz_customer_profiles profs

229: AND uses.site_use_code IN ('BILL_TO','DRAWEE')
230: AND prof.last_update_date <= g_collection_to_date
231: AND NOT EXISTS (SELECT /*+ PARALLEL(profs) */
232: cust_account_id, site_use_id
233: FROM hz_customer_profiles profs
234: WHERE site_use_id IS NOT NULL
235: and acct.cust_account_id = profs.cust_account_id
236: and uses.site_use_id = profs.site_use_id
237: AND profs.last_update_date <= g_collection_to_date);

Line 488: FROM hz_customer_profiles prof

484: SYSDATE last_update_date,
485: '||FII_USER_ID||' last_updated_by,
486: '||FII_LOGIN_ID||' last_update_login
487:
488: FROM hz_customer_profiles prof
489:
490: '||l_last_update_join1||'
491: AND prof.cust_account_id > 0
492:

Line 505: FROM hz_customer_profiles prof,

501: SYSDATE last_update_date,
502: '||FII_USER_ID||' last_updated_by,
503: '||FII_LOGIN_ID||' last_update_login
504:
505: FROM hz_customer_profiles prof,
506: hz_cust_accounts acct,
507: hz_cust_acct_sites_all sites,
508: hz_cust_site_uses_all uses
509:

Line 516: FROM hz_customer_profiles profs

512: AND acct.cust_account_id = sites.cust_account_id
513: AND sites.cust_acct_site_id = uses.cust_acct_site_id
514: AND uses.site_use_code IN (''BILL_TO'',''DRAWEE'')
515: AND NOT EXISTS (SELECT cust_account_id, site_use_id
516: FROM hz_customer_profiles profs
517: WHERE site_use_id IS NOT NULL
518: and acct.cust_account_id = profs.cust_account_id
519: and uses.site_use_id = profs.site_use_id
520: '||l_last_update_join2||'