VIEW: APPS.IGS_AS_USECAI_SUA_V

Source

View Text - Preformatted

SELECT sua.rowid, sua.person_id, sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number, sua.uoo_id, usai.ass_id, usai.sequence_number, NULL, /* uoo.location_cd, */ NULL, /* uoo.unit_class, */ NULL, /* uc.unit_mode, */ usai.reference, usai.due_dt, usai.dflt_item_ind, usai.logical_delete_dt, usai.action_dt, NULL, /* sua.location_cd, */ NULL, /* sua.unit_class, */ NULL, /* uc.unit_mode, */ usai.created_by, usai.creation_date, usai.last_updated_by, usai.last_update_date, usai.last_update_login, NVL(usai.description, ast.description), usai.grading_schema_cd, usai.gs_version_number, usai.unit_section_ass_item_id, usai.us_ass_item_group_id, usai.midterm_mandatory_type_code, usai.midterm_weight_qty, usai.final_mandatory_type_code, usai.final_weight_qty FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNITASS_ITEM usai, IGS_AS_UNIT_CLASS uc, IGS_PS_UNIT_OFR_OPT uoo, IGS_AS_ASSESSMNT_ITM_ALL ast WHERE sua.uoo_id = usai.uoo_id AND usai.ass_id =ast.ass_id AND sua.unit_class = uc.unit_class AND uoo.uoo_id = usai.uoo_id AND IGS_AS_VAL_UAI.assp_val_sua_uai(sua.location_cd, sua.unit_class,uc.unit_mode, uoo.location_cd,uoo.unit_class,uc.unit_mode) = 'TRUE' AND IGS_AS_VAL_UAI.assp_val_sua_ai_acot(usai.ass_id,sua.person_id,sua.course_cd) = 'TRUE'

View Text - HTML Formatted

SELECT SUA.ROWID
, SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UOO_ID
, USAI.ASS_ID
, USAI.SEQUENCE_NUMBER
, NULL
, /* UOO.LOCATION_CD
, */ NULL
, /* UOO.UNIT_CLASS
, */ NULL
, /* UC.UNIT_MODE
, */ USAI.REFERENCE
, USAI.DUE_DT
, USAI.DFLT_ITEM_IND
, USAI.LOGICAL_DELETE_DT
, USAI.ACTION_DT
, NULL
, /* SUA.LOCATION_CD
, */ NULL
, /* SUA.UNIT_CLASS
, */ NULL
, /* UC.UNIT_MODE
, */ USAI.CREATED_BY
, USAI.CREATION_DATE
, USAI.LAST_UPDATED_BY
, USAI.LAST_UPDATE_DATE
, USAI.LAST_UPDATE_LOGIN
, NVL(USAI.DESCRIPTION
, AST.DESCRIPTION)
, USAI.GRADING_SCHEMA_CD
, USAI.GS_VERSION_NUMBER
, USAI.UNIT_SECTION_ASS_ITEM_ID
, USAI.US_ASS_ITEM_GROUP_ID
, USAI.MIDTERM_MANDATORY_TYPE_CODE
, USAI.MIDTERM_WEIGHT_QTY
, USAI.FINAL_MANDATORY_TYPE_CODE
, USAI.FINAL_WEIGHT_QTY
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNITASS_ITEM USAI
, IGS_AS_UNIT_CLASS UC
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_AS_ASSESSMNT_ITM_ALL AST
WHERE SUA.UOO_ID = USAI.UOO_ID
AND USAI.ASS_ID =AST.ASS_ID
AND SUA.UNIT_CLASS = UC.UNIT_CLASS
AND UOO.UOO_ID = USAI.UOO_ID
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, UOO.LOCATION_CD
, UOO.UNIT_CLASS
, UC.UNIT_MODE) = 'TRUE'
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_AI_ACOT(USAI.ASS_ID
, SUA.PERSON_ID
, SUA.COURSE_CD) = 'TRUE'