VIEW: APPS.IGS_AS_UAI_EXAMINATION_V

Source

View Text - Preformatted

SELECT DISTINCT uecv.exam_cal_type, uecv.exam_ci_sequence_number, uecv.caL_type, uecv.ci_sequence_number, uecv.ass_id, uecv.unit_cd, uecv.reference, ai.exam_paper_name, uv.owner_org_unit_cd, ai.exam_working_time, IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(sua.person_id,sua.course_cd,sua.unit_cd,sua.caL_type, sua.ci_sequence_number,uecv.ass_id, sua.uoo_id), sua.deg_aud_detail_id FROM IGS_AS_UAI_EXAM_CI_V uecv, IGS_CA_INST tci, IGS_CA_STAT tcs, IGS_AS_ASSESSMNT_ITM ai, IGS_PS_UNIT_VER uv, IGS_PS_UNIT_STAT us, IGS_AS_SU_ATMPT_ITM suaai, IGS_EN_SU_ATTEMPT sua, IGS_AS_UNIT_CLASS ucl WHERE tci.caL_type = uecv.caL_type AND tci.sequence_number = uecv.ci_sequence_number AND tcs.cal_status = tci.cal_status AND tcs.s_cal_status = 'ACTIVE' AND ai.ass_id = uecv.ass_id AND uv.unit_cd = uecv.unit_cd AND uv.version_number = uecv.version_number AND us.unit_status = uv.unit_status AND us.s_unit_status = 'ACTIVE' AND suaai.ass_id = uecv.ass_id AND suaai.unit_cd = uecv.unit_cd AND suaai.caL_type = uecv.caL_type AND suaai.ci_sequence_number = uecv.ci_sequence_number AND suaai.logical_delete_dt IS NULL AND sua.person_id = suaai.person_id AND sua.course_cd = suaai.course_cd AND sua.uoo_id = suaai.uoo_id AND sua.unit_attempt_status = 'ENROLLED' AND sua.no_assessment_ind = 'N' AND ucl.unit_class = sua.unit_class AND IGS_AS_VAL_UAI.assp_val_sua_uai(sua.location_cd, sua.unit_class, ucl.unit_mode, uecv.location_cd, uecv.unit_class, uecv.unit_mode) = 'TRUE'

View Text - HTML Formatted

SELECT DISTINCT UECV.EXAM_CAL_TYPE
, UECV.EXAM_CI_SEQUENCE_NUMBER
, UECV.CAL_TYPE
, UECV.CI_SEQUENCE_NUMBER
, UECV.ASS_ID
, UECV.UNIT_CD
, UECV.REFERENCE
, AI.EXAM_PAPER_NAME
, UV.OWNER_ORG_UNIT_CD
, AI.EXAM_WORKING_TIME
, IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UECV.ASS_ID
, SUA.UOO_ID)
, SUA.DEG_AUD_DETAIL_ID
FROM IGS_AS_UAI_EXAM_CI_V UECV
, IGS_CA_INST TCI
, IGS_CA_STAT TCS
, IGS_AS_ASSESSMNT_ITM AI
, IGS_PS_UNIT_VER UV
, IGS_PS_UNIT_STAT US
, IGS_AS_SU_ATMPT_ITM SUAAI
, IGS_EN_SU_ATTEMPT SUA
, IGS_AS_UNIT_CLASS UCL
WHERE TCI.CAL_TYPE = UECV.CAL_TYPE
AND TCI.SEQUENCE_NUMBER = UECV.CI_SEQUENCE_NUMBER
AND TCS.CAL_STATUS = TCI.CAL_STATUS
AND TCS.S_CAL_STATUS = 'ACTIVE'
AND AI.ASS_ID = UECV.ASS_ID
AND UV.UNIT_CD = UECV.UNIT_CD
AND UV.VERSION_NUMBER = UECV.VERSION_NUMBER
AND US.UNIT_STATUS = UV.UNIT_STATUS
AND US.S_UNIT_STATUS = 'ACTIVE'
AND SUAAI.ASS_ID = UECV.ASS_ID
AND SUAAI.UNIT_CD = UECV.UNIT_CD
AND SUAAI.CAL_TYPE = UECV.CAL_TYPE
AND SUAAI.CI_SEQUENCE_NUMBER = UECV.CI_SEQUENCE_NUMBER
AND SUAAI.LOGICAL_DELETE_DT IS NULL
AND SUA.PERSON_ID = SUAAI.PERSON_ID
AND SUA.COURSE_CD = SUAAI.COURSE_CD
AND SUA.UOO_ID = SUAAI.UOO_ID
AND SUA.UNIT_ATTEMPT_STATUS = 'ENROLLED'
AND SUA.NO_ASSESSMENT_IND = 'N'
AND UCL.UNIT_CLASS = SUA.UNIT_CLASS
AND IGS_AS_VAL_UAI.ASSP_VAL_SUA_UAI(SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UCL.UNIT_MODE
, UECV.LOCATION_CD
, UECV.UNIT_CLASS
, UECV.UNIT_MODE) = 'TRUE'