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 21188: hz_phone_number_pkg.transpose(PHONE_COUNTRY_CODE||PHONE_AREA_CODE||PHONE_NUMBER) "TRANS_PHONE_NUMBER"

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

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

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