VIEW: APPS.IGS_UC_APP_CHOICE_DETS_V

Source

View Text - Preformatted

SELECT appch.ROWID , appch.APP_CHOICE_ID, appch.APP_ID, appch.APP_NO, appch.CHOICE_NO, appch.SYSTEM_CODE, appch.UCAS_CYCLE, pe.PERSON_NUMBER, pe.FULL_NAME, pe.LAST_NAME , app.OSS_PERSON_ID, app.APPLICATION_DATE, app.SENT_TO_OSS, appch.LAST_CHANGE, appch.INSTITUTE_CODE, appch.UCAS_PROGRAM_CODE, appch.CAMPUS, appch.OSS_PROGRAM_CODE, appch.OSS_PROGRAM_VERSION, appch.OSS_ATTENDANCE_TYPE, appch.OSS_ATTENDANCE_MODE, appch.OSS_LOCATION, appch.ENTRY_YEAR, appch.ENTRY_MONTH, appch.POINT_OF_ENTRY, appch.DECISION, appch.REPLY, appch.EXPORT_TO_OSS_STATUS , appch.CREATED_BY, appch.CREATION_DATE, appch.LAST_UPDATED_BY, appch.LAST_UPDATE_DATE, appch.LAST_UPDATE_LOGIN FROM IGS_UC_APP_CHOICES appch, IGS_UC_APPLICANTS app, IGS_PE_PERSON_BASE_V pe WHERE appch.app_id = app.app_id AND app.oss_person_id = pe.person_id (+)

View Text - HTML Formatted

SELECT APPCH.ROWID
, APPCH.APP_CHOICE_ID
, APPCH.APP_ID
, APPCH.APP_NO
, APPCH.CHOICE_NO
, APPCH.SYSTEM_CODE
, APPCH.UCAS_CYCLE
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.LAST_NAME
, APP.OSS_PERSON_ID
, APP.APPLICATION_DATE
, APP.SENT_TO_OSS
, APPCH.LAST_CHANGE
, APPCH.INSTITUTE_CODE
, APPCH.UCAS_PROGRAM_CODE
, APPCH.CAMPUS
, APPCH.OSS_PROGRAM_CODE
, APPCH.OSS_PROGRAM_VERSION
, APPCH.OSS_ATTENDANCE_TYPE
, APPCH.OSS_ATTENDANCE_MODE
, APPCH.OSS_LOCATION
, APPCH.ENTRY_YEAR
, APPCH.ENTRY_MONTH
, APPCH.POINT_OF_ENTRY
, APPCH.DECISION
, APPCH.REPLY
, APPCH.EXPORT_TO_OSS_STATUS
, APPCH.CREATED_BY
, APPCH.CREATION_DATE
, APPCH.LAST_UPDATED_BY
, APPCH.LAST_UPDATE_DATE
, APPCH.LAST_UPDATE_LOGIN
FROM IGS_UC_APP_CHOICES APPCH
, IGS_UC_APPLICANTS APP
, IGS_PE_PERSON_BASE_V PE
WHERE APPCH.APP_ID = APP.APP_ID
AND APP.OSS_PERSON_ID = PE.PERSON_ID (+)