VIEW: APPS.IGSFV_GR_CRMN_STDNT_PRG

Source

View Text - Preformatted

SELECT HP.PARTY_NAME, HP.PARTY_NUMBER, GAC.CREATE_DT, GAC.GRD_CAL_TYPE, GAC.GRD_CI_SEQUENCE_NUMBER, CI.DESCRIPTION, GAC.CEREMONY_NUMBER, GAC.AWARD_COURSE_CD, GAC.AWARD_CRS_VERSION_NUMBER, CRV.TITLE, GAC.AWARD_CD, AW.AWARD_TITLE, GAC.US_GROUP_NUMBER, GAC.ORDER_IN_PRESENTATION, GAC.GRADUAND_SEAT_NUMBER, GAC.NAME_PRONUNCIATION, GAC.NAME_ANNOUNCED, '_LA:GAC.ACADEMIC_DRESS_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', GAC.ACADEMIC_GOWN_SIZE, MSR1.DESCRIPTION, GAC.ACADEMIC_HAT_SIZE, MSR2.DESCRIPTION, GAC.GUEST_TICKETS_REQUESTED, GAC.GUEST_TICKETS_ALLOCATED, GAC.GUEST_SEATS, '_LA:GAC.FEES_PAID_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING', GAC.SPECIAL_REQUIREMENTS, GAC.COMMENTS, GAC.GAC_ID, GAC.PERSON_ID, GAC.CREATED_BY, GAC.CREATION_DATE, GAC.LAST_UPDATED_BY, GAC.LAST_UPDATE_DATE FROM IGS_GR_AWD_CRMN GAC, HZ_PARTIES HP, IGS_PS_VER_ALL CRV, IGS_CA_INST_ALL CI, IGS_PS_AWD AW, IGS_GE_MEASUREMENT MSR1, IGS_GE_MEASUREMENT MSR2 WHERE GAC.PERSON_ID = HP.PARTY_ID AND GAC.GRD_CAL_TYPE = CI.CAL_TYPE AND GAC.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND GAC.AWARD_COURSE_CD = CRV.COURSE_CD (+) AND GAC.AWARD_CRS_VERSION_NUMBER = CRV.VERSION_NUMBER (+) AND GAC.AWARD_CD = AW.AWARD_CD AND GAC.ACADEMIC_GOWN_SIZE = MSR1.MEASUREMENT_CD (+) AND GAC.ACADEMIC_HAT_SIZE = MSR2.MEASUREMENT_CD (+) WITH READ ONLY

View Text - HTML Formatted

SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, GAC.CREATE_DT
, GAC.GRD_CAL_TYPE
, GAC.GRD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, GAC.CEREMONY_NUMBER
, GAC.AWARD_COURSE_CD
, GAC.AWARD_CRS_VERSION_NUMBER
, CRV.TITLE
, GAC.AWARD_CD
, AW.AWARD_TITLE
, GAC.US_GROUP_NUMBER
, GAC.ORDER_IN_PRESENTATION
, GAC.GRADUAND_SEAT_NUMBER
, GAC.NAME_PRONUNCIATION
, GAC.NAME_ANNOUNCED
, '_LA:GAC.ACADEMIC_DRESS_RQRD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GAC.ACADEMIC_GOWN_SIZE
, MSR1.DESCRIPTION
, GAC.ACADEMIC_HAT_SIZE
, MSR2.DESCRIPTION
, GAC.GUEST_TICKETS_REQUESTED
, GAC.GUEST_TICKETS_ALLOCATED
, GAC.GUEST_SEATS
, '_LA:GAC.FEES_PAID_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, GAC.SPECIAL_REQUIREMENTS
, GAC.COMMENTS
, GAC.GAC_ID
, GAC.PERSON_ID
, GAC.CREATED_BY
, GAC.CREATION_DATE
, GAC.LAST_UPDATED_BY
, GAC.LAST_UPDATE_DATE
FROM IGS_GR_AWD_CRMN GAC
, HZ_PARTIES HP
, IGS_PS_VER_ALL CRV
, IGS_CA_INST_ALL CI
, IGS_PS_AWD AW
, IGS_GE_MEASUREMENT MSR1
, IGS_GE_MEASUREMENT MSR2
WHERE GAC.PERSON_ID = HP.PARTY_ID
AND GAC.GRD_CAL_TYPE = CI.CAL_TYPE
AND GAC.GRD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER
AND GAC.AWARD_COURSE_CD = CRV.COURSE_CD (+)
AND GAC.AWARD_CRS_VERSION_NUMBER = CRV.VERSION_NUMBER (+)
AND GAC.AWARD_CD = AW.AWARD_CD
AND GAC.ACADEMIC_GOWN_SIZE = MSR1.MEASUREMENT_CD (+)
AND GAC.ACADEMIC_HAT_SIZE = MSR2.MEASUREMENT_CD (+) WITH READ ONLY