VIEW: APPS.IGSFV_PGM_OFR_PAT_ADM_DT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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