VIEW: APPS.IGS_AS_SUAAI_OUTHIST_V

Source

View Text - Preformatted

SELECT suaai.rowid ROW_ID, suaai.person_id , suaai.course_cd , suaai.unit_cd , suaai.cal_type , suaai.ci_sequence_number, suaai.ass_id, suaai.creation_dt, suaai.grading_schema_cd, suaai.gs_version_number, suaai.grade, suaai.outcome_dt, suaai.mark, suaai.OUTCOME_COMMENT_CODE, DECODE(IGS_GE_GEN_004.genp_get_lookup('MARKS_GRADE_CHANGE_COMMENT', suaai.outcome_comment_code ),'All' ,null,IGS_GE_GEN_004.genp_get_lookup('MARKS_GRADE_CHANGE_COMMENT', suaai.outcome_comment_code)) OUTCOME_COMMENT_MEANING, suaai.last_update_DATE HIST_START_DT, TO_DATE(null, 'YYYY-MM-DD') HIST_END_DT , suaai.last_updated_by HIST_WHO, suaai.created_by, suaai.creation_date, suaai.last_updated_by, suaai.last_update_date, suaai.last_update_login , suaai.uoo_id , suaai.sua_ass_item_group_id, suaai.midterm_mandatory_type_code, suaai.midterm_weight_qty, suaai.final_mandatory_type_code, suaai.final_weight_qty, suaai.submitted_date, suaai.waived_flag, suaai.penalty_applied_flag FROM IGS_AS_SU_ATMPT_ITM suaai, IGS_AS_SUAAI_OUHIST suaaih WHERE suaai.person_id = suaaih.person_id AND suaai.course_cd = suaaih.course_cd AND suaai.creation_dt = suaaih.creation_dt AND suaai.ass_id = suaaih.ass_id AND suaai.uoo_id = suaaih.uoo_id UNION SELECT suaaih.rowid , suaaih.person_id , suaaih.course_cd , suaaih.unit_cd , suaaih.cal_type , suaaih.ci_sequence_number, suaaih.ass_id, suaaih.creation_dt, suaaih.grading_schema_cd, suaaih.gs_version_number, suaaih.grade, suaaih.outcome_dt, suaaih.mark, suaaih.OUTCOME_COMMENT_CODE, DECODE(IGS_GE_GEN_004.genp_get_lookup('MARKS_GRADE_CHANGE_COMMENT', suaaih.outcome_comment_code ),'All' ,null,IGS_GE_GEN_004.genp_get_lookup('MARKS_GRADE_CHANGE_COMMENT', suaaih.outcome_comment_code)), suaaih.hist_start_dt, suaaih .hist_end_dt, suaaih.hist_who, suaaih.created_by, suaaih.creation_date, suaaih.last_updated_by, suaaih.last_update_date, suaaih.last_update_login , suaaih.uoo_id , suaaih.sua_ass_item_group_id, suaaih.midterm_mandatory_type_code, suaaih.midterm_weight_qty, suaaih.final_mandatory_type_code, suaaih.final_weight_qty, suaaih.submitted_date, suaaih.waived_flag, suaaih.penalty_applied_flag FROM IGS_AS_SU_ATMPT_ITM suaai, IGS_AS_SUAAI_OUHIST suaaih WHERE suaai.person_id = suaaih.person_id AND suaai.course_cd = suaaih.course_cd AND suaai.creation_dt = suaaih.creation_dt AND suaai.ass_id = suaaih.ass_id AND suaai.uoo_id = suaaih.uoo_id

View Text - HTML Formatted

SELECT SUAAI.ROWID ROW_ID
, SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.CREATION_DT
, SUAAI.GRADING_SCHEMA_CD
, SUAAI.GS_VERSION_NUMBER
, SUAAI.GRADE
, SUAAI.OUTCOME_DT
, SUAAI.MARK
, SUAAI.OUTCOME_COMMENT_CODE
, DECODE(IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAI.OUTCOME_COMMENT_CODE )
, 'ALL'
, NULL
, IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAI.OUTCOME_COMMENT_CODE)) OUTCOME_COMMENT_MEANING
, SUAAI.LAST_UPDATE_DATE HIST_START_DT
, TO_DATE(NULL
, 'YYYY-MM-DD') HIST_END_DT
, SUAAI.LAST_UPDATED_BY HIST_WHO
, SUAAI.CREATED_BY
, SUAAI.CREATION_DATE
, SUAAI.LAST_UPDATED_BY
, SUAAI.LAST_UPDATE_DATE
, SUAAI.LAST_UPDATE_LOGIN
, SUAAI.UOO_ID
, SUAAI.SUA_ASS_ITEM_GROUP_ID
, SUAAI.MIDTERM_MANDATORY_TYPE_CODE
, SUAAI.MIDTERM_WEIGHT_QTY
, SUAAI.FINAL_MANDATORY_TYPE_CODE
, SUAAI.FINAL_WEIGHT_QTY
, SUAAI.SUBMITTED_DATE
, SUAAI.WAIVED_FLAG
, SUAAI.PENALTY_APPLIED_FLAG
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_SUAAI_OUHIST SUAAIH
WHERE SUAAI.PERSON_ID = SUAAIH.PERSON_ID
AND SUAAI.COURSE_CD = SUAAIH.COURSE_CD
AND SUAAI.CREATION_DT = SUAAIH.CREATION_DT
AND SUAAI.ASS_ID = SUAAIH.ASS_ID
AND SUAAI.UOO_ID = SUAAIH.UOO_ID UNION SELECT SUAAIH.ROWID
, SUAAIH.PERSON_ID
, SUAAIH.COURSE_CD
, SUAAIH.UNIT_CD
, SUAAIH.CAL_TYPE
, SUAAIH.CI_SEQUENCE_NUMBER
, SUAAIH.ASS_ID
, SUAAIH.CREATION_DT
, SUAAIH.GRADING_SCHEMA_CD
, SUAAIH.GS_VERSION_NUMBER
, SUAAIH.GRADE
, SUAAIH.OUTCOME_DT
, SUAAIH.MARK
, SUAAIH.OUTCOME_COMMENT_CODE
, DECODE(IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAIH.OUTCOME_COMMENT_CODE )
, 'ALL'
, NULL
, IGS_GE_GEN_004.GENP_GET_LOOKUP('MARKS_GRADE_CHANGE_COMMENT'
, SUAAIH.OUTCOME_COMMENT_CODE))
, SUAAIH.HIST_START_DT
, SUAAIH .HIST_END_DT
, SUAAIH.HIST_WHO
, SUAAIH.CREATED_BY
, SUAAIH.CREATION_DATE
, SUAAIH.LAST_UPDATED_BY
, SUAAIH.LAST_UPDATE_DATE
, SUAAIH.LAST_UPDATE_LOGIN
, SUAAIH.UOO_ID
, SUAAIH.SUA_ASS_ITEM_GROUP_ID
, SUAAIH.MIDTERM_MANDATORY_TYPE_CODE
, SUAAIH.MIDTERM_WEIGHT_QTY
, SUAAIH.FINAL_MANDATORY_TYPE_CODE
, SUAAIH.FINAL_WEIGHT_QTY
, SUAAIH.SUBMITTED_DATE
, SUAAIH.WAIVED_FLAG
, SUAAIH.PENALTY_APPLIED_FLAG
FROM IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_AS_SUAAI_OUHIST SUAAIH
WHERE SUAAI.PERSON_ID = SUAAIH.PERSON_ID
AND SUAAI.COURSE_CD = SUAAIH.COURSE_CD
AND SUAAI.CREATION_DT = SUAAIH.CREATION_DT
AND SUAAI.ASS_ID = SUAAIH.ASS_ID
AND SUAAI.UOO_ID = SUAAIH.UOO_ID