VIEW: APPS.IGS_PR_DISPLAY_V

Source

View Text - Preformatted

SELECT pe.person_id, pe.staff_member_ind, SUBSTR(IGS_EN_GEN_007.enrp_get_student_ind(pe.person_id), 1, 1), SUBSTR(IGS_EN_GEN_003.enrp_get_encmbrd_ind(pe.person_id), 1, 1), pe.deceased_ind, pe.surname, pe.given_names, pe.preferred_given_name, pe.sex, pe.title, pe.birth_dt, pe.salutation, pe.oracle_username, pe.email_addr, pe.archive_exclusion_ind, pe.archive_dt, pe.purge_exclusion_ind, pe.purge_dt, pe.given_names || ' ' || pe.surname, NVL(pe.preferred_given_name, substr (pe.given_names, 1, decode(instr(pe.given_names, ' '), 0, length(pe.given_names), (instr(pe.given_names, ' ')-1)))) || ' ' || pe.surname, pe.title || ' ' || pe.given_names || ' ' || pe.surname, SUBSTR(IGS_GE_GEN_002.genp_get_initials(pe.given_names), 1, 10) || ' ' || pe.surname, pe.surname || ', ' || SUBSTR(IGS_GE_GEN_002.genp_get_initials(pe.given_names),1,10), pe.surname || ',  ' || pe.title || '  ' || NVL(pe.preferred_given_name,pe.given_names) FROM IGS_PE_PERSON pe

View Text - HTML Formatted

SELECT PE.PERSON_ID
, PE.STAFF_MEMBER_IND
, SUBSTR(IGS_EN_GEN_007.ENRP_GET_STUDENT_IND(PE.PERSON_ID)
, 1
, 1)
, SUBSTR(IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(PE.PERSON_ID)
, 1
, 1)
, PE.DECEASED_IND
, PE.SURNAME
, PE.GIVEN_NAMES
, PE.PREFERRED_GIVEN_NAME
, PE.SEX
, PE.TITLE
, PE.BIRTH_DT
, PE.SALUTATION
, PE.ORACLE_USERNAME
, PE.EMAIL_ADDR
, PE.ARCHIVE_EXCLUSION_IND
, PE.ARCHIVE_DT
, PE.PURGE_EXCLUSION_IND
, PE.PURGE_DT
, PE.GIVEN_NAMES || ' ' || PE.SURNAME
, NVL(PE.PREFERRED_GIVEN_NAME
, SUBSTR (PE.GIVEN_NAMES
, 1
, DECODE(INSTR(PE.GIVEN_NAMES
, ' ')
, 0
, LENGTH(PE.GIVEN_NAMES)
, (INSTR(PE.GIVEN_NAMES
, ' ')-1)))) || ' ' || PE.SURNAME
, PE.TITLE || ' ' || PE.GIVEN_NAMES || ' ' || PE.SURNAME
, SUBSTR(IGS_GE_GEN_002.GENP_GET_INITIALS(PE.GIVEN_NAMES)
, 1
, 10) || ' ' || PE.SURNAME
, PE.SURNAME || '
, ' || SUBSTR(IGS_GE_GEN_002.GENP_GET_INITIALS(PE.GIVEN_NAMES)
, 1
, 10)
, PE.SURNAME || '
, ' || PE.TITLE || ' ' || NVL(PE.PREFERRED_GIVEN_NAME
, PE.GIVEN_NAMES)
FROM IGS_PE_PERSON PE