VIEW: APPS.IGSBV_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, GAC.CEREMONY_NUMBER, GAC.AWARD_COURSE_CD, GAC.AWARD_CRS_VERSION_NUMBER, GAC.AWARD_CD, 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, GAC.ACADEMIC_HAT_SIZE, 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 WHERE GAC.PERSON_ID = HP.PARTY_ID 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
, GAC.CEREMONY_NUMBER
, GAC.AWARD_COURSE_CD
, GAC.AWARD_CRS_VERSION_NUMBER
, GAC.AWARD_CD
, 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
, GAC.ACADEMIC_HAT_SIZE
, 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
WHERE GAC.PERSON_ID = HP.PARTY_ID WITH READ ONLY