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.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTPTS_INT

Line 633: from hz_imp_contactpts_int cp_int,

629: nvl2(cp_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
630: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
631: cp_int.batch_id, cp_int.contact_point_type,
632: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
633: from hz_imp_contactpts_int cp_int,
634: hz_imp_parties_sg psg,
635: hz_orig_sys_references mosr,
636: hz_imp_osr_change party_osr_ch_tbl
637: where cp_int.interface_status = 'C'

Line 746: from hz_imp_contactpts_int cp_int,

742: nvl2(cp_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
743: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
744: cp_int.batch_id, cp_int.contact_point_type,
745: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
746: from hz_imp_contactpts_int cp_int,
747: hz_imp_parties_sg psg,
748: hz_orig_sys_references mosr,
749: hz_imp_osr_change party_osr_ch_tbl
750: where cp_int.interface_status is null