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.ARI_UTILITIES dependencies on HZ_PARTY_SITES

Line 2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,

2247: CURSOR contact_cur(p_customer_id IN NUMBER ,
2248: p_customer_acct_site_id IN NUMBER ) IS
2249: SELECT hcar.CUST_ACCOUNT_ROLE_ID as contact_id
2250: FROM HZ_CUST_ACCOUNT_ROLES hcar, HZ_PARTIES hpsub, HZ_PARTIES hprel,
2251: HZ_ORG_CONTACTS hoc, HZ_RELATIONSHIPS hr, HZ_PARTY_SITES hps, FND_TERRITORIES_VL ftv,
2252: fnd_lookup_values_vl lookups,hz_role_responsibility hrr
2253: WHERE hrr.responsibility_type = 'SELF_SERVICE_USER'
2254: and hrr.cust_account_role_id = hcar.cust_account_role_id
2255: and hcar.CUST_ACCOUNT_ID = p_customer_id