VIEW: APPS.IGS_GR_AWD_CRMN_V

Source

View Text - Preformatted

SELECT CR.GAC_ID, CR.PERSON_ID, PE.PERSON_NUMBER, PE.BIRTH_DT, PE.ENCUMBERED_IND, PE.DECEASED_IND, PE.CONTEXT_BLOCK_NAME , PE.SEX, PE.SEX_MEANING AS MEANING, CR.CREATE_DT, CR.GRD_CAL_TYPE, CR.GRD_CI_SEQUENCE_NUMBER, CR.CEREMONY_NUMBER, CR.AWARD_COURSE_CD, CR.AWARD_CRS_VERSION_NUMBER, CR.AWARD_CD, CR.US_GROUP_NUMBER, CR.ORDER_IN_PRESENTATION, CR.GRADUAND_SEAT_NUMBER, CR.NAME_PRONUNCIATION, CR.NAME_ANNOUNCED, CR.ACADEMIC_DRESS_RQRD_IND, CR.ACADEMIC_GOWN_SIZE, CR.ACADEMIC_HAT_SIZE, CR.GUEST_TICKETS_REQUESTED, CR.GUEST_TICKETS_ALLOCATED, CR.GUEST_SEATS, CR.FEES_PAID_IND, CR.SPECIAL_REQUIREMENTS, CR.COMMENTS, CR.CREATED_BY, CR.CREATION_DATE, CR.LAST_UPDATED_BY, CR.LAST_UPDATE_DATE, CR.LAST_UPDATE_LOGIN, CR.REQUEST_ID, CR.PROGRAM_APPLICATION_ID, CR.PROGRAM_ID, CR.PROGRAM_UPDATE_DATE FROM IGS_GR_AWD_CRMN CR, IGS_PE_PERSON_V PE WHERE CR.PERSON_ID=PE.PERSON_ID

View Text - HTML Formatted

SELECT CR.GAC_ID
, CR.PERSON_ID
, PE.PERSON_NUMBER
, PE.BIRTH_DT
, PE.ENCUMBERED_IND
, PE.DECEASED_IND
, PE.CONTEXT_BLOCK_NAME
, PE.SEX
, PE.SEX_MEANING AS MEANING
, CR.CREATE_DT
, CR.GRD_CAL_TYPE
, CR.GRD_CI_SEQUENCE_NUMBER
, CR.CEREMONY_NUMBER
, CR.AWARD_COURSE_CD
, CR.AWARD_CRS_VERSION_NUMBER
, CR.AWARD_CD
, CR.US_GROUP_NUMBER
, CR.ORDER_IN_PRESENTATION
, CR.GRADUAND_SEAT_NUMBER
, CR.NAME_PRONUNCIATION
, CR.NAME_ANNOUNCED
, CR.ACADEMIC_DRESS_RQRD_IND
, CR.ACADEMIC_GOWN_SIZE
, CR.ACADEMIC_HAT_SIZE
, CR.GUEST_TICKETS_REQUESTED
, CR.GUEST_TICKETS_ALLOCATED
, CR.GUEST_SEATS
, CR.FEES_PAID_IND
, CR.SPECIAL_REQUIREMENTS
, CR.COMMENTS
, CR.CREATED_BY
, CR.CREATION_DATE
, CR.LAST_UPDATED_BY
, CR.LAST_UPDATE_DATE
, CR.LAST_UPDATE_LOGIN
, CR.REQUEST_ID
, CR.PROGRAM_APPLICATION_ID
, CR.PROGRAM_ID
, CR.PROGRAM_UPDATE_DATE
FROM IGS_GR_AWD_CRMN CR
, IGS_PE_PERSON_V PE
WHERE CR.PERSON_ID=PE.PERSON_ID