VIEW: APPS.IGSFV_PGM_OFR_PAT_ADM_PERD

Source

View Text - Preformatted

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

View Text - HTML Formatted

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