VIEW: APPS.IGS_AS_SUA_INQ_V

Source

View Text - Preformatted

SELECT SUA.PERSON_ID , SUA.COURSE_CD , SUA.UNIT_CD , SUA.VERSION_NUMBER , SUA.UNIT_CD || '.' || TO_CHAR(SUA.VERSION_NUMBER) , NVL(SUA.ALTERNATIVE_TITLE,UV.SHORT_TITLE) , SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER), 1,10)|| '/' || SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE, SUA.CI_SEQUENCE_NUMBER),1,10) , SUA.CAL_TYPE , SUA.CI_SEQUENCE_NUMBER , SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER), 1,10) , SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER),1,10) , SUA.LOCATION_CD , SUA.UNIT_CLASS , UC.UNIT_MODE , SUA.CI_START_DT , SUA.CI_END_DT , SUA.UOO_ID , SUA.ENROLLED_DT , SUA.UNIT_ATTEMPT_STATUS , SUA.ADMINISTRATIVE_UNIT_STATUS , SUA.DISCONTINUED_DT , SUA.RULE_WAIVED_DT , SUA.RULE_WAIVED_PERSON_ID , SUA.NO_ASSESSMENT_IND , SUA.SUP_UNIT_CD , SUA.SUP_VERSION_NUMBER , SUA.EXAM_LOCATION_CD , NVL(SUA.OVERRIDE_ENROLLED_CP, NVL(cps.ENROLLED_CREDIT_POINTS ,UV.ENROLLED_CREDIT_POINTS)) , NVL(SUA.OVERRIDE_EFTSU, IGS_EN_GEN_014.enrs_clc_sua_eftsut( SUA.PERSON_ID, SUA.COURSE_CD, SCA.VERSION_NUMBER, SUA.UNIT_CD, SUA.VERSION_NUMBER, SUA.CAL_TYPE, SUA.CI_SEQUENCE_NUMBER, SUA.UOO_ID, SUA.OVERRIDE_ENROLLED_CP, SUA.OVERRIDE_EFTSU, NULL)) , IGS_IN_GEN_001.INQP_GET_SUA_ACHVD(SUA.PERSON_ID,SUA.COURSE_CD,SUA.UNIT_CD, SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER,SUA.VERSION_NUMBER, SUA.CI_END_DT,SUA.UNIT_ATTEMPT_STATUS,SUA.OVERRIDE_ACHIEVABLE_CP, NULL, UV.REPEATABLE_IND, NVL(cps.ACHIEVABLE_CREDIT_POINTS,UV.ACHIEVABLE_CREDIT_POINTS), NVL(cps.ENROLLED_CREDIT_POINTS ,UV.ENROLLED_CREDIT_POINTS), SUA.UOO_ID) , SUA.OVERRIDE_OUTCOME_DUE_DT , SUA.created_by , SUA.creation_date , SUA.last_updated_by , SUA.last_update_date , SUA.last_update_login , SUA.OVERRIDE_CREDIT_REASON ,SUA.DEG_AUD_DETAIL_ID FROM IGS_EN_SU_ATTEMPT SUA, IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_USEC_CPS cps, IGS_EN_STDNT_PS_ATT SCA, IGS_PS_UNIT_VER_ALL UV, IGS_AS_UNIT_CLASS UC WHERE UV.UNIT_CD = SUA.UNIT_CD AND UV.VERSION_NUMBER = SUA.VERSION_NUMBER AND UC.UNIT_CLASS = SUA.UNIT_CLASS AND SCA.PERSON_ID = SUA.PERSON_ID AND SCA.COURSE_CD = SUA.COURSE_CD AND SUA.uoo_id = uoo.uoo_id AND uoo.uoo_id = cps.uoo_id(+)

View Text - HTML Formatted

SELECT SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.UNIT_CD || '.' || TO_CHAR(SUA.VERSION_NUMBER)
, NVL(SUA.ALTERNATIVE_TITLE
, UV.SHORT_TITLE)
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)|| '/' || SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUBSTR(IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUBSTR(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, 1
, 10)
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, UC.UNIT_MODE
, SUA.CI_START_DT
, SUA.CI_END_DT
, SUA.UOO_ID
, SUA.ENROLLED_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.ADMINISTRATIVE_UNIT_STATUS
, SUA.DISCONTINUED_DT
, SUA.RULE_WAIVED_DT
, SUA.RULE_WAIVED_PERSON_ID
, SUA.NO_ASSESSMENT_IND
, SUA.SUP_UNIT_CD
, SUA.SUP_VERSION_NUMBER
, SUA.EXAM_LOCATION_CD
, NVL(SUA.OVERRIDE_ENROLLED_CP
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS))
, NVL(SUA.OVERRIDE_EFTSU
, IGS_EN_GEN_014.ENRS_CLC_SUA_EFTSUT( SUA.PERSON_ID
, SUA.COURSE_CD
, SCA.VERSION_NUMBER
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.UOO_ID
, SUA.OVERRIDE_ENROLLED_CP
, SUA.OVERRIDE_EFTSU
, NULL))
, IGS_IN_GEN_001.INQP_GET_SUA_ACHVD(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UNIT_CD
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.VERSION_NUMBER
, SUA.CI_END_DT
, SUA.UNIT_ATTEMPT_STATUS
, SUA.OVERRIDE_ACHIEVABLE_CP
, NULL
, UV.REPEATABLE_IND
, NVL(CPS.ACHIEVABLE_CREDIT_POINTS
, UV.ACHIEVABLE_CREDIT_POINTS)
, NVL(CPS.ENROLLED_CREDIT_POINTS
, UV.ENROLLED_CREDIT_POINTS)
, SUA.UOO_ID)
, SUA.OVERRIDE_OUTCOME_DUE_DT
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, SUA.OVERRIDE_CREDIT_REASON
, SUA.DEG_AUD_DETAIL_ID
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_OFR_OPT UOO
, IGS_PS_USEC_CPS CPS
, IGS_EN_STDNT_PS_ATT SCA
, IGS_PS_UNIT_VER_ALL UV
, IGS_AS_UNIT_CLASS UC
WHERE UV.UNIT_CD = SUA.UNIT_CD
AND UV.VERSION_NUMBER = SUA.VERSION_NUMBER
AND UC.UNIT_CLASS = SUA.UNIT_CLASS
AND SCA.PERSON_ID = SUA.PERSON_ID
AND SCA.COURSE_CD = SUA.COURSE_CD
AND SUA.UOO_ID = UOO.UOO_ID
AND UOO.UOO_ID = CPS.UOO_ID(+)