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.AMS_LISTIMPORT_PVT dependencies on HZ_PHONE_NUMBER_PKG

Line 21187: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"

21183: where import_list_header_id = p_import_list_header_id;
21184:
21185: cursor c_b2b_ph_no is
21186: select IMPORT_SOURCE_LINE_ID ,
21187: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"
21188: from
21189: ams_hz_b2b_mapping_v
21190: where import_list_header_id = p_import_list_header_id
21191: and phone_number is not null

Line 21197: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"

21193: and load_status in ('ACTIVE','RELOAD');
21194:
21195: cursor c_b2c_ph_no is
21196: select IMPORT_SOURCE_LINE_ID ,
21197: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"
21198: from
21199: ams_hz_b2c_mapping_v
21200: where import_list_header_id = p_import_list_header_id
21201: and phone_number is not null