VIEW: APPS.IGS_UC_EXP_QUAL_SUM_V

Source

View Text - Preformatted

SELECT eqs.ROWID ,eqs.EXP_QUAL_SUM_ID ,eqs.PERSON_ID ,eqs.EXP_GCE ,eqs.EXP_VCE ,eqs.WINTER_A_LEVELS ,eqs.PREV_A_LEVELS ,eqs.PREV_AS_LEVELS ,eqs.SQA ,eqs.BTEC ,eqs.IB ,eqs.ILC ,eqs.AILC ,eqs.KSI ,eqs.ROA ,eqs.MANUAL ,eqs.OEQ ,urc1.code_text ,eqs.PREV_OEQ ,urc2.code_text ,eqs.VQI ,hcv.value_description ,eqs.SEQ_UPDATED_DATE ,eqs.CREATED_BY ,eqs.CREATION_DATE ,eqs.LAST_UPDATED_BY ,eqs.LAST_UPDATE_DATE ,eqs.LAST_UPDATE_LOGIN FROM igs_uc_exp_qual_sum eqs, igs_uc_ref_codes urc1, igs_uc_ref_codes urc2, igs_he_code_values hcv WHERE eqs.oeq = urc1.code(+) AND urc1.code_type(+) = 'OC' AND eqs.prev_oeq = urc2.code(+) AND urc2.code_type(+) = 'OC' AND eqs.vqi = hcv.value(+) AND hcv.code_type(+) = 'UCAS_VOC_QUAL'

View Text - HTML Formatted

SELECT EQS.ROWID
, EQS.EXP_QUAL_SUM_ID
, EQS.PERSON_ID
, EQS.EXP_GCE
, EQS.EXP_VCE
, EQS.WINTER_A_LEVELS
, EQS.PREV_A_LEVELS
, EQS.PREV_AS_LEVELS
, EQS.SQA
, EQS.BTEC
, EQS.IB
, EQS.ILC
, EQS.AILC
, EQS.KSI
, EQS.ROA
, EQS.MANUAL
, EQS.OEQ
, URC1.CODE_TEXT
, EQS.PREV_OEQ
, URC2.CODE_TEXT
, EQS.VQI
, HCV.VALUE_DESCRIPTION
, EQS.SEQ_UPDATED_DATE
, EQS.CREATED_BY
, EQS.CREATION_DATE
, EQS.LAST_UPDATED_BY
, EQS.LAST_UPDATE_DATE
, EQS.LAST_UPDATE_LOGIN
FROM IGS_UC_EXP_QUAL_SUM EQS
, IGS_UC_REF_CODES URC1
, IGS_UC_REF_CODES URC2
, IGS_HE_CODE_VALUES HCV
WHERE EQS.OEQ = URC1.CODE(+)
AND URC1.CODE_TYPE(+) = 'OC'
AND EQS.PREV_OEQ = URC2.CODE(+)
AND URC2.CODE_TYPE(+) = 'OC'
AND EQS.VQI = HCV.VALUE(+)
AND HCV.CODE_TYPE(+) = 'UCAS_VOC_QUAL'