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.IGS_AD_IMP_001 dependencies on IGS_AD_INSTHIST_INT

Line 209: EXISTS (SELECT 1 FROM igs_ad_insthist_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)

205: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
206: WHERE status = '1'
207: AND interface_run_id = p_interface_run_id
208: AND (
209: EXISTS (SELECT 1 FROM igs_ad_insthist_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)
210: OR EXISTS (SELECT 1 FROM igs_ad_notes_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)
211: OR EXISTS (SELECT 1 FROM igs_ad_unitsets_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)
212: OR EXISTS (SELECT 1 FROM igs_ad_edugoal_int WHERE status <> '1' AND interface_ps_appl_inst_id = apinst.interface_ps_appl_inst_id)
213: );

Line 508: igs_ad_insthist_int applinsthist

504: SELECT 1
505: FROM igs_ad_interface int,
506: igs_ad_apl_int aplint,
507: igs_ad_ps_appl_inst_int aplinst,
508: igs_ad_insthist_int applinsthist
509: WHERE int.interface_id = aplint.interface_id
510: AND aplint.interface_appl_id = aplinst.interface_appl_id
511: AND applinsthist.interface_ps_appl_inst_id = aplinst.interface_ps_appl_inst_id
512: AND int.source_type_id = p_source_type_id