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 558: from hz_contact_points cont_point,

554: FUNCTION fn_get_phone (p_contact_id IN NUMBER) return varchar2 IS
555: CURSOR c_cont_phone( id in number ) IS
556: select min(decode(cont_point.contact_point_type,'TLX',
557: cont_point.telex_number, cont_point.phone_number)) contact_phone
558: from hz_contact_points cont_point,
559: hz_cust_account_roles acct_role
560: where acct_role.cust_account_role_id = id
561: and acct_role.party_id = cont_point.owner_table_id
562: and cont_point.owner_table_name = 'HZ_PARTIES'

Line 584: from hz_contact_points cont_point,

580: FUNCTION fn_get_fax (p_contact_id IN NUMBER) return varchar2 IS
581: CURSOR c_cont_fax( id in number ) IS
582: select min(decode(cont_point.contact_point_type,'TLX',
583: cont_point.telex_number, cont_point.phone_number)) contact_fax
584: from hz_contact_points cont_point,
585: hz_cust_account_roles acct_role
586: where acct_role.cust_account_role_id = id
587: and acct_role.party_id = cont_point.owner_table_id
588: and cont_point.owner_table_name = 'HZ_PARTIES'