VIEW: APPS.IGS_UC_QUAL_DETS_V

Source

View Text - Preformatted

SELECT qd.rowid ROW_ID ,qd.qual_dets_id QUAL_DETS_ID ,qd.person_id PERSON_ID ,qd.exam_level EXAM_LEVEL ,pa.award_title EXAM_LEVEL_DESC ,qd.grading_schema_cd GRADING_SCHEMA_CD ,qd.version_number VERSION_NUMBER ,qd.subject_code SUBJECT_CODE ,fs.description SUBJECT_CODE_DESC ,qd.predicted_result PREDICTED_RESULT ,qd.approved_result APPROVED_RESULT ,qd.claimed_result CLAIMED_RESULT ,qd.year YEAR ,qd.sitting SITTING ,lv.meaning SITTING_DESC ,qd.awarding_body AWARDING_BODY ,hp.party_name AWARDING_BODY_DESC ,agsg.rank UCAS_TARIFF ,qd.imported_flag IMPORTED_FLAG ,qd.imported_date IMPORTED_DATE ,qd.creation_date CREATION_DATE ,qd.created_by CREATED_BY ,qd.last_update_date LAST_UPDATE_DATE ,qd.last_updated_by LAST_UPDATED_BY ,qd.last_update_login LAST_UPDATE_LOGIN FROM igs_uc_qual_dets qd ,igs_ps_awd pa ,igs_ps_fld_of_study_all fs ,igs_lookup_values lv ,hz_parties hp ,igs_pe_hz_parties ihp ,igs_as_grd_sch_grade agsg WHERE qd.exam_level = pa.award_cd AND qd.subject_code = fs.field_of_study (+) AND lv.lookup_type (+) = 'IGS_UC_SITTING' AND qd.sitting = lv.lookup_code (+) AND qd.awarding_body = ihp.oss_org_unit_cd (+) AND ihp.party_id = hp.party_id(+) AND agsg.grading_schema_cd (+) = qd.grading_schema_cd AND agsg.version_number (+) = qd.version_number AND agsg.grade (+) = qd.approved_result

View Text - HTML Formatted

SELECT QD.ROWID ROW_ID
, QD.QUAL_DETS_ID QUAL_DETS_ID
, QD.PERSON_ID PERSON_ID
, QD.EXAM_LEVEL EXAM_LEVEL
, PA.AWARD_TITLE EXAM_LEVEL_DESC
, QD.GRADING_SCHEMA_CD GRADING_SCHEMA_CD
, QD.VERSION_NUMBER VERSION_NUMBER
, QD.SUBJECT_CODE SUBJECT_CODE
, FS.DESCRIPTION SUBJECT_CODE_DESC
, QD.PREDICTED_RESULT PREDICTED_RESULT
, QD.APPROVED_RESULT APPROVED_RESULT
, QD.CLAIMED_RESULT CLAIMED_RESULT
, QD.YEAR YEAR
, QD.SITTING SITTING
, LV.MEANING SITTING_DESC
, QD.AWARDING_BODY AWARDING_BODY
, HP.PARTY_NAME AWARDING_BODY_DESC
, AGSG.RANK UCAS_TARIFF
, QD.IMPORTED_FLAG IMPORTED_FLAG
, QD.IMPORTED_DATE IMPORTED_DATE
, QD.CREATION_DATE CREATION_DATE
, QD.CREATED_BY CREATED_BY
, QD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QD.LAST_UPDATED_BY LAST_UPDATED_BY
, QD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_UC_QUAL_DETS QD
, IGS_PS_AWD PA
, IGS_PS_FLD_OF_STUDY_ALL FS
, IGS_LOOKUP_VALUES LV
, HZ_PARTIES HP
, IGS_PE_HZ_PARTIES IHP
, IGS_AS_GRD_SCH_GRADE AGSG
WHERE QD.EXAM_LEVEL = PA.AWARD_CD
AND QD.SUBJECT_CODE = FS.FIELD_OF_STUDY (+)
AND LV.LOOKUP_TYPE (+) = 'IGS_UC_SITTING'
AND QD.SITTING = LV.LOOKUP_CODE (+)
AND QD.AWARDING_BODY = IHP.OSS_ORG_UNIT_CD (+)
AND IHP.PARTY_ID = HP.PARTY_ID(+)
AND AGSG.GRADING_SCHEMA_CD (+) = QD.GRADING_SCHEMA_CD
AND AGSG.VERSION_NUMBER (+) = QD.VERSION_NUMBER
AND AGSG.GRADE (+) = QD.APPROVED_RESULT