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.IEX_UTILITIES dependencies on HZ_CUST_ACCOUNTS

Line 1422: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca

1418: l_delinquency_id number;
1419:
1420: CURSOR get_party_account_id_cur (p_customer_site_use_id number) is
1421: SELECT ca.party_id party_id, ca.cust_account_id cust_account_id
1422: FROM hz_cust_site_uses site_uses, hz_cust_acct_sites acct_sites, hz_cust_accounts ca
1423: WHERE site_uses.site_use_id = p_customer_site_use_id
1424: AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
1425: AND ca.cust_account_id = acct_sites.cust_account_id;
1426:

Line 1432: SELECT party_id FROM HZ_CUST_ACCOUNTS

1428: select dunning_letters from hz_customer_profiles
1429: where site_use_id = p_site_use_id and status = 'A';
1430:
1431: CURSOR get_party_id_cur (p_cust_account_id number) is
1432: SELECT party_id FROM HZ_CUST_ACCOUNTS
1433: WHERE cust_account_id = p_cust_account_id ;
1434:
1435: cursor c_account (p_cust_account_id number) is
1436: select dunning_letters from hz_customer_profiles