VIEW: APPS.IGSFV_GR_GRADUAND

Source

View Text - Preformatted

SELECT HP1.PARTY_NAME, HP1.PARTY_NUMBER, GR.CREATE_DT, GR.GRD_CAL_TYPE, GR.GRD_CI_SEQUENCE_NUMBER, CI.DESCRIPTION, GR.COURSE_CD, CRV1.TITLE, GR.AWARD_COURSE_CD, GR.AWARD_CRS_VERSION_NUMBER, CRV2.TITLE, GR.AWARD_CD, AW1.AWARD_TITLE, GR.HONOURS_LEVEL, HL.DESCRIPTION, 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', HP2.PARTY_NAME, HP2.PARTY_NUMBER, 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, CRV3.TITLE, GR.SUR_FOR_AWARD_CD, AW2.AWARD_TITLE, 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, IGS_EN_STDNT_PS_ATT_ALL SCA, HZ_PARTIES HP1, HZ_PARTIES HP2, IGS_PS_VER_ALL CRV1, IGS_PS_VER_ALL CRV2, IGS_PS_VER_ALL CRV3, IGS_CA_INST_ALL CI, IGS_GR_HONOURS_LEVEL_ALL HL, IGS_PS_AWD AW1, IGS_PS_AWD AW2 WHERE GR.PERSON_ID = HP1.PARTY_ID AND GR.PROXY_AWARD_PERSON_ID = HP2.PARTY_ID (+) AND GR.PERSON_ID = SCA.PERSON_ID (+) AND GR.COURSE_CD = SCA.COURSE_CD (+) AND SCA.COURSE_CD = CRV1.COURSE_CD (+) AND SCA.VERSION_NUMBER = CRV1.VERSION_NUMBER (+) AND GR.GRD_CAL_TYPE = CI.CAL_TYPE AND GR.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND GR.AWARD_COURSE_CD = CRV2.COURSE_CD (+) AND GR.AWARD_CRS_VERSION_NUMBER = CRV2.VERSION_NUMBER (+) AND GR.SUR_FOR_COURSE_CD = CRV3.COURSE_CD (+) AND GR.SUR_FOR_CRS_VERSION_NUMBER = CRV3.VERSION_NUMBER (+) AND GR.HONOURS_LEVEL = HL.HONOURS_LEVEL (+) AND GR.AWARD_CD = AW1.AWARD_CD AND GR.SUR_FOR_AWARD_CD = AW2.AWARD_CD (+) WITH READ ONLY

View Text - HTML Formatted

SELECT HP1.PARTY_NAME
, HP1.PARTY_NUMBER
, GR.CREATE_DT
, GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, GR.COURSE_CD
, CRV1.TITLE
, GR.AWARD_COURSE_CD
, GR.AWARD_CRS_VERSION_NUMBER
, CRV2.TITLE
, GR.AWARD_CD
, AW1.AWARD_TITLE
, GR.HONOURS_LEVEL
, HL.DESCRIPTION
, 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'
, HP2.PARTY_NAME
, HP2.PARTY_NUMBER
, 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
, CRV3.TITLE
, GR.SUR_FOR_AWARD_CD
, AW2.AWARD_TITLE
, 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
, IGS_EN_STDNT_PS_ATT_ALL SCA
, HZ_PARTIES HP1
, HZ_PARTIES HP2
, IGS_PS_VER_ALL CRV1
, IGS_PS_VER_ALL CRV2
, IGS_PS_VER_ALL CRV3
, IGS_CA_INST_ALL CI
, IGS_GR_HONOURS_LEVEL_ALL HL
, IGS_PS_AWD AW1
, IGS_PS_AWD AW2
WHERE GR.PERSON_ID = HP1.PARTY_ID
AND GR.PROXY_AWARD_PERSON_ID = HP2.PARTY_ID (+)
AND GR.PERSON_ID = SCA.PERSON_ID (+)
AND GR.COURSE_CD = SCA.COURSE_CD (+)
AND SCA.COURSE_CD = CRV1.COURSE_CD (+)
AND SCA.VERSION_NUMBER = CRV1.VERSION_NUMBER (+)
AND GR.GRD_CAL_TYPE = CI.CAL_TYPE
AND GR.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND GR.AWARD_COURSE_CD = CRV2.COURSE_CD (+)
AND GR.AWARD_CRS_VERSION_NUMBER = CRV2.VERSION_NUMBER (+)
AND GR.SUR_FOR_COURSE_CD = CRV3.COURSE_CD (+)
AND GR.SUR_FOR_CRS_VERSION_NUMBER = CRV3.VERSION_NUMBER (+)
AND GR.HONOURS_LEVEL = HL.HONOURS_LEVEL (+)
AND GR.AWARD_CD = AW1.AWARD_CD
AND GR.SUR_FOR_AWARD_CD = AW2.AWARD_CD (+) WITH READ ONLY