VIEW: APPS.IGS_AS_SU_ATTEMPT_LKUP_V

Source

View Text - Preformatted

SELECT sua.person_id PERSON_ID, sua.course_cd COURSE_CD, sua.unit_cd UNIT_CD, sua.version_number VERSION_NUMBER, sua.cal_type CAL_TYPE, sua.ci_sequence_number CI_SEQUENCE_NUMBER, SUBSTR( IGS_EN_GEN_014.enrs_get_acad_alt_cd(sua.cal_type,sua.ci_sequence_number),1,10) ACAD_ALTERNATE_CODE, SUBSTR(IGS_CA_GEN_001.calp_get_alt_cd(sua.cal_type,sua.ci_sequence_number),1,10) TEACH_ALTERNATE_CODE, sua.location_cd LOCATION_CD, sua.unit_class UNIT_CLASS, sua.ci_start_dt CI_START_DT, sua.ci_end_dt CI_END_DT, sua.uoo_id UOO_ID, sua.enrolled_dt ENROLLED_DT , sua.unit_attempt_status UNIT_ATTEMPT_STATUS, sua.administrative_unit_status ADMINISTRATIVE_UNIT_STATUS, sua.discontinued_dt DISCONTINUED_DT, sua.rule_waived_dt RULE_WAIVED_DT, sua.rule_waived_person_id RULE_WAIVED_PERSON_ID, sua.no_assessment_ind NO_ASSESSMENT_IND, sua.sup_unit_cd SUP_UNIT_CD, sua.sup_version_number SUP_VERSION_NUMBER, sua.exam_location_cd EXAM_LOCATION_CD, sua.alternative_title ALTERNATIVE_TITLE, sua.override_enrolled_cp OVERRIDE_ENROLLED_CP, sua.override_eftsu OVERRIDE_EFTSU, sua.override_achievable_cp OVERRIDE_ACHIEVABLE_CP, sua.override_outcome_due_dt OVERRIDE_OUTCOME_DUE_DT, sua.override_credit_reason OVERRIDE_CREDIT_REASON, SUAO.OUTCOME_DT OUTCOME_DT, SUAO.GRADING_SCHEMA_CD GRADING_SCHEMA_CD, SUAO.GRADE GRADE, SUAO.MARK MARK, UV1.TITLE TITLE, NVL(cps.ENROLLED_CREDIT_POINTS ,UV1.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS, lkups.meaning MEANING, sua.created_by CREATED_BY , sua.creation_date CREATION_DATE, sua.last_updated_by LAST_UPDATED_BY, sua.last_update_date LAST_UPDATE_DATE, sua.last_update_login LAST_UPDATE_LOGIN ,sua.deg_aud_detail_id DEG_AUD_DETAIL_ID FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_USEC_CPS cps, IGS_PS_UNIT_VER UV1, IGS_AS_SU_STMPTOUT SUAO, IGS_LOOkUPS_VIEW lkups WHERE SUAO.PERSON_ID = SUA.PERSON_ID AND SUAO.COURSE_CD = SUA.COURSE_CD AND SUAO.UOO_ID = SUA.UOO_ID AND UV1.UNIT_CD = SUA.UNIT_CD AND UV1.VERSION_NUMBER = SUA.VERSION_NUMBER AND sua.uoo_id = uoo.uoo_id AND uoo.uoo_id = cps.uoo_id(+) AND lkups.LOOKUP_CODE = SUA.UNIT_ATTEMPT_STATUS AND lkups.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'

View Text - HTML Formatted

SELECT SUA.PERSON_ID PERSON_ID
, SUA.COURSE_CD COURSE_CD
, SUA.UNIT_CD UNIT_CD
, SUA.VERSION_NUMBER VERSION_NUMBER
, SUA.CAL_TYPE CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER CI_SEQUENCE_NUMBER
, SUBSTR( IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10) ACAD_ALTERNATE_CODE
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10) TEACH_ALTERNATE_CODE
, SUA.LOCATION_CD LOCATION_CD
, SUA.UNIT_CLASS UNIT_CLASS
, SUA.CI_START_DT CI_START_DT
, SUA.CI_END_DT CI_END_DT
, SUA.UOO_ID UOO_ID
, SUA.ENROLLED_DT ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT DISCONTINUED_DT
, SUA.RULE_WAIVED_DT RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID RULE_WAIVED_PERSON_ID
, SUA.NO_ASSESSMENT_IND NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON OVERRIDE_CREDIT_REASON
, SUAO.OUTCOME_DT OUTCOME_DT
, SUAO.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, SUAO.GRADE GRADE
, SUAO.MARK MARK
, UV1.TITLE TITLE
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV1.ENROLLED_CREDIT_POINTS) ENROLLED_CREDIT_POINTS
, LKUPS.MEANING MEANING
, SUA.CREATED_BY CREATED_BY
, SUA.CREATION_DATE CREATION_DATE
, SUA.LAST_UPDATED_BY LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUA.DEG_AUD_DETAIL_ID DEG_AUD_DETAIL_ID
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_USEC_CPS CPS
, IGS_PS_UNIT_VER UV1
, IGS_AS_SU_STMPTOUT SUAO
, IGS_LOOKUPS_VIEW LKUPS
WHERE SUAO.PERSON_ID = SUA.PERSON_ID
AND SUAO.COURSE_CD = SUA.COURSE_CD
AND SUAO.UOO_ID = SUA.UOO_ID
AND UV1.UNIT_CD = SUA.UNIT_CD
AND UV1.VERSION_NUMBER = SUA.VERSION_NUMBER
AND SUA.UOO_ID = UOO.UOO_ID
AND UOO.UOO_ID = CPS.UOO_ID(+)
AND LKUPS.LOOKUP_CODE = SUA.UNIT_ATTEMPT_STATUS
AND LKUPS.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'