Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT GR.GRD_CAL_TYPE
, GR.GRD_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, GAC.CEREMONY_NUMBER
, GR.PERSON_ID
, PE.PARTY_NUMBER
, GR.GRADUATION_NAME
, GR.AWARD_COURSE_CD
, GR.AWARD_CD
, ACUS.UNIT_SET_CD
, GR.HONOURS_LEVEL
, GR.CONFERRAL_DT
, DAIV.ALIAS_VAL
, NULL
, NULL
, GAC.CREATED_BY
, GAC.CREATION_DATE
, GAC.LAST_UPDATED_BY
, GAC.LAST_UPDATE_DATE
, GAC.LAST_UPDATE_LOGIN
FROM IGS_GR_GRADUAND GR
, IGS_GR_STAT GST
, IGS_GR_AWD_CRMN GAC
, IGS_GR_CRMN GC
, IGS_GR_AWD_CRM_UT_ST ACUS
, IGS_CA_INST CI
, IGS_CA_DA_INST_V DAIV
, HZ_PARTIES PE
WHERE GR.GRADUAND_STATUS = GST.GRADUAND_STATUS AND GST.S_GRADUAND_STATUS = 'GRADUATED' AND GR.GRD_CAL_TYPE = CI.CAL_TYPE AND GR.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND GR.PERSON_ID = GAC.PERSON_ID (+) AND GR.CREATE_DT = GAC.CREATE_DT (+) AND GAC.GRD_CAL_TYPE = GC.GRD_CAL_TYPE (+) AND GAC.GRD_CI_SEQUENCE_NUMBER = GC.GRD_CI_SEQUENCE_NUMBER (+) AND GAC.CEREMONY_NUMBER = GC.CEREMONY_NUMBER (+) AND GC.GRD_CAL_TYPE = DAIV.CAL_TYPE (+) AND GC.GRD_CI_SEQUENCE_NUMBER = DAIV.CI_SEQUENCE_NUMBER (+) AND GC.CEREMONY_DT_ALIAS = DAIV.DT_ALIAS (+) AND GC.CEREMONY_DAI_SEQUENCE_NUMBER = DAIV.SEQUENCE_NUMBER (+) AND GAC.GRD_CAL_TYPE = ACUS.GRD_CAL_TYPE (+) AND GAC.GRD_CI_SEQUENCE_NUMBER = ACUS.GRD_CI_SEQUENCE_NUMBER (+) AND GAC.CEREMONY_NUMBER = ACUS.CEREMONY_NUMBER (+) AND GAC.AWARD_COURSE_CD = ACUS.AWARD_COURSE_CD (+) AND GAC.AWARD_CRS_VERSION_NUMBER = ACUS.AWARD_CRS_VERSION_NUMBER (+) AND GAC.AWARD_CD = ACUS.AWARD_CD (+) AND GAC.US_GROUP_NUMBER = ACUS.US_GROUP_NUMBER (+)
AND GR.PERSON_ID = PE.PARTY_ID