VIEW: APPS.IGS_AS_SUAAI_V

Source

View Text - Preformatted

SELECT suaai.rowid, suaai.person_id, suaai.course_cd, suaai.unit_cd, suaai.cal_type, suaai.ci_sequence_number, suaai.ass_id, suaai.creation_dt, suaai.attempt_number, suaai.outcome_dt, suaai.override_due_dt, asi.assessment_type dsp_assessment_type, DECODE ( suaai.unit_section_ass_item_id, NULL, NVL ( (SELECT aui.description FROM igs_as_unitass_item_all aui WHERE aui.unit_ass_item_id = suaai.unit_ass_item_id), asi.description), NVL ( (SELECT description FROM igs_ps_unitass_item ps WHERE ps.unit_section_ass_item_id = suaai.unit_section_ass_item_id), asi.description) ) dsp_description, suaai.mark , suaai.grade , suaai.grading_schema_cd , suaai.gs_version_number , 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.performance, suaai.tracking_id, suaai.logical_delete_dt, suaai.s_default_ind, IGS_AS_GEN_003.assp_get_uai_due_dt(suaai.person_id, suaai.course_cd, suaai.unit_cd, suaai.cal_type, suaai.ci_sequence_number, suaai.ass_id, suaai.uoo_id), IGS_AS_GEN_003.assp_get_uai_ref( suaai.person_id, suaai.course_cd, suaai.unit_cd, suaai.cal_type, suaai.ci_sequence_number, suaai.ass_id, suaai.uoo_id), suaai.ass_pattern_id, NULL, /* IGS_AS_GEN_004.assp_get_uapi_ap(suaai.ass_pattern_id, suaai.ass_id), */ SUBSTR( IGS_AS_GEN_001.assp_clc_suaai_valid(suaai.person_id, suaai.unit_cd, suaai.course_cd, suaai.cal_type, suaai.ci_sequence_number, suaai.ass_pattern_id, suaai.ass_id, suaai.logical_delete_dt, suaai.uoo_id), 1, 7), suaai.attribute_category , suaai.attribute1 , suaai.attribute2 , suaai.attribute3 , suaai.attribute4 , suaai.attribute5 , suaai.attribute6 , suaai.attribute7 , suaai.attribute8 , suaai.attribute9 , suaai.attribute10 , suaai.attribute11 , suaai.attribute12 , suaai.attribute13 , suaai.attribute14 , suaai.attribute15 , suaai.attribute16 , suaai.attribute17 , suaai.attribute18 , suaai.attribute19 , suaai.attribute20, suaai.created_by, suaai.creation_date, suaai.last_updated_by, suaai.last_update_date, suaai.last_update_login, suaai.uoo_id, suaai.unit_section_ass_item_id , suaai.unit_ass_item_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_ASSESSMNT_ITM_ALL asi WHERE suaai.ass_id = asi.ass_id

View Text - HTML Formatted

SELECT SUAAI.ROWID
, SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.CREATION_DT
, SUAAI.ATTEMPT_NUMBER
, SUAAI.OUTCOME_DT
, SUAAI.OVERRIDE_DUE_DT
, ASI.ASSESSMENT_TYPE DSP_ASSESSMENT_TYPE
, DECODE ( SUAAI.UNIT_SECTION_ASS_ITEM_ID
, NULL
, NVL ( (SELECT AUI.DESCRIPTION
FROM IGS_AS_UNITASS_ITEM_ALL AUI
WHERE AUI.UNIT_ASS_ITEM_ID = SUAAI.UNIT_ASS_ITEM_ID)
, ASI.DESCRIPTION)
, NVL ( (SELECT DESCRIPTION
FROM IGS_PS_UNITASS_ITEM PS
WHERE PS.UNIT_SECTION_ASS_ITEM_ID = SUAAI.UNIT_SECTION_ASS_ITEM_ID)
, ASI.DESCRIPTION) ) DSP_DESCRIPTION
, SUAAI.MARK
, SUAAI.GRADE
, SUAAI.GRADING_SCHEMA_CD
, SUAAI.GS_VERSION_NUMBER
, 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.PERFORMANCE
, SUAAI.TRACKING_ID
, SUAAI.LOGICAL_DELETE_DT
, SUAAI.S_DEFAULT_IND
, IGS_AS_GEN_003.ASSP_GET_UAI_DUE_DT(SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.UOO_ID)
, IGS_AS_GEN_003.ASSP_GET_UAI_REF( SUAAI.PERSON_ID
, SUAAI.COURSE_CD
, SUAAI.UNIT_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_ID
, SUAAI.UOO_ID)
, SUAAI.ASS_PATTERN_ID
, NULL
, /* IGS_AS_GEN_004.ASSP_GET_UAPI_AP(SUAAI.ASS_PATTERN_ID
, SUAAI.ASS_ID)
, */ SUBSTR( IGS_AS_GEN_001.ASSP_CLC_SUAAI_VALID(SUAAI.PERSON_ID
, SUAAI.UNIT_CD
, SUAAI.COURSE_CD
, SUAAI.CAL_TYPE
, SUAAI.CI_SEQUENCE_NUMBER
, SUAAI.ASS_PATTERN_ID
, SUAAI.ASS_ID
, SUAAI.LOGICAL_DELETE_DT
, SUAAI.UOO_ID)
, 1
, 7)
, SUAAI.ATTRIBUTE_CATEGORY
, SUAAI.ATTRIBUTE1
, SUAAI.ATTRIBUTE2
, SUAAI.ATTRIBUTE3
, SUAAI.ATTRIBUTE4
, SUAAI.ATTRIBUTE5
, SUAAI.ATTRIBUTE6
, SUAAI.ATTRIBUTE7
, SUAAI.ATTRIBUTE8
, SUAAI.ATTRIBUTE9
, SUAAI.ATTRIBUTE10
, SUAAI.ATTRIBUTE11
, SUAAI.ATTRIBUTE12
, SUAAI.ATTRIBUTE13
, SUAAI.ATTRIBUTE14
, SUAAI.ATTRIBUTE15
, SUAAI.ATTRIBUTE16
, SUAAI.ATTRIBUTE17
, SUAAI.ATTRIBUTE18
, SUAAI.ATTRIBUTE19
, SUAAI.ATTRIBUTE20
, SUAAI.CREATED_BY
, SUAAI.CREATION_DATE
, SUAAI.LAST_UPDATED_BY
, SUAAI.LAST_UPDATE_DATE
, SUAAI.LAST_UPDATE_LOGIN
, SUAAI.UOO_ID
, SUAAI.UNIT_SECTION_ASS_ITEM_ID
, SUAAI.UNIT_ASS_ITEM_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_ASSESSMNT_ITM_ALL ASI
WHERE SUAAI.ASS_ID = ASI.ASS_ID