VIEW: APPS.IGS_AS_UAI_ETISTD_EXAM_V

Source

View Text - Preformatted

SELECT ueciv.exam_cal_type, ueciv.exam_ci_sequence_number, ueciv.cal_type, ueciv.ci_sequence_number, ueciv.ass_id, ueciv.unit_cd, ueciv.reference, suaai.person_id, uv.owner_org_unit_cd, crv.responsible_org_unit_cd, pe.surname, pe.given_names, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SPCL_NEEDS(sua.person_id),1,1), SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXAM_TP(sua.person_id,sua.course_cd,sua.unit_cd, sua.cal_type, sua.ci_sequence_number,sua.unit_attempt_status,sua.uoo_id),1,20), SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(sua.person_id,sua.course_cd,sua.unit_cd, sua.cal_type,sua.ci_sequence_number,ueciv.ass_id,sua.uoo_id),1,10), ueciv.created_by, ueciv.creation_date, ueciv.last_updated_by, ueciv.last_update_date, ueciv.last_update_login ,sua.deg_aud_detail_id FROM IGS_AS_UAI_EXAM_CI_INIT_V ueciv, 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, IGS_EN_STDNT_PS_ATT sca, IGS_PS_VER crv, IGS_PE_PERSON pe WHERE tci.cal_type = ueciv.cal_type AND tci.sequence_number = ueciv.ci_sequence_number AND tcs.cal_status = tci.cal_status AND tcs.s_cal_status = 'ACTIVE' AND ai.ass_id = ueciv.ass_id AND uv.unit_cd = ueciv.unit_cd AND uv.version_number = ueciv.version_number AND us.unit_status = uv.unit_status AND us.s_unit_status = 'ACTIVE' AND suaai.ass_id = ueciv.ass_id AND suaai.unit_cd = ueciv.unit_cd AND suaai.cal_type = ueciv.cal_type AND suaai.ci_sequence_number = ueciv.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 in ('ENROLLED','COMPLETED') 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, ueciv.location_cd, ueciv.unit_class, ueciv.unit_mode) = 'TRUE' AND IGS_AS_GEN_002.assp_get_exam_view( ueciv.uai_exam_cal_type, ueciv.uai_exam_ci_sequence_number, ueciv.exam_cal_type, ueciv.exam_ci_sequence_number, sua.person_id, sua.course_cd, sua.unit_cd, sua.version_number, sua.cal_type, sua.ci_sequence_number, sua.unit_attempt_status, sua.location_cd, ucl.unit_mode, sua.unit_class, ueciv.ass_id) = 'Y' AND sca.person_id = sua.person_id AND sca.course_cd = sua.course_cd AND crv.course_cd = sca.course_cd AND crv.version_number = sca.version_number AND pe.person_id = suaai.person_id

View Text - HTML Formatted

SELECT UECIV.EXAM_CAL_TYPE
, UECIV.EXAM_CI_SEQUENCE_NUMBER
, UECIV.CAL_TYPE
, UECIV.CI_SEQUENCE_NUMBER
, UECIV.ASS_ID
, UECIV.UNIT_CD
, UECIV.REFERENCE
, SUAAI.PERSON_ID
, UV.OWNER_ORG_UNIT_CD
, CRV.RESPONSIBLE_ORG_UNIT_CD
, PE.SURNAME
, PE.GIVEN_NAMES
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SPCL_NEEDS(SUA.PERSON_ID)
, 1
, 1)
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXAM_TP(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UNIT_ATTEMPT_STATUS
, SUA.UOO_ID)
, 1
, 20)
, SUBSTR(IGS_AS_GEN_003.ASSP_GET_SUA_EXLOC(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, UECIV.ASS_ID
, SUA.UOO_ID)
, 1
, 10)
, UECIV.CREATED_BY
, UECIV.CREATION_DATE
, UECIV.LAST_UPDATED_BY
, UECIV.LAST_UPDATE_DATE
, UECIV.LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID
FROM IGS_AS_UAI_EXAM_CI_INIT_V UECIV
, 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
, IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_VER CRV
, IGS_PE_PERSON PE
WHERE TCI.CAL_TYPE = UECIV.CAL_TYPE
AND TCI.SEQUENCE_NUMBER = UECIV.CI_SEQUENCE_NUMBER
AND TCS.CAL_STATUS = TCI.CAL_STATUS
AND TCS.S_CAL_STATUS = 'ACTIVE'
AND AI.ASS_ID = UECIV.ASS_ID
AND UV.UNIT_CD = UECIV.UNIT_CD
AND UV.VERSION_NUMBER = UECIV.VERSION_NUMBER
AND US.UNIT_STATUS = UV.UNIT_STATUS
AND US.S_UNIT_STATUS = 'ACTIVE'
AND SUAAI.ASS_ID = UECIV.ASS_ID
AND SUAAI.UNIT_CD = UECIV.UNIT_CD
AND SUAAI.CAL_TYPE = UECIV.CAL_TYPE
AND SUAAI.CI_SEQUENCE_NUMBER = UECIV.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 IN ('ENROLLED'
, 'COMPLETED')
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
, UECIV.LOCATION_CD
, UECIV.UNIT_CLASS
, UECIV.UNIT_MODE) = 'TRUE'
AND IGS_AS_GEN_002.ASSP_GET_EXAM_VIEW( UECIV.UAI_EXAM_CAL_TYPE
, UECIV.UAI_EXAM_CI_SEQUENCE_NUMBER
, UECIV.EXAM_CAL_TYPE
, UECIV.EXAM_CI_SEQUENCE_NUMBER
, SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UNIT_ATTEMPT_STATUS
, SUA.LOCATION_CD
, UCL.UNIT_MODE
, SUA.UNIT_CLASS
, UECIV.ASS_ID) = 'Y'
AND SCA.PERSON_ID = SUA.PERSON_ID
AND SCA.COURSE_CD = SUA.COURSE_CD
AND CRV.COURSE_CD = SCA.COURSE_CD
AND CRV.VERSION_NUMBER = SCA.VERSION_NUMBER
AND PE.PERSON_ID = SUAAI.PERSON_ID