VIEW: APPS.IGSBV_GR_GRADUAND

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, GR.CREATE_DT, GR.GRD_CAL_TYPE, GR.GRD_CI_SEQUENCE_NUMBER, GR.COURSE_CD, GR.AWARD_COURSE_CD, GR.AWARD_CRS_VERSION_NUMBER, GR.AWARD_CD, GR.HONOURS_LEVEL, GR.CONFERRAL_DT, GR.GRADUAND_STATUS, GR.GRADUAND_APPR_STATUS, GR.S_GRADUAND_TYPE, GR.GRADUATION_NAME, '_LA:GR.PROXY_AWARD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', GR.PREVIOUS_QUALIFICATIONS, '_LA:GR.CONVOCATION_MEMBERSHIP_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', GR.SUR_FOR_COURSE_CD, GR.SUR_FOR_CRS_VERSION_NUMBER, GR.SUR_FOR_AWARD_CD, GR.COMMENTS, GR.PERSON_ID, GR.PROXY_AWARD_PERSON_ID, GR.CREATED_BY, GR.CREATION_DATE, GR.LAST_UPDATED_BY, GR.LAST_UPDATE_DATE FROM IGS_GR_GRADUAND_ALL GR, HZ_PARTIES HP WHERE GR.PERSON_ID = HP.PARTY_ID WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, GR.CREATE_DT
, GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, GR.COURSE_CD
, GR.AWARD_COURSE_CD
, GR.AWARD_CRS_VERSION_NUMBER
, GR.AWARD_CD
, GR.HONOURS_LEVEL
, GR.CONFERRAL_DT
, GR.GRADUAND_STATUS
, GR.GRADUAND_APPR_STATUS
, GR.S_GRADUAND_TYPE
, GR.GRADUATION_NAME
, '_LA:GR.PROXY_AWARD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GR.PREVIOUS_QUALIFICATIONS
, '_LA:GR.CONVOCATION_MEMBERSHIP_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GR.SUR_FOR_COURSE_CD
, GR.SUR_FOR_CRS_VERSION_NUMBER
, GR.SUR_FOR_AWARD_CD
, GR.COMMENTS
, GR.PERSON_ID
, GR.PROXY_AWARD_PERSON_ID
, GR.CREATED_BY
, GR.CREATION_DATE
, GR.LAST_UPDATED_BY
, GR.LAST_UPDATE_DATE
FROM IGS_GR_GRADUAND_ALL GR
, HZ_PARTIES HP
WHERE GR.PERSON_ID = HP.PARTY_ID WITH READ ONLY