VIEW: APPS.IGS_GR_GRADUATE_REGISTER_RPT_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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