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.AR_BPA_UTILS_PKG dependencies on HZ_CONTACT_POINTS

Line 545: from hz_contact_points cont_point,

541: FUNCTION fn_get_phone (p_contact_id IN NUMBER) return varchar2 IS
542: CURSOR c_cont_phone( id in number ) IS
543: select min(decode(cont_point.contact_point_type,'TLX',
544: cont_point.telex_number, cont_point.phone_number)) contact_phone
545: from hz_contact_points cont_point,
546: hz_cust_account_roles acct_role
547: where acct_role.cust_account_role_id = id
548: and acct_role.party_id = cont_point.owner_table_id
549: and cont_point.owner_table_name = 'HZ_PARTIES'

Line 571: from hz_contact_points cont_point,

567: FUNCTION fn_get_fax (p_contact_id IN NUMBER) return varchar2 IS
568: CURSOR c_cont_fax( id in number ) IS
569: select min(decode(cont_point.contact_point_type,'TLX',
570: cont_point.telex_number, cont_point.phone_number)) contact_fax
571: from hz_contact_points cont_point,
572: hz_cust_account_roles acct_role
573: where acct_role.cust_account_role_id = id
574: and acct_role.party_id = cont_point.owner_table_id
575: and cont_point.owner_table_name = 'HZ_PARTIES'