View: IGS_GR_GRADUAND_DTL_V

View Text

SELECT GR.ROWID ROW_ID
, GR.PERSON_ID
, PE.PARTY_NUMBER
, GR.AWARD_COURSE_CD
, GR.AWARD_CRS_VERSION_NUMBER
, GR.AWARD_CD
, GR.COURSE_CD
, GR.S_GRADUAND_TYPE
, GR.CONVOCATION_MEMBERSHIP_IND
, GR.GRADUAND_STATUS
, GR.GRADUAND_APPR_STATUS
, GR.CREATE_DT
, SPAA.CONFERRAL_DATE
, GR.GRADUATION_NAME
, GR.PREVIOUS_QUALIFICATIONS
, GR.COMMENTS
, GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, GR.PROXY_AWARD_IND
, GR.PROXY_AWARD_PERSON_ID
, PE1.PARTY_NUMBER PROXY_AWARD_PERSON_NUMBER
, GR.SUR_FOR_COURSE_CD
, GR.SUR_FOR_CRS_VERSION_NUMBER
, GR.SUR_FOR_AWARD_CD
, GR.HONOURS_LEVEL
, GR.CREATED_BY
, GR.CREATION_DATE
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
, GR.LAST_UPDATE_LOGIN
, GR.ATTRIBUTE_CATEGORY
, GR.ATTRIBUTE1
, GR.ATTRIBUTE2
, GR.ATTRIBUTE3
, GR.ATTRIBUTE4
, GR.ATTRIBUTE5
, GR.ATTRIBUTE6
, GR.ATTRIBUTE7
, GR.ATTRIBUTE8
, GR.ATTRIBUTE9
, GR.ATTRIBUTE10
, GR.ATTRIBUTE11
, GR.ATTRIBUTE12
, GR.ATTRIBUTE13
, GR.ATTRIBUTE14
, GR.ATTRIBUTE15
, GR.ATTRIBUTE16
, GR.ATTRIBUTE17
, GR.ATTRIBUTE18
, GR.ATTRIBUTE19
, GR.ATTRIBUTE20
, SPAA.AWARD_MARK
, SPAA.AWARD_GRADE
, SPAA.COMPLETE_IND
FROM IGS_GR_GRADUAND_ALL GR
, HZ_PARTIES PE
, HZ_PARTIES PE1
, IGS_EN_SPA_AWD_AIM SPAA
WHERE GR.PERSON_ID = PE.PARTY_ID
AND GR.PROXY_AWARD_PERSON_ID = PE1.PARTY_ID(+)
AND GR.PERSON_ID = SPAA.PERSON_ID(+)
AND GR.COURSE_CD = SPAA.COURSE_CD(+)
AND GR.AWARD_CD = SPAA.AWARD_CD(+)

Columns