VIEW: APPS.IGSFV_UC_COURSE_VAC_OPTIONS

Source

View Text - Preformatted

SELECT CR.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE, CR.INSTITUTE UCAS_INSTITUTE_CODE, CR.UCAS_CAMPUS UCAS_CAMPUS_CODE, CR.SYSTEM_CODE UCAS_SYSTEM_CODE, CR.OPTION_CODE OPTION_CODE, CR.CL_UPDATED CLEARING_UPDATED, CR.CL_DATE CLEARING_UPDATED_DATE, CR.VACANCY_STATUS VACANCY_STATUS, '_LA:CR.VACANCY_STATUS:IGS_LOOKUP_VALUES:IGS_UC_VAC_STATUS:MEANING' "_LA:VACANCY_STATUS_DESC", CR.SENT_TO_UCAS SENT_TO_UCAS, FT1.SHORT_TITLE UCAS_COURSE_SHORT_TITLE, FT1.LONG_TITLE UCAS_COURSE_LONG_TITLE, FT1.OSS_PROGRAM_CODE OSS_PROGRAM_CODE, FT1.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION, FT1.OSS_LOCATION OSS_LOCATION_CODE, FT1.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE, FT1.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE, FT1.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG, FT2.NAME UCAS_SYSTEM_NAME, FT2.DESCRIPTION UCAS_SYSTEM_DESCRIPTION, FT3.INST_CODE UCAS_INSTITUTION_ABBREVIATION, FT3.INST_NAME UCAS_INSTITUTION_NAME, FT4.TITLE OSS_PROGRAM_TITLE, FT4.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE, FT5.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC, FT6.DESCRIPTION OSS_ATTENDANCE_MODE_DESC, CR.UPDATER UPDATER_IDENTIFIER, CR.CREATED_BY CREATED_BY, CR.CREATION_DATE CREATION_DATE, CR.LAST_UPDATED_BY LAST_UPDATED_BY, CR.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_CRSE_VAC_OPS CR, IGS_UC_CRSE_DETS FT1, IGS_UC_DEFAULTS FT2, IGS_UC_COM_INST FT3, IGS_PS_VER_ALL FT4, IGS_EN_ATD_TYPE_ALL FT5, IGS_EN_ATD_MODE_ALL FT6 WHERE CR.UCAS_PROGRAM_CODE = FT1.UCAS_PROGRAM_CODE AND CR.INSTITUTE = FT1.INSTITUTE AND CR.UCAS_CAMPUS = FT1.UCAS_CAMPUS AND CR.SYSTEM_CODE = FT1.SYSTEM_CODE AND CR.SYSTEM_CODE = FT2.SYSTEM_CODE AND CR.INSTITUTE = FT3.INST AND FT1.OSS_PROGRAM_CODE = FT4.COURSE_CD(+) AND FT1.OSS_PROGRAM_VERSION = FT4.VERSION_NUMBER(+) AND FT1.OSS_ATTENDANCE_TYPE = FT5.ATTENDANCE_TYPE(+) AND FT1.OSS_ATTENDANCE_MODE = FT6.ATTENDANCE_MODE(+) WITH READ ONLY

View Text - HTML Formatted

SELECT CR.UCAS_PROGRAM_CODE UCAS_PROGRAM_CODE
, CR.INSTITUTE UCAS_INSTITUTE_CODE
, CR.UCAS_CAMPUS UCAS_CAMPUS_CODE
, CR.SYSTEM_CODE UCAS_SYSTEM_CODE
, CR.OPTION_CODE OPTION_CODE
, CR.CL_UPDATED CLEARING_UPDATED
, CR.CL_DATE CLEARING_UPDATED_DATE
, CR.VACANCY_STATUS VACANCY_STATUS
, '_LA:CR.VACANCY_STATUS:IGS_LOOKUP_VALUES:IGS_UC_VAC_STATUS:MEANING' "_LA:VACANCY_STATUS_DESC"
, CR.SENT_TO_UCAS SENT_TO_UCAS
, FT1.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, FT1.LONG_TITLE UCAS_COURSE_LONG_TITLE
, FT1.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, FT1.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, FT1.OSS_LOCATION OSS_LOCATION_CODE
, FT1.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, FT1.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, FT1.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG
, FT2.NAME UCAS_SYSTEM_NAME
, FT2.DESCRIPTION UCAS_SYSTEM_DESCRIPTION
, FT3.INST_CODE UCAS_INSTITUTION_ABBREVIATION
, FT3.INST_NAME UCAS_INSTITUTION_NAME
, FT4.TITLE OSS_PROGRAM_TITLE
, FT4.SHORT_TITLE OSS_PROGRAM_SHORT_TITLE
, FT5.DESCRIPTION OSS_ATTENDANCE_TYPE_DESC
, FT6.DESCRIPTION OSS_ATTENDANCE_MODE_DESC
, CR.UPDATER UPDATER_IDENTIFIER
, CR.CREATED_BY CREATED_BY
, CR.CREATION_DATE CREATION_DATE
, CR.LAST_UPDATED_BY LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_CRSE_VAC_OPS CR
, IGS_UC_CRSE_DETS FT1
, IGS_UC_DEFAULTS FT2
, IGS_UC_COM_INST FT3
, IGS_PS_VER_ALL FT4
, IGS_EN_ATD_TYPE_ALL FT5
, IGS_EN_ATD_MODE_ALL FT6
WHERE CR.UCAS_PROGRAM_CODE = FT1.UCAS_PROGRAM_CODE
AND CR.INSTITUTE = FT1.INSTITUTE
AND CR.UCAS_CAMPUS = FT1.UCAS_CAMPUS
AND CR.SYSTEM_CODE = FT1.SYSTEM_CODE
AND CR.SYSTEM_CODE = FT2.SYSTEM_CODE
AND CR.INSTITUTE = FT3.INST
AND FT1.OSS_PROGRAM_CODE = FT4.COURSE_CD(+)
AND FT1.OSS_PROGRAM_VERSION = FT4.VERSION_NUMBER(+)
AND FT1.OSS_ATTENDANCE_TYPE = FT5.ATTENDANCE_TYPE(+)
AND FT1.OSS_ATTENDANCE_MODE = FT6.ATTENDANCE_MODE(+) WITH READ ONLY