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_PS_GEN_008 dependencies on IGS_EN_SU_ATTEMPT

Line 1281: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)

1277: AND uoo.version_number=uv.version_number
1278: AND uv.unit_status = us.unit_status
1279: AND us.s_unit_status IN (l_c_active,l_c_planned)
1280: AND uoo.relation_type = l_c_none
1281: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)
1282: ORDER BY uoo.unit_cd,uoo.version_number ASC;
1283:
1284: CURSOR c_new_sup(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
1285: cp_ci_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE,

Line 1303: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)

1299: AND uoo.unit_cd=uv.unit_cd
1300: AND uoo.version_number=uv.version_number
1301: AND uv.unit_status = us.unit_status
1302: AND us.s_unit_status IN (l_c_active,l_c_planned)
1303: AND uoo_id NOT IN (SELECT uoo_id FROM igs_en_su_attempt)
1304: AND uoo.relation_type IN (l_c_superior,l_c_none)
1305: ORDER BY uoo.unit_cd,uoo.version_number ASC;
1306:
1307: l_c_new_sub c_new_sub%ROWTYPE;