VIEW: APPS.IGS_AS_SUAOA_V

Source

View Text - Preformatted

SELECT row_id, person_id ,course_cd ,unit_cd ,cal_type ,ci_sequence_number ,ci_start_dt ,ci_end_dt ,outcome_dt ,grading_schema_cd ,version_number ,grade ,s_grade_creation_method_type ,finalised_outcome_ind ,mark ,number_times_keyed ,translated_grading_schema_cd ,translated_version_number ,translated_grade ,translated_dt ,created_by ,creation_date ,last_updated_by ,last_update_date ,last_update_login ,grading_period_cd ,incomp_deadline_date ,incomp_grading_schema_cd ,incomp_version_number ,incomp_default_grade ,incomp_default_mark ,comments ,uoo_id, mark_capped_flag, SHOW_ON_ACADEMIC_HISTRY_FLAG, release_date, manual_override_flag from igs_as_su_stmptout suao WHERE outcome_dt IN (SELECT max(outcome_dt) FROM igs_as_su_stmptout WHERE person_id = suao.person_id and course_cd = suao. course_cd and uoo_id= suao. Uoo_Id and grading_period_cd = suao.grading_period_cd)

View Text - HTML Formatted

SELECT ROW_ID
, PERSON_ID
, COURSE_CD
, UNIT_CD
, CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, OUTCOME_DT
, GRADING_SCHEMA_CD
, VERSION_NUMBER
, GRADE
, S_GRADE_CREATION_METHOD_TYPE
, FINALISED_OUTCOME_IND
, MARK
, NUMBER_TIMES_KEYED
, TRANSLATED_GRADING_SCHEMA_CD
, TRANSLATED_VERSION_NUMBER
, TRANSLATED_GRADE
, TRANSLATED_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, GRADING_PERIOD_CD
, INCOMP_DEADLINE_DATE
, INCOMP_GRADING_SCHEMA_CD
, INCOMP_VERSION_NUMBER
, INCOMP_DEFAULT_GRADE
, INCOMP_DEFAULT_MARK
, COMMENTS
, UOO_ID
, MARK_CAPPED_FLAG
, SHOW_ON_ACADEMIC_HISTRY_FLAG
, RELEASE_DATE
, MANUAL_OVERRIDE_FLAG
FROM IGS_AS_SU_STMPTOUT SUAO
WHERE OUTCOME_DT IN (SELECT MAX(OUTCOME_DT)
FROM IGS_AS_SU_STMPTOUT
WHERE PERSON_ID = SUAO.PERSON_ID
AND COURSE_CD = SUAO. COURSE_CD
AND UOO_ID= SUAO. UOO_ID
AND GRADING_PERIOD_CD = SUAO.GRADING_PERIOD_CD)