VIEW: APPS.IGSFV_PGM_OFR_ADM_PAT_RESTRCTN

Source

View Text - Preformatted

SELECT ci.DESCRIPTION, ppr.ADM_CAL_TYPE, ppr.ADM_CI_SEQUENCE_NUMBER, ppr.ADMISSION_CAT, ac.DESCRIPTION, '_LA: ppr.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING', ppr.COURSE_CD, psv.TITLE, ppr.VERSION_NUMBER, ppr.ACAD_CAL_TYPE, ppr.SEQUENCE_NUMBER, ppr.LOCATION_CD, l.DESCRIPTION, ppr.ATTENDANCE_MODE, atm.DESCRIPTION, ppr.ATTENDANCE_TYPE, att.DESCRIPTION, '_LA:ppr.ROLLOVER_INCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', ppr.CREATED_BY, ppr.CREATION_DATE, ppr.LAST_UPDATED_BY, ppr.LAST_UPDATE_DATE FROM IGS_AD_PRD_PS_OF_OPT ppr, IGS_PS_VER_ALL psv, IGS_CA_INST_ALL ci, IGS_AD_CAT_ALL ac, IGS_AD_LOCATION_ALL l, IGS_EN_ATD_MODE_ALL atm, IGS_EN_ATD_TYPE_ALL att WHERE ppr.ADM_CAL_TYPE = ci.CAL_TYPE AND ppr.ADM_CI_SEQUENCE_NUMBER = ci.SEQUENCE_NUMBER AND ppr.COURSE_CD = psv.COURSE_CD AND ppr.VERSION_NUMBER = psv.VERSION_NUMBER AND ppr.ADMISSION_CAT = ac.ADMISSION_CAT AND ppr.LOCATION_CD = l.LOCATION_CD(+) AND ppr.ATTENDANCE_MODE = atm.ATTENDANCE_MODE(+) AND ppr.ATTENDANCE_TYPE = att.ATTENDANCE_TYPE(+) WITH READ ONLY

View Text - HTML Formatted

SELECT CI.DESCRIPTION
, PPR.ADM_CAL_TYPE
, PPR.ADM_CI_SEQUENCE_NUMBER
, PPR.ADMISSION_CAT
, AC.DESCRIPTION
, '_LA: PPR.S_ADMISSION_PROCESS_TYPE:IGS_LOOKUP_VALUES:ADMISSION_PROCESS_TYPE:MEANING'
, PPR.COURSE_CD
, PSV.TITLE
, PPR.VERSION_NUMBER
, PPR.ACAD_CAL_TYPE
, PPR.SEQUENCE_NUMBER
, PPR.LOCATION_CD
, L.DESCRIPTION
, PPR.ATTENDANCE_MODE
, ATM.DESCRIPTION
, PPR.ATTENDANCE_TYPE
, ATT.DESCRIPTION
, '_LA:PPR.ROLLOVER_INCLUSION_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, PPR.CREATED_BY
, PPR.CREATION_DATE
, PPR.LAST_UPDATED_BY
, PPR.LAST_UPDATE_DATE
FROM IGS_AD_PRD_PS_OF_OPT PPR
, IGS_PS_VER_ALL PSV
, IGS_CA_INST_ALL CI
, IGS_AD_CAT_ALL AC
, IGS_AD_LOCATION_ALL L
, IGS_EN_ATD_MODE_ALL ATM
, IGS_EN_ATD_TYPE_ALL ATT
WHERE PPR.ADM_CAL_TYPE = CI.CAL_TYPE
AND PPR.ADM_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND PPR.COURSE_CD = PSV.COURSE_CD
AND PPR.VERSION_NUMBER = PSV.VERSION_NUMBER
AND PPR.ADMISSION_CAT = AC.ADMISSION_CAT
AND PPR.LOCATION_CD = L.LOCATION_CD(+)
AND PPR.ATTENDANCE_MODE = ATM.ATTENDANCE_MODE(+)
AND PPR.ATTENDANCE_TYPE = ATT.ATTENDANCE_TYPE(+) WITH READ ONLY