VIEW: APPS.IGS_AV_ACAD_HISTORY_V

Source

View Text - Preformatted

SELECT he.ROWID row_id, he.party_id person_id, he.education_id, DECODE (he.school_party_id, NULL, NULL, (SELECT php.oss_org_unit_cd FROM igs_pe_hz_parties php WHERE he.school_party_id = php.party_id) ) institution_code, t.transcript_id, d.term_details_id, lk.meaning "TERM_TYPE_MEANING", d.term, e.unit_details_id, e.unit, e.unit_name, e.grade, e.cp_earned, he.created_by, he.creation_date, he.last_updated_by, he.last_update_date, he.last_update_login, t.date_of_issue, he.status FROM hz_education he, hz_parties p, igs_ad_transcript t, igs_ad_term_details d, igs_lookups_view lk, igs_ad_term_unitdtls e WHERE he.education_id = t.education_id AND t.transcript_id = d.transcript_id AND t.term_type = lk.lookup_code AND lk.lookup_type = 'TERM_TYPE' AND d.term_details_id = e.term_details_id AND p.party_id = he.school_party_id

View Text - HTML Formatted

SELECT HE.ROWID ROW_ID
, HE.PARTY_ID PERSON_ID
, HE.EDUCATION_ID
, DECODE (HE.SCHOOL_PARTY_ID
, NULL
, NULL
, (SELECT PHP.OSS_ORG_UNIT_CD
FROM IGS_PE_HZ_PARTIES PHP
WHERE HE.SCHOOL_PARTY_ID = PHP.PARTY_ID) ) INSTITUTION_CODE
, T.TRANSCRIPT_ID
, D.TERM_DETAILS_ID
, LK.MEANING "TERM_TYPE_MEANING"
, D.TERM
, E.UNIT_DETAILS_ID
, E.UNIT
, E.UNIT_NAME
, E.GRADE
, E.CP_EARNED
, HE.CREATED_BY
, HE.CREATION_DATE
, HE.LAST_UPDATED_BY
, HE.LAST_UPDATE_DATE
, HE.LAST_UPDATE_LOGIN
, T.DATE_OF_ISSUE
, HE.STATUS
FROM HZ_EDUCATION HE
, HZ_PARTIES P
, IGS_AD_TRANSCRIPT T
, IGS_AD_TERM_DETAILS D
, IGS_LOOKUPS_VIEW LK
, IGS_AD_TERM_UNITDTLS E
WHERE HE.EDUCATION_ID = T.EDUCATION_ID
AND T.TRANSCRIPT_ID = D.TRANSCRIPT_ID
AND T.TERM_TYPE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'TERM_TYPE'
AND D.TERM_DETAILS_ID = E.TERM_DETAILS_ID
AND P.PARTY_ID = HE.SCHOOL_PARTY_ID