VIEW: APPS.IGS_EN_SUA_YEAR_V

Source

View Text - Preformatted

SELECT SCA.PERSON_ID, SCA.COURSE_CD, SCA.CAL_TYPE , SUSA.UNIT_SET_CD, SUSA.US_VERSION_NUMBER, US.TITLE,SUSA.SELECTION_DT, SUSA.RQRMNTS_COMPLETE_DT, SUSA.SEQUENCE_NUMBER, US.UNIT_SET_CAT, SUA.UNIT_CD, SUA.VERSION_NUMBER, UV.TITLE,SUA.CAL_TYPE, SUA.CI_SEQUENCE_NUMBER, SUA.CI_START_DT, SUA.LOCATION_CD, SUA.UNIT_CLASS, SUA.UNIT_ATTEMPT_STATUS, LKUPV.MEANING, igs_en_plan_utils.get_sua_fin_mark(SUA.PERSON_ID,SUA.COURSE_CD,SUA.UOO_ID), igs_en_plan_utils.get_sua_fin_grade(SUA.PERSON_ID,SUA.COURSE_CD,SUA.UOO_ID), IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER)|| '/' || NVL(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER), SUA.CAL_TYPE), SUA.CREATED_BY, SUA.CREATION_DATE, SUA.LAST_UPDATED_BY, SUA.LAST_UPDATE_DATE, SUA.LAST_UPDATE_LOGIN, CAI.DESCRIPTION, SUA.UOO_ID UOO_ID, SUA.CORE_INDICATOR_CODE FROM IGS_EN_STDNT_PS_ATT SCA, IGS_AS_SU_SETATMPT SUSA, IGS_EN_UNIT_SET US, IGS_EN_UNIT_SET_CAT USC, IGS_EN_SU_ATTEMPT SUA, IGS_PS_UNIT_VER UV, IGS_LOOKUPS_VIEW LKUPV, IGS_CA_INST CAI WHERE SUA.PERSON_ID = SCA.PERSON_ID AND SUA.COURSE_CD = SCA.COURSE_CD AND SCA.PERSON_ID = SUSA.PERSON_ID AND SCA.COURSE_CD = SUSA.COURSE_CD AND ( IGS_EN_GEN_015.GET_EFFECTIVE_CENSUS_DATE(Null,Null,SUA.CAL_TYPE,SUA.CI_SEQUENCE_NUMBER) BETWEEN SUSA.SELECTION_DT AND NVL(SUSA.RQRMNTS_COMPLETE_DT, NVL(SUSA.END_DT,TO_DATE('31/12/4000','DD/MM/RRRR')) )) AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT AND USC.S_UNIT_SET_CAT = 'PRENRL_YR' AND SUA.UNIT_CD = UV.UNIT_CD AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER AND SUA.UNIT_ATTEMPT_STATUS = LKUPV.LOOKUP_CODE AND LKUPV.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS' AND CAI.CAL_TYPE =SUA.CAL_TYPE AND CAI.SEQUENCE_NUMBER =SUA.CI_SEQUENCE_NUMBER

View Text - HTML Formatted

SELECT SCA.PERSON_ID
, SCA.COURSE_CD
, SCA.CAL_TYPE
, SUSA.UNIT_SET_CD
, SUSA.US_VERSION_NUMBER
, US.TITLE
, SUSA.SELECTION_DT
, SUSA.RQRMNTS_COMPLETE_DT
, SUSA.SEQUENCE_NUMBER
, US.UNIT_SET_CAT
, SUA.UNIT_CD
, SUA.VERSION_NUMBER
, UV.TITLE
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER
, SUA.CI_START_DT
, SUA.LOCATION_CD
, SUA.UNIT_CLASS
, SUA.UNIT_ATTEMPT_STATUS
, LKUPV.MEANING
, IGS_EN_PLAN_UTILS.GET_SUA_FIN_MARK(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UOO_ID)
, IGS_EN_PLAN_UTILS.GET_SUA_FIN_GRADE(SUA.PERSON_ID
, SUA.COURSE_CD
, SUA.UOO_ID)
, IGS_EN_GEN_014.ENRS_GET_ACAD_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)|| '/' || NVL(IGS_CA_GEN_001.CALP_GET_ALT_CD(SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER)
, SUA.CAL_TYPE)
, SUA.CREATED_BY
, SUA.CREATION_DATE
, SUA.LAST_UPDATED_BY
, SUA.LAST_UPDATE_DATE
, SUA.LAST_UPDATE_LOGIN
, CAI.DESCRIPTION
, SUA.UOO_ID UOO_ID
, SUA.CORE_INDICATOR_CODE
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_AS_SU_SETATMPT SUSA
, IGS_EN_UNIT_SET US
, IGS_EN_UNIT_SET_CAT USC
, IGS_EN_SU_ATTEMPT SUA
, IGS_PS_UNIT_VER UV
, IGS_LOOKUPS_VIEW LKUPV
, IGS_CA_INST CAI
WHERE SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND SCA.PERSON_ID = SUSA.PERSON_ID
AND SCA.COURSE_CD = SUSA.COURSE_CD
AND ( IGS_EN_GEN_015.GET_EFFECTIVE_CENSUS_DATE(NULL
, NULL
, SUA.CAL_TYPE
, SUA.CI_SEQUENCE_NUMBER) BETWEEN SUSA.SELECTION_DT
AND NVL(SUSA.RQRMNTS_COMPLETE_DT
, NVL(SUSA.END_DT
, TO_DATE('31/12/4000'
, 'DD/MM/RRRR')) ))
AND SUSA.UNIT_SET_CD = US.UNIT_SET_CD
AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
AND USC.S_UNIT_SET_CAT = 'PRENRL_YR'
AND SUA.UNIT_CD = UV.UNIT_CD
AND SUA.VERSION_NUMBER = UV.VERSION_NUMBER
AND SUA.UNIT_ATTEMPT_STATUS = LKUPV.LOOKUP_CODE
AND LKUPV.LOOKUP_TYPE = 'UNIT_ATTEMPT_STATUS'
AND CAI.CAL_TYPE =SUA.CAL_TYPE
AND CAI.SEQUENCE_NUMBER =SUA.CI_SEQUENCE_NUMBER