VIEW: APPS.IGSBV_UC_COURSE_DETAILS

Source

View Text - Preformatted

SELECT CR.UCAS_PROGRAM_CODE UCAS_COURSE_CODE, CR.OSS_PROGRAM_CODE OSS_PROGRAM_CODE, CR.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION, CR.INSTITUTE UCAS_INSTITUTE_CODE, CR.UVCOURSE_UPDATER UCAS_UVCOURSE_UPDATER, CR.UVCRSEVAC_UPDATER UCAS_UVCOURSEVACANCY_UPDATER, CR.SHORT_TITLE UCAS_COURSE_SHORT_TITLE, CR.LONG_TITLE UCAS_COURSE_LONG_TITLE, CR.UCAS_CAMPUS UCAS_CAMPUS, CR.OSS_LOCATION OSS_LOCATION, CR.FACULTY UCAS_FACULTY, CR.TOTAL_NO_OF_SEATS TOTAL_NUMBER_OF_SEATS, CR.MIN_ENTRY_POINTS MIN_ENTRY_POINTS, CR.MAX_ENTRY_POINTS MAX_ENTRY_POINTS, CR.CURRENT_VALIDITY CURRENT_VALIDITY, CR.DEFERRED_VALIDITY DEFERRED_VALIDITY, CR.TERM_1_START TERM_1_START_DATE, CR.TERM_1_END TERM_1_END_DATE, CR.TERM_2_START TERM_2_START_DATE, CR.TERM_2_END TERM_2_END_DATE, CR.TERM_3_START TERM_3_START_DATE, CR.TERM_3_END TERM_3_END_DATE, CR.TERM_4_START TERM_4_START_DATE, CR.TERM_4_END TERM_4_END_DATE, CR.CL_UPDATED CLEARING_UPDATED_FLAG, CR.CL_DATE CLEARING_UPDATED_DATE, CR.VACANCY_STATUS VACANCY_STATUS, CR.NO_OF_VACANCY NUMBER_OF_VACANCIES, CR.SCORE SCORE, CR.RB_FULL ROUTE_B_FULL, CR.SCOT_VAC SCOTTISH_VACANCY, CR.SENT_TO_UCAS SENT_TO_UCAS_FLAG, CR.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE, CR.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE, CR.JOINT_ADMISSION_IND JOINT_ADMISSION_INDICATOR, CR.OPEN_EXTRA_IND OPEN_EXTRA_INDICATOR, CR.SYSTEM_CODE UCAS_SYSTEM_CODE, CR.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG, CR.IMPORTED IMPORTED_FLAG, CR.KEYWRDS_CHANGED KEYWORDS_CHANGED_FLAG, 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_DETS CR WITH READ ONLY

View Text - HTML Formatted

SELECT CR.UCAS_PROGRAM_CODE UCAS_COURSE_CODE
, CR.OSS_PROGRAM_CODE OSS_PROGRAM_CODE
, CR.OSS_PROGRAM_VERSION OSS_PROGRAM_VERSION
, CR.INSTITUTE UCAS_INSTITUTE_CODE
, CR.UVCOURSE_UPDATER UCAS_UVCOURSE_UPDATER
, CR.UVCRSEVAC_UPDATER UCAS_UVCOURSEVACANCY_UPDATER
, CR.SHORT_TITLE UCAS_COURSE_SHORT_TITLE
, CR.LONG_TITLE UCAS_COURSE_LONG_TITLE
, CR.UCAS_CAMPUS UCAS_CAMPUS
, CR.OSS_LOCATION OSS_LOCATION
, CR.FACULTY UCAS_FACULTY
, CR.TOTAL_NO_OF_SEATS TOTAL_NUMBER_OF_SEATS
, CR.MIN_ENTRY_POINTS MIN_ENTRY_POINTS
, CR.MAX_ENTRY_POINTS MAX_ENTRY_POINTS
, CR.CURRENT_VALIDITY CURRENT_VALIDITY
, CR.DEFERRED_VALIDITY DEFERRED_VALIDITY
, CR.TERM_1_START TERM_1_START_DATE
, CR.TERM_1_END TERM_1_END_DATE
, CR.TERM_2_START TERM_2_START_DATE
, CR.TERM_2_END TERM_2_END_DATE
, CR.TERM_3_START TERM_3_START_DATE
, CR.TERM_3_END TERM_3_END_DATE
, CR.TERM_4_START TERM_4_START_DATE
, CR.TERM_4_END TERM_4_END_DATE
, CR.CL_UPDATED CLEARING_UPDATED_FLAG
, CR.CL_DATE CLEARING_UPDATED_DATE
, CR.VACANCY_STATUS VACANCY_STATUS
, CR.NO_OF_VACANCY NUMBER_OF_VACANCIES
, CR.SCORE SCORE
, CR.RB_FULL ROUTE_B_FULL
, CR.SCOT_VAC SCOTTISH_VACANCY
, CR.SENT_TO_UCAS SENT_TO_UCAS_FLAG
, CR.OSS_ATTENDANCE_TYPE OSS_ATTENDANCE_TYPE
, CR.OSS_ATTENDANCE_MODE OSS_ATTENDANCE_MODE
, CR.JOINT_ADMISSION_IND JOINT_ADMISSION_INDICATOR
, CR.OPEN_EXTRA_IND OPEN_EXTRA_INDICATOR
, CR.SYSTEM_CODE UCAS_SYSTEM_CODE
, CR.CLEARING_OPTIONS CLEARING_OPTIONS_FLAG
, CR.IMPORTED IMPORTED_FLAG
, CR.KEYWRDS_CHANGED KEYWORDS_CHANGED_FLAG
, 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_DETS CR WITH READ ONLY