VIEW: APPS.IGS_PR_SDT_PROG_PRD_V

Source

View Text - Preformatted

SELECT SCA.ROWID,SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER , CI.ALTERNATE_CODE , CAT.DESCRIPTION, ACAD_CI.ALTERNATE_CODE, ACAD_CI.ALTERNATE_CODE || '/' || CI.ALTERNATE_CODE , CI.START_DT, CI.END_DT, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER, 'COURSE-GPA') GPA_COURSE, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER, 'PERIOD-GPA') GPA_PERIOD, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER, 'COURSE-WAM') WAM_COURSE, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID, SCA.COURSE_CD, CI.CAL_TYPE, CI.SEQUENCE_NUMBER, 'PERIOD-WAM') WAM_PERIOD, SCA.CREATED_BY, SCA.CREATION_DATE, SCA.LAST_UPDATED_BY, SCA.LAST_UPDATE_DATE, SCA.LAST_UPDATE_LOGIN FROM IGS_EN_STDNT_PS_ATT sca, IGS_CA_INST ci, IGS_CA_INST acad_ci, IGS_CA_INST_REL acad_cir, IGS_CA_TYPE acad_cat, IGS_CA_TYPE cat, IGS_CA_STAT cs WHERE CAT.S_CAL_CAT = 'PROGRESS' AND CI.CAL_TYPE = CAT.CAL_TYPE AND CI.CAL_STATUS = CS.CAL_STATUS AND CS.S_CAL_STATUS <> 'PLANNED' AND ACAD_CIR.SUB_CAL_TYPE = CI.CAL_TYPE AND ACAD_CIR.SUB_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND ACAD_CIR.SUP_CAL_TYPE = ACAD_CAT.CAL_TYPE AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC' AND ACAD_CI.CAL_TYPE = ACAD_CIR.SUP_CAL_TYPE AND ACAD_CI.SEQUENCE_NUMBER = ACAD_CIR.SUP_CI_SEQUENCE_NUMBER AND (EXISTS (SELECT 'X' FROM IGS_EN_SU_ATTEMPT SUA, IGS_CA_INST_REL CIR WHERE SUA.PERSON_ID = SCA.PERSON_ID AND SUA.COURSE_CD = SCA.COURSE_CD AND CIR.SUP_CAL_TYPE = CI.CAL_TYPE AND CIR.SUP_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND CIR.SUB_CAL_TYPE = SUA.CAL_TYPE AND CIR.SUB_CI_SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER) OR EXISTS (SELECT 'X' FROM IGS_AS_SC_ATMPT_ENR SCAE, IGS_CA_INST_REL ENR_CIR WHERE SCAE.PERSON_ID = SCA.PERSON_ID AND SCAE.COURSE_CD = SCA.COURSE_CD AND SCAE.CAL_TYPE = ENR_CIR.SUB_CAL_TYPE AND SCAE.CI_SEQUENCE_NUMBER = ENR_CIR.SUB_CI_SEQUENCE_NUMBER AND ACAD_CI.CAL_TYPE = ENR_CIR.SUP_CAL_TYPE AND ACAD_CI.SEQUENCE_NUMBER = ENR_CIR.SUP_CI_SEQUENCE_NUMBER AND CI.END_DT > SYSDATE))

View Text - HTML Formatted

SELECT SCA.ROWID
, SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, CAT.DESCRIPTION
, ACAD_CI.ALTERNATE_CODE
, ACAD_CI.ALTERNATE_CODE || '/' || CI.ALTERNATE_CODE
, CI.START_DT
, CI.END_DT
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'COURSE-GPA') GPA_COURSE
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'PERIOD-GPA') GPA_PERIOD
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'COURSE-WAM') WAM_COURSE
, IGS_PR_GEN_005.IGS_PR_GET_SCPM_VALUE(SCA.PERSON_ID
, SCA.COURSE_CD
, CI.CAL_TYPE
, CI.SEQUENCE_NUMBER
, 'PERIOD-WAM') WAM_PERIOD
, SCA.CREATED_BY
, SCA.CREATION_DATE
, SCA.LAST_UPDATED_BY
, SCA.LAST_UPDATE_DATE
, SCA.LAST_UPDATE_LOGIN
FROM IGS_EN_STDNT_PS_ATT SCA
, IGS_CA_INST CI
, IGS_CA_INST ACAD_CI
, IGS_CA_INST_REL ACAD_CIR
, IGS_CA_TYPE ACAD_CAT
, IGS_CA_TYPE CAT
, IGS_CA_STAT CS
WHERE CAT.S_CAL_CAT = 'PROGRESS'
AND CI.CAL_TYPE = CAT.CAL_TYPE
AND CI.CAL_STATUS = CS.CAL_STATUS
AND CS.S_CAL_STATUS <> 'PLANNED'
AND ACAD_CIR.SUB_CAL_TYPE = CI.CAL_TYPE
AND ACAD_CIR.SUB_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND ACAD_CIR.SUP_CAL_TYPE = ACAD_CAT.CAL_TYPE
AND ACAD_CAT.S_CAL_CAT = 'ACADEMIC'
AND ACAD_CI.CAL_TYPE = ACAD_CIR.SUP_CAL_TYPE
AND ACAD_CI.SEQUENCE_NUMBER = ACAD_CIR.SUP_CI_SEQUENCE_NUMBER
AND (EXISTS (SELECT 'X'
FROM IGS_EN_SU_ATTEMPT SUA
, IGS_CA_INST_REL CIR
WHERE SUA.PERSON_ID = SCA.PERSON_ID
AND SUA.COURSE_CD = SCA.COURSE_CD
AND CIR.SUP_CAL_TYPE = CI.CAL_TYPE
AND CIR.SUP_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND CIR.SUB_CAL_TYPE = SUA.CAL_TYPE
AND CIR.SUB_CI_SEQUENCE_NUMBER = SUA.CI_SEQUENCE_NUMBER) OR EXISTS (SELECT 'X'
FROM IGS_AS_SC_ATMPT_ENR SCAE
, IGS_CA_INST_REL ENR_CIR
WHERE SCAE.PERSON_ID = SCA.PERSON_ID
AND SCAE.COURSE_CD = SCA.COURSE_CD
AND SCAE.CAL_TYPE = ENR_CIR.SUB_CAL_TYPE
AND SCAE.CI_SEQUENCE_NUMBER = ENR_CIR.SUB_CI_SEQUENCE_NUMBER
AND ACAD_CI.CAL_TYPE = ENR_CIR.SUP_CAL_TYPE
AND ACAD_CI.SEQUENCE_NUMBER = ENR_CIR.SUP_CI_SEQUENCE_NUMBER
AND CI.END_DT > SYSDATE))