VIEW: APPS.IGSBV_AS_SU_ATMPT_AST_ITEMS

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, DECODE ( suai.unit_section_ass_item_id, NULL, NVL ( (SELECT aui. description FROM igs_as_unitass_item_all aui WHERE aui.unit_ass_item_id = suai.unit_ass_item_id), ai.description ), NVL ( (SELECT ps. description FROM igs_ps_unitass_item ps WHERE ps.unit_section_ass_item_id = suai.unit_section_ass_item_id), ai.description ) ) ASSESSMENT_ITEM, SUAI.COURSE_CD, CRV.TITLE, SUAI.UNIT_CD, UV.TITLE, SUAI.CAL_TYPE, SUAI.CI_SEQUENCE_NUMBER, CI.DESCRIPTION, SUAI.GRADE, SUAI.MARK, SUAI.CREATION_DT, '_LA:SUAI.S_DEFAULT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', SUAI.OUTCOME_DT, SUAI.OVERRIDE_DUE_DT, SUAI.PERFORMANCE, '_LA:SUAI.OUTCOME_COMMENT_CODE:IGS_LOOKUP_VALUES:MARKS_GRADE_CHANGE_COMMENT:MEANING', SUAI.GRADING_SCHEMA_CD, SUAI.GS_VERSION_NUMBER, SUA.VERSION_NUMBER, SCA.VERSION_NUMBER, SUAI.PERSON_ID, SUAI.ASS_ID, SUAI.ASS_PATTERN_ID, SUAI.TRACKING_ID, SUAI.ATTEMPT_NUMBER, SUAI.LOGICAL_DELETE_DT, SUAI.CREATED_BY, SUAI.CREATION_DATE, SUAI.LAST_UPDATED_BY, SUAI.LAST_UPDATE_DATE, SUAI.UOO_ID, suai.sua_ass_item_group_id, suai.midterm_mandatory_type_code, suai.midterm_weight_qty, suai.final_mandatory_type_code, suai.final_weight_qty, suai.submitted_date, suai.waived_flag, suai.penalty_applied_flag FROM IGS_AS_SU_ATMPT_ITM SUAI, IGS_EN_SU_ATTEMPT_ALL SUA, IGS_EN_STDNT_PS_ATT_ALL SCA, IGS_PS_UNIT_VER_ALL UV, IGS_PS_VER_ALL CRV, IGS_AS_ASSESSMNT_ITM_ALL AI, IGS_CA_INST_ALL CI, HZ_PARTIES HP WHERE SUAI.PERSON_ID = HP.PARTY_ID AND SUAI.PERSON_ID = SUA.PERSON_ID AND SUAI.COURSE_CD = SUA.COURSE_CD AND SUAI.UOO_ID = SUA.UOO_ID AND SUAI.PERSON_ID = SCA.PERSON_ID AND SUAI.COURSE_CD = SCA.COURSE_CD AND SUAI.ASS_ID = AI.ASS_ID AND SUA.UNIT_CD = UV.UNIT_CD AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER AND SCA.COURSE_CD = CRV.COURSE_CD AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER AND SUAI.CAL_TYPE = CI.CAL_TYPE AND SUAI.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, DECODE ( SUAI.UNIT_SECTION_ASS_ITEM_ID
, NULL
, NVL ( (SELECT AUI. DESCRIPTION
FROM IGS_AS_UNITASS_ITEM_ALL AUI
WHERE AUI.UNIT_ASS_ITEM_ID = SUAI.UNIT_ASS_ITEM_ID)
, AI.DESCRIPTION )
, NVL ( (SELECT PS. DESCRIPTION
FROM IGS_PS_UNITASS_ITEM PS
WHERE PS.UNIT_SECTION_ASS_ITEM_ID = SUAI.UNIT_SECTION_ASS_ITEM_ID)
, AI.DESCRIPTION ) ) ASSESSMENT_ITEM
, SUAI.COURSE_CD
, CRV.TITLE
, SUAI.UNIT_CD
, UV.TITLE
, SUAI.CAL_TYPE
, SUAI.CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, SUAI.GRADE
, SUAI.MARK
, SUAI.CREATION_DT
, '_LA:SUAI.S_DEFAULT_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, SUAI.OUTCOME_DT
, SUAI.OVERRIDE_DUE_DT
, SUAI.PERFORMANCE
, '_LA:SUAI.OUTCOME_COMMENT_CODE:IGS_LOOKUP_VALUES:MARKS_GRADE_CHANGE_COMMENT:MEANING'
, SUAI.GRADING_SCHEMA_CD
, SUAI.GS_VERSION_NUMBER
, SUA.VERSION_NUMBER
, SCA.VERSION_NUMBER
, SUAI.PERSON_ID
, SUAI.ASS_ID
, SUAI.ASS_PATTERN_ID
, SUAI.TRACKING_ID
, SUAI.ATTEMPT_NUMBER
, SUAI.LOGICAL_DELETE_DT
, SUAI.CREATED_BY
, SUAI.CREATION_DATE
, SUAI.LAST_UPDATED_BY
, SUAI.LAST_UPDATE_DATE
, SUAI.UOO_ID
, SUAI.SUA_ASS_ITEM_GROUP_ID
, SUAI.MIDTERM_MANDATORY_TYPE_CODE
, SUAI.MIDTERM_WEIGHT_QTY
, SUAI.FINAL_MANDATORY_TYPE_CODE
, SUAI.FINAL_WEIGHT_QTY
, SUAI.SUBMITTED_DATE
, SUAI.WAIVED_FLAG
, SUAI.PENALTY_APPLIED_FLAG
FROM IGS_AS_SU_ATMPT_ITM SUAI
, IGS_EN_SU_ATTEMPT_ALL SUA
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_UNIT_VER_ALL UV
, IGS_PS_VER_ALL CRV
, IGS_AS_ASSESSMNT_ITM_ALL AI
, IGS_CA_INST_ALL CI
, HZ_PARTIES HP
WHERE SUAI.PERSON_ID = HP.PARTY_ID
AND SUAI.PERSON_ID = SUA.PERSON_ID
AND SUAI.COURSE_CD = SUA.COURSE_CD
AND SUAI.UOO_ID = SUA.UOO_ID
AND SUAI.PERSON_ID = SCA.PERSON_ID
AND SUAI.COURSE_CD = SCA.COURSE_CD
AND SUAI.ASS_ID = AI.ASS_ID
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUAI.CAL_TYPE = CI.CAL_TYPE
AND SUAI.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER WITH READ ONLY