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_OFF_RESP_DATA dependencies on IGS_CA_INST_ALT_V

Line 272: igs_ca_inst_alt_v acad_ciav,

268: ,acad_ciav.description abbreviation
269: ,acad_ciav.cal_status cal_status
270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct

Line 273: igs_ca_inst_alt_v adm_ciav,

269: ,acad_ciav.cal_status cal_status
270: ,acad_ciav.s_cal_status s_cal_status
271: FROM
272: igs_ca_inst_alt_v acad_ciav,
273: igs_ca_inst_alt_v adm_ciav,
274: igs_ca_inst_rel cir,
275: igs_ad_prd_ad_prc_ca apapc,
276: igs_ca_type ct
277: WHERE

Line 312: igs_ca_inst_alt_v ciav1

308: ciav1.end_dt end_dt ,
309: ciav1.description abbreviation ,
310: ciav1.cal_status cal_status
311: FROM
312: igs_ca_inst_alt_v ciav1
313: WHERE
314: (ciav1.s_cal_cat = 'ADMISSION' AND ciav1.s_cal_status = 'ACTIVE'
315: AND ciav1.start_dt > cp_adm_ci_end_dt
316: AND (ciav1.cal_type, ciav1.sequence_number) IN