VIEW: APPS.IGSBV_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, 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 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 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
, 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
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 WITH READ ONLY