VIEW: APPS.IGSBV_UC_ENQUIRY_DETAILS

Source

View Text - Preformatted

SELECT EN.APP_NO UCAS_APPLICANT_NUMBER, EN.SURNAME SURNAME, EN.GIVEN_NAMES GIVEN_NAMES, EN.SEX SEX_CODE, '_LA:EN.SEX:IGS_LOOKUP_VALUES:SEX:MEANING' "_LA:SEX_DESC", EN.BIRTH_DT BIRTH_DATE, EN.PREFIX PREFIX, EN.ADDRESS_LINE1 ADDRESS_LINE1, EN.ADDRESS_LINE2 ADDRESS_LINE2, EN.ADDRESS_LINE3 ADDRESS_LINE3, EN.ADDRESS_LINE4 ADDRESS_LINE4, EN.COUNTRY COUNTRY, EN.POSTCODE POSTCODE, EN.EMAIL EMAIL, EN.TELEPHONE TELEPHONE, FT1.SYSTEM_CODE UCAS_SYSTEM_CODE, FT1.EXTRA_PASSPORT_NO EXTRA_PASSPORT_NUMBER, FT1.REQUEST_APP_DETS_IND REQUEST_APPL_DETAILS_IND, FT1.REQUEST_COPY_APP_FRM_IND REQUEST_COPY_APPL_FORM_IND, FT1.CEF_NO CLEARING_ENTRY_FORM_NUMBER, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER, EN.CREATED_BY CREATED_BY, EN.CREATION_DATE CREATION_DATE, EN.LAST_UPDATED_BY LAST_UPDATED_BY, EN.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_ENQ_DETAILS EN, IGS_UC_APPLICANTS FT1 WHERE EN.APP_NO = FT1.APP_NO (+) WITH READ ONLY

View Text - HTML Formatted

SELECT EN.APP_NO UCAS_APPLICANT_NUMBER
, EN.SURNAME SURNAME
, EN.GIVEN_NAMES GIVEN_NAMES
, EN.SEX SEX_CODE
, '_LA:EN.SEX:IGS_LOOKUP_VALUES:SEX:MEANING' "_LA:SEX_DESC"
, EN.BIRTH_DT BIRTH_DATE
, EN.PREFIX PREFIX
, EN.ADDRESS_LINE1 ADDRESS_LINE1
, EN.ADDRESS_LINE2 ADDRESS_LINE2
, EN.ADDRESS_LINE3 ADDRESS_LINE3
, EN.ADDRESS_LINE4 ADDRESS_LINE4
, EN.COUNTRY COUNTRY
, EN.POSTCODE POSTCODE
, EN.EMAIL EMAIL
, EN.TELEPHONE TELEPHONE
, FT1.SYSTEM_CODE UCAS_SYSTEM_CODE
, FT1.EXTRA_PASSPORT_NO EXTRA_PASSPORT_NUMBER
, FT1.REQUEST_APP_DETS_IND REQUEST_APPL_DETAILS_IND
, FT1.REQUEST_COPY_APP_FRM_IND REQUEST_COPY_APPL_FORM_IND
, FT1.CEF_NO CLEARING_ENTRY_FORM_NUMBER
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, EN.CREATED_BY CREATED_BY
, EN.CREATION_DATE CREATION_DATE
, EN.LAST_UPDATED_BY LAST_UPDATED_BY
, EN.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_ENQ_DETAILS EN
, IGS_UC_APPLICANTS FT1
WHERE EN.APP_NO = FT1.APP_NO (+) WITH READ ONLY