VIEW: APPS.IGSFV_STUDENT_UNIT_ATTEMPTS

Source

View Text - Preformatted

SELECT sua.PERSON_ID, sua.COURSE_CD, sua.UNIT_CD, sua.VERSION_NUMBER, sua.CAL_TYPE, sua.CI_SEQUENCE_NUMBER, sua.LOCATION_CD, sua.UNIT_CLASS, sua.CI_START_DT, sua.CI_END_DT, sua.ENROLLED_DT, sua.UNIT_ATTEMPT_STATUS, sua.ADMINISTRATIVE_UNIT_STATUS, sua.DISCONTINUED_DT, sua.RULE_WAIVED_DT, sua.NO_ASSESSMENT_IND, sua.SUP_UNIT_CD, sua.SUP_VERSION_NUMBER, sua.EXAM_LOCATION_CD, sua.ALTERNATIVE_TITLE, sua.OVERRIDE_ENROLLED_CP, sua.OVERRIDE_EFTSU, sua.OVERRIDE_ACHIEVABLE_CP, sua.OVERRIDE_OUTCOME_DUE_DT, sua.OVERRIDE_CREDIT_REASON, sua.ADMINISTRATIVE_PRIORITY, sua.WAITLIST_DT, sua.DCNT_REASON_CD, sua.GRADING_SCHEMA_CODE, sua.GS_VERSION_NUMBER, sua.ENR_METHOD_TYPE, sua.FAILED_UNIT_RULE, sua.CART, sua.ORG_UNIT_CD, sua.SUBTITLE, sua.STUDENT_CAREER_TRANSCRIPT, sua.STUDENT_CAREER_STATISTICS, hp1.PARTY_NUMBER, crv.TITLE, uv.TITLE, ca.DESCRIPTION, loc1.DESCRIPTION, ucl.DESCRIPTION, '_LA:sua.UNIT_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:UNIT_ATTEMPT_STATUS:MEANING', aus.DESCRIPTION, uv1.TITLE, loc2.DESCRIPTION, dr.DESCRIPTION, gs.DESCRIPTION, em.DESCRIPTION, sua.CORE_INDICATOR_CODE, hp2.PARTY_NAME, hp3.PARTY_NUMBER, rse.PRIORITY_ID, rse.PREFERENCE_ID, rse.RSV_LEVEL, sua.RULE_WAIVED_PERSON_ID, sua.UOO_ID, sua.DEG_AUD_DETAIL_ID, sua.RSV_SEAT_EXT_ID, sua.SESSION_ID, sua.CREATED_BY, sua.CREATION_DATE, sua.LAST_UPDATED_BY, sua.LAST_UPDATE_DATE FROM IGS_EN_SU_ATTEMPT_ALL sua, HZ_PARTIES hp1, IGS_EN_STDNT_PS_ATT_ALL sca, IGS_PS_VER_ALL crv, IGS_PS_UNIT_VER_ALL uv, IGS_CA_INST_ALL ca, IGS_AD_LOCATION_ALL loc1, IGS_AS_UNIT_CLASS_ALL ucl, IGS_AD_ADM_UNIT_STAT_ALL aus, IGS_PS_UNIT_VER_ALL uv1, IGS_AD_LOCATION_ALL loc2, IGS_EN_DCNT_REASONCD_ALL dr, IGS_AS_GRD_SCHEMA gs, IGS_EN_METHOD_TYPE em, HZ_PARTIES hp2, HZ_PARTIES hp3, IGS_PS_RSV_EXT rse, IGS_PE_HZ_PARTIES IHP2 WHERE sua.PERSON_ID = hp1.PARTY_ID AND sua.PERSON_ID = sca.PERSON_ID AND sua.COURSE_CD = sca.COURSE_CD AND sca.COURSE_CD = crv.COURSE_CD AND sca.VERSION_NUMBER = crv.VERSION_NUMBER AND sua.UNIT_CD = uv.UNIT_CD AND sua.VERSION_NUMBER = uv.VERSION_NUMBER AND sua.CAL_TYPE = ca.CAL_TYPE AND sua.CI_SEQUENCE_NUMBER = ca.SEQUENCE_NUMBER AND sua.LOCATION_CD = loc1.LOCATION_CD AND sua.UNIT_CLASS = ucl.UNIT_CLASS AND sua.ADMINISTRATIVE_UNIT_STATUS = aus.ADMINISTRATIVE_UNIT_STATUS(+) AND sua.SUP_UNIT_CD = uv1.UNIT_CD(+) AND sua.SUP_VERSION_NUMBER = uv1.VERSION_NUMBER(+) AND sua.EXAM_LOCATION_CD = loc2.LOCATION_CD(+) AND sua.DCNT_REASON_CD = dr.DISCONTINUATION_REASON_CD(+) AND sua.GRADING_SCHEMA_CODE = gs.GRADING_SCHEMA_CD(+) AND sua.GS_VERSION_NUMBER = gs.VERSION_NUMBER(+) AND sua.ENR_METHOD_TYPE = em.ENR_METHOD_TYPE(+) AND IHP2.PARTY_ID = HP2.PARTY_ID (+) AND sua.ORG_UNIT_CD = IHP2.OSS_ORG_UNIT_CD(+) AND sua.RULE_WAIVED_PERSON_ID = hp3.PARTY_ID(+) AND sua.RSV_SEAT_EXT_ID = rse.RSV_EXT_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, SUA.ALTERNATIVE_TITLE
, SUA.OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU
, SUA.OVERRIDE_ACHIEVABLE_CP
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.OVERRIDE_CREDIT_REASON
, SUA.ADMINISTRATIVE_PRIORITY
, SUA.WAITLIST_DT
, SUA.DCNT_REASON_CD
, SUA.GRADING_SCHEMA_CODE
, SUA.GS_VERSION_NUMBER
, SUA.ENR_METHOD_TYPE
, SUA.FAILED_UNIT_RULE
, SUA.CART
, SUA.ORG_UNIT_CD
, SUA.SUBTITLE
, SUA.STUDENT_CAREER_TRANSCRIPT
, SUA.STUDENT_CAREER_STATISTICS
, HP1.PARTY_NUMBER
, CRV.TITLE
, UV.TITLE
, CA.DESCRIPTION
, LOC1.DESCRIPTION
, UCL.DESCRIPTION
, '_LA:SUA.UNIT_ATTEMPT_STATUS:IGS_LOOKUP_VALUES:UNIT_ATTEMPT_STATUS:MEANING'
, AUS.DESCRIPTION
, UV1.TITLE
, LOC2.DESCRIPTION
, DR.DESCRIPTION
, GS.DESCRIPTION
, EM.DESCRIPTION
, SUA.CORE_INDICATOR_CODE
, HP2.PARTY_NAME
, HP3.PARTY_NUMBER
, RSE.PRIORITY_ID
, RSE.PREFERENCE_ID
, RSE.RSV_LEVEL
, SUA.RULE_WAIVED_PERSON_ID
, SUA.UOO_ID
, SUA.DEG_AUD_DETAIL_ID
, SUA.RSV_SEAT_EXT_ID
, SUA.SESSION_ID
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
FROM IGS_EN_SU_ATTEMPT_ALL SUA
, HZ_PARTIES HP1
, IGS_EN_STDNT_PS_ATT_ALL SCA
, IGS_PS_VER_ALL CRV
, IGS_PS_UNIT_VER_ALL UV
, IGS_CA_INST_ALL CA
, IGS_AD_LOCATION_ALL LOC1
, IGS_AS_UNIT_CLASS_ALL UCL
, IGS_AD_ADM_UNIT_STAT_ALL AUS
, IGS_PS_UNIT_VER_ALL UV1
, IGS_AD_LOCATION_ALL LOC2
, IGS_EN_DCNT_REASONCD_ALL DR
, IGS_AS_GRD_SCHEMA GS
, IGS_EN_METHOD_TYPE EM
, HZ_PARTIES HP2
, HZ_PARTIES HP3
, IGS_PS_RSV_EXT RSE
, IGS_PE_HZ_PARTIES IHP2
WHERE SUA.PERSON_ID = HP1.PARTY_ID
AND SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SCA.COURSE_CD = CRV.COURSE_CD
AND SCA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SUA.CAL_TYPE = CA.CAL_TYPE
AND SUA.CI_SEQUENCE_NUMBER = CA.SEQUENCE_NUMBER
AND SUA.LOCATION_CD = LOC1.LOCATION_CD
AND SUA.UNIT_CLASS = UCL.UNIT_CLASS
AND SUA.ADMINISTRATIVE_UNIT_STATUS = AUS.ADMINISTRATIVE_UNIT_STATUS(+)
AND SUA.SUP_UNIT_CD = UV1.UNIT_CD(+)
AND SUA.SUP_VERSION_NUMBER = UV1.VERSION_NUMBER(+)
AND SUA.EXAM_LOCATION_CD = LOC2.LOCATION_CD(+)
AND SUA.DCNT_REASON_CD = DR.DISCONTINUATION_REASON_CD(+)
AND SUA.GRADING_SCHEMA_CODE = GS.GRADING_SCHEMA_CD(+)
AND SUA.GS_VERSION_NUMBER = GS.VERSION_NUMBER(+)
AND SUA.ENR_METHOD_TYPE = EM.ENR_METHOD_TYPE(+)
AND IHP2.PARTY_ID = HP2.PARTY_ID (+)
AND SUA.ORG_UNIT_CD = IHP2.OSS_ORG_UNIT_CD(+)
AND SUA.RULE_WAIVED_PERSON_ID = HP3.PARTY_ID(+)
AND SUA.RSV_SEAT_EXT_ID = RSE.RSV_EXT_ID (+) WITH READ ONLY