VIEW: APPS.IGSBV_UC_APPLICANT_REFEREES

Source

View Text - Preformatted

SELECT AP.APP_NO UCAS_APPLICANT_NUMBER, AP.REFEREE_NAME REFEREE_NAME, AP.REFEREE_POST REFEREE_POST, AP.ESTAB_NAME ESTABLISHMENT_NAME, AP.ADDRESS1 ADDRESS1, AP.ADDRESS2 ADDRESS2, AP.ADDRESS3 ADDRESS3, AP.ADDRESS4 ADDRESS4, AP.TELEPHONE TELEPHONE, AP.FAX FAX, AP.EMAIL EMAIL, AP.STATEMENT STATEMENT, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER, AP.PREDICTED_GRADES PREDICTED_GRADES, AP.CREATED_BY CREATED_BY, AP.CREATION_DATE CREATION_DATE, AP.LAST_UPDATED_BY LAST_UPDATED_BY, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_APP_REFEREES AP, IGS_UC_APPLICANTS FT1 WHERE AP.APP_NO = FT1.APP_NO WITH READ ONLY

View Text - HTML Formatted

SELECT AP.APP_NO UCAS_APPLICANT_NUMBER
, AP.REFEREE_NAME REFEREE_NAME
, AP.REFEREE_POST REFEREE_POST
, AP.ESTAB_NAME ESTABLISHMENT_NAME
, AP.ADDRESS1 ADDRESS1
, AP.ADDRESS2 ADDRESS2
, AP.ADDRESS3 ADDRESS3
, AP.ADDRESS4 ADDRESS4
, AP.TELEPHONE TELEPHONE
, AP.FAX FAX
, AP.EMAIL EMAIL
, AP.STATEMENT STATEMENT
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, AP.PREDICTED_GRADES PREDICTED_GRADES
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_APP_REFEREES AP
, IGS_UC_APPLICANTS FT1
WHERE AP.APP_NO = FT1.APP_NO WITH READ ONLY