VIEW: APPS.IGSBV_UC_EXP_QUAL_SUMMARIES

Source

View Text - Preformatted

SELECT EX.EXP_QUAL_SUM_ID EXPECTED_QUAL_SUMMARY_ID, EX.PERSON_ID OSS_PERSON_IDENTIFIER, EX.EXP_GCE EXPECTED_GCE, EX.EXP_VCE EXPECTED_VCE, EX.WINTER_A_LEVELS WINTER_A_LEVELS, EX.PREV_A_LEVELS PREVIOUS_A_LEVELS, EX.PREV_AS_LEVELS PREVIOUS_AS_LEVELS, EX.SQA SQA_CANDIDATE_FLAG, EX.BTEC QUAL_BTEC_FLAG, EX.IB QUAL_IB_FLAG, EX.ILC QUAL_ILC_FLAG, EX.AILC QUAL_AILC_FLAG, EX.KSI KEY_SKILLS_FLAG, EX.ROA RECORD_OF_ACHEIVEMENT_FLAG, EX.MANUAL MANUAL_QUAL_CHECK, EX.OEQ OTHER_EXAMINATION_QUAL_FLAG, EX.PREV_OEQ PREVIOUS_OTHER_EXAM_QUAL_FLAG, EX.VQI VOCATIONAL_QUAL_INDICATOR, EX.SEQ_UPDATED_DATE SEQ_UPDATED_DATE, FT1.PARTY_NUMBER OSS_PERSON_NUMBER, FT1.PARTY_NAME OSS_PERSON_NAME, EX.CREATION_DATE CREATION_DATE, EX.CREATED_BY CREATED_BY, EX.LAST_UPDATE_DATE LAST_UPDATE_DATE, EX.LAST_UPDATED_BY LAST_UPDATED_BY FROM IGS_UC_EXP_QUAL_SUM EX, HZ_PARTIES FT1 WHERE EX.PERSON_ID = FT1.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT EX.EXP_QUAL_SUM_ID EXPECTED_QUAL_SUMMARY_ID
, EX.PERSON_ID OSS_PERSON_IDENTIFIER
, EX.EXP_GCE EXPECTED_GCE
, EX.EXP_VCE EXPECTED_VCE
, EX.WINTER_A_LEVELS WINTER_A_LEVELS
, EX.PREV_A_LEVELS PREVIOUS_A_LEVELS
, EX.PREV_AS_LEVELS PREVIOUS_AS_LEVELS
, EX.SQA SQA_CANDIDATE_FLAG
, EX.BTEC QUAL_BTEC_FLAG
, EX.IB QUAL_IB_FLAG
, EX.ILC QUAL_ILC_FLAG
, EX.AILC QUAL_AILC_FLAG
, EX.KSI KEY_SKILLS_FLAG
, EX.ROA RECORD_OF_ACHEIVEMENT_FLAG
, EX.MANUAL MANUAL_QUAL_CHECK
, EX.OEQ OTHER_EXAMINATION_QUAL_FLAG
, EX.PREV_OEQ PREVIOUS_OTHER_EXAM_QUAL_FLAG
, EX.VQI VOCATIONAL_QUAL_INDICATOR
, EX.SEQ_UPDATED_DATE SEQ_UPDATED_DATE
, FT1.PARTY_NUMBER OSS_PERSON_NUMBER
, FT1.PARTY_NAME OSS_PERSON_NAME
, EX.CREATION_DATE CREATION_DATE
, EX.CREATED_BY CREATED_BY
, EX.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EX.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_UC_EXP_QUAL_SUM EX
, HZ_PARTIES FT1
WHERE EX.PERSON_ID = FT1.PARTY_ID (+) WITH READ ONLY