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.ARH_PHON_PKG dependencies on HZ_CUST_ACCOUNT_ROLES

Line 216: hz_cust_account_roles car

212:
213: select count(1)
214: into primary_count
215: from hz_contact_points cont_point,
216: hz_cust_account_roles car
217: where car.party_id = cont_point.owner_table_id
218: and cont_point.owner_table_name = 'HZ_PARTIES'
219: and cont_point.contact_point_type not
220: in ('EDI','EMAIL','WEB')

Line 238: hz_cust_account_roles car

234: --
235: select count(1)
236: into primary_count
237: from hz_contact_points cont_point,
238: hz_cust_account_roles car
239: where car.party_id = cont_point.owner_table_id
240: and cont_point.owner_table_name = 'HZ_PARTIES'
241: and cont_point.contact_point_type not
242: in ('EDI','EMAIL','WEB')

Line 258: hz_cust_account_roles car

254: --
255: select count(1)
256: into primary_count
257: from hz_contact_points cont_point,
258: hz_cust_account_roles car
259: where car.party_id = cont_point.owner_table_id
260: and cont_point.owner_table_name = 'HZ_PARTIES'
261: and cont_point.contact_point_type not
262: in ('EDI','EMAIL','WEB')