VIEW: APPS.IGSFV_UC_APPLICANT_RESULTS

Source

View Text - Preformatted

SELECT AP.APP_RESULT_ID APPLICANT_RESULT_IDENTIFIER, AP.APP_NO UCAS_APPLICANT_NUMBER, AP.ENQUIRY_NO ENQUIRY_NUMBER, AP.EXAM_LEVEL EXAM_LEVEL, AP.YEAR EXAM_YEAR, AP.SITTING SITTING, '_LA:AP.SITTING:IGS_LOOKUP_VALUES:IGS_UC_SITTING:MEANING' "_LA:SITTING_DESC", AP.AWARD_BODY AWARDING_BODY, AP.PREDICTED_RESULT PREDICTED_RESULT, AP.RESULT_IN_OFFER RESULT_IN_OFFER, AP.EBL_RESULT EBL_RESULT, AP.EBL_AMENDED_RESULT EBL_AMENDED_RESULT, AP.CLAIMED_RESULT CLAIMED_RESULT, AP.IMPORTED IMPORTED_FLAG, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER, FT2.PARTY_NUMBER OSS_PERSON_NUMBER, FT2.PARTY_NAME OSS_PERSON_NAME, FT3.SUBJECT_CODE SUBJECT_CODE, FT3.TITLE SUBJECT_TITLE, FT4.BODY_NAME AWARDING_BODY_NAME, AP.APP_ID APPLICANT_IDENTIFIER, AP.SUBJECT_ID SUBJECT_IDENTIFIER, 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_RESULTS AP, IGS_UC_APPLICANTS FT1, HZ_PARTIES FT2, IGS_UC_COM_EBL_SUBJ FT3, IGS_UC_REF_AWRDBDY FT4 WHERE AP.APP_NO = FT1.APP_NO AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+) AND AP.SUBJECT_ID = FT3.SUBJECT_ID AND AP.AWARD_BODY = FT4.AWARDING_BODY (+) AND AP.YEAR = FT4.YEAR (+) AND AP.SITTING = FT4.SITTING (+) WITH READ ONLY

View Text - HTML Formatted

SELECT AP.APP_RESULT_ID APPLICANT_RESULT_IDENTIFIER
, AP.APP_NO UCAS_APPLICANT_NUMBER
, AP.ENQUIRY_NO ENQUIRY_NUMBER
, AP.EXAM_LEVEL EXAM_LEVEL
, AP.YEAR EXAM_YEAR
, AP.SITTING SITTING
, '_LA:AP.SITTING:IGS_LOOKUP_VALUES:IGS_UC_SITTING:MEANING' "_LA:SITTING_DESC"
, AP.AWARD_BODY AWARDING_BODY
, AP.PREDICTED_RESULT PREDICTED_RESULT
, AP.RESULT_IN_OFFER RESULT_IN_OFFER
, AP.EBL_RESULT EBL_RESULT
, AP.EBL_AMENDED_RESULT EBL_AMENDED_RESULT
, AP.CLAIMED_RESULT CLAIMED_RESULT
, AP.IMPORTED IMPORTED_FLAG
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, FT2.PARTY_NUMBER OSS_PERSON_NUMBER
, FT2.PARTY_NAME OSS_PERSON_NAME
, FT3.SUBJECT_CODE SUBJECT_CODE
, FT3.TITLE SUBJECT_TITLE
, FT4.BODY_NAME AWARDING_BODY_NAME
, AP.APP_ID APPLICANT_IDENTIFIER
, AP.SUBJECT_ID SUBJECT_IDENTIFIER
, 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_RESULTS AP
, IGS_UC_APPLICANTS FT1
, HZ_PARTIES FT2
, IGS_UC_COM_EBL_SUBJ FT3
, IGS_UC_REF_AWRDBDY FT4
WHERE AP.APP_NO = FT1.APP_NO
AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+)
AND AP.SUBJECT_ID = FT3.SUBJECT_ID
AND AP.AWARD_BODY = FT4.AWARDING_BODY (+)
AND AP.YEAR = FT4.YEAR (+)
AND AP.SITTING = FT4.SITTING (+) WITH READ ONLY