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_AS_GEN_007 dependencies on IGS_AS_ASSESSMNT_ITM

Line 84: igs_as_assessmnt_itm ai,

80: sua.version_number,
81: sua.uoo_id
82: FROM igs_as_su_atmpt_itm suaai,
83: igs_en_su_attempt sua,
84: igs_as_assessmnt_itm ai,
85: igs_as_unit_class ucl
86: WHERE suaai.person_id = NVL (p_person_id, suaai.person_id)
87: AND suaai.logical_delete_dt IS NULL
88: AND suaai.attempt_number = (SELECT MAX (attempt_number)

Line 1223: igs_as_assessmnt_itm ai,

1219: usai.final_weight_qty,
1220: usai.grading_schema_cd,
1221: usai.gs_version_number
1222: FROM igs_ps_unitass_item usai,
1223: igs_as_assessmnt_itm ai,
1224: igs_ps_unit_ofr_opt uai,
1225: igs_as_unit_class uc,
1226: igs_ca_inst_rel cir
1227: WHERE usai.uoo_id = uai.uoo_id

Line 1283: igs_as_assessmnt_itm ai,

1279: uai.final_weight_qty,
1280: uai.grading_schema_cd,
1281: uai.gs_version_number
1282: FROM igs_as_unitass_item uai,
1283: igs_as_assessmnt_itm ai,
1284: igs_ca_inst_rel cir
1285: WHERE uai.ass_id = ai.ass_id
1286: AND (p_teach_perd_cal_type IS NULL
1287: OR uai.cal_type = p_teach_perd_cal_type