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

Line 954: from hz_contact_points

950: select decode(phone_country_code,'','',phone_country_code || '-' ) ||
951: decode(phone_area_code,'','',phone_area_code || '-' ) || phone_number
952: into l_phone
953: from (select phone_number, phone_area_code, phone_country_code
954: from hz_contact_points
955: where owner_table_id = party_id
956: and owner_table_name ='HZ_PARTY_SITES'
957: and contact_point_type = 'PHONE'
958: order by primary_flag desc, creation_date asc)

Line 979: from hz_contact_points

975: begin
976: select TRANSPOSED_PHONE_NUMBER into l_phone
977: from (select reverse(TRANSPOSED_PHONE_NUMBER)
978: TRANSPOSED_PHONE_NUMBER
979: from hz_contact_points
980: where owner_table_id = party_id
981: and owner_table_name ='HZ_PARTY_SITES'
982: and contact_point_type = 'PHONE'
983: order by primary_flag desc, creation_date asc)