VIEW: APPS.IGS_AS_UAI_SUA_V

Source

View Text - Preformatted

SELECT sua.person_id, sua.course_cd, sua.unit_cd, uai.version_number, sua.cal_type, sua.ci_sequence_number, uai.ass_id, uai.sequence_number, NULL, /* uai.location_cd, */ NULL, /* uai.unit_class, */ NULL, /* uai.unit_mode, */ uai.reference, uai.due_dt, uai.dflt_item_ind, uai.logical_delete_dt, uai.action_dt, NULL, /* sua.location_cd, */ NULL, /* sua.unit_class, */ NULL, /* uc.unit_mode, */ uai.created_by, uai.creation_date, uai.last_updated_by, uai.last_update_date, uai.last_update_login, sua.deg_aud_detail_id, sua.uoo_id , uai.unit_ass_item_id, NVL(uai.description, ast.description), uai.grading_schema_cd, uai.gs_version_number, uai.unit_ass_item_group_id, uai.midterm_mandatory_type_code, uai.midterm_weight_qty, uai.final_mandatory_type_code, uai.final_weight_qty FROM IGS_EN_SU_ATTEMPT sua, IGS_AS_UNITASS_ITEM_ALL uai, IGS_AS_ASSESSMNT_ITM_ALL ast WHERE sua.unit_cd = uai.unit_cd AND sua.version_number = uai.version_number AND sua.cal_type = uai.cal_type AND sua.ci_sequence_number = uai.ci_sequence_number AND uai.ass_id = ast.ass_id AND IGS_AS_VAL_UAI.assp_val_sua_ai_acot(uai.ass_id, sua.person_id, sua.course_cd) = 'TRUE'

View Text - HTML Formatted

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, UAI.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UAI.ASS_ID
, UAI.SEQUENCE_NUMBER
, NULL
, /* UAI.LOCATION_CD
, */ NULL
, /* UAI.UNIT_CLASS
, */ NULL
, /* UAI.UNIT_MODE
, */ UAI.REFERENCE
, UAI.DUE_DT
, UAI.DFLT_ITEM_IND
, UAI.LOGICAL_DELETE_DT
, UAI.ACTION_DT
, NULL
, /* SUA.LOCATION_CD
, */ NULL
, /* SUA.UNIT_CLASS
, */ NULL
, /* UC.UNIT_MODE
, */ UAI.CREATED_BY
, UAI.CREATION_DATE
, UAI.LAST_UPDATED_BY
, UAI.LAST_UPDATE_DATE
, UAI.LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID
, SUA.UOO_ID
, UAI.UNIT_ASS_ITEM_ID
, NVL(UAI.DESCRIPTION
, AST.DESCRIPTION)
, UAI.GRADING_SCHEMA_CD
, UAI.GS_VERSION_NUMBER
, UAI.UNIT_ASS_ITEM_GROUP_ID
, UAI.MIDTERM_MANDATORY_TYPE_CODE
, UAI.MIDTERM_WEIGHT_QTY
, UAI.FINAL_MANDATORY_TYPE_CODE
, UAI.FINAL_WEIGHT_QTY
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNITASS_ITEM_ALL UAI
, IGS_AS_ASSESSMNT_ITM_ALL AST
WHERE SUA.UNIT_CD = UAI.UNIT_CD
AND SUA.VERSION_NUMBER = UAI.VERSION_NUMBER
AND SUA.CAL_TYPE = UAI.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = UAI.CI_SEQUENCE_NUMBER
AND UAI.ASS_ID = AST.ASS_ID
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_AI_ACOT(UAI.ASS_ID
, SUA.PERSON_ID
, SUA.COURSE_CD) = 'TRUE'