VIEW: APPS.IGS_PE_STATIC_PIG_MEM_V

Source

View Text - Preformatted

SELECT GM.ROWID ROW_ID, GM.GROUP_ID, GM.PERSON_ID, PE.PERSON_NUMBER, PE.FULL_NAME, PE.GENDER SEX, PE.BIRTH_DATE BIRTH_DT, GM.START_DATE, GM.END_DATE, IGS_EN_GEN_003.GET_STUDENT_IND(PE.PERSON_ID) STUDENT_IND, IGS_EN_GEN_003.GET_STAFF_IND(PE.PERSON_ID) STAFF_IND, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(PE.PERSON_ID) ENCUMBERED_IND, GM.CREATED_BY, GM.CREATION_DATE, GM.LAST_UPDATED_BY, GM.LAST_UPDATE_DATE, GM.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_BASE_V PE, IGS_PE_PRSID_GRP_MEM_ALL GM WHERE GM.PERSON_ID = PE.PERSON_ID

View Text - HTML Formatted

SELECT GM.ROWID ROW_ID
, GM.GROUP_ID
, GM.PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.GENDER SEX
, PE.BIRTH_DATE BIRTH_DT
, GM.START_DATE
, GM.END_DATE
, IGS_EN_GEN_003.GET_STUDENT_IND(PE.PERSON_ID) STUDENT_IND
, IGS_EN_GEN_003.GET_STAFF_IND(PE.PERSON_ID) STAFF_IND
, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(PE.PERSON_ID) ENCUMBERED_IND
, GM.CREATED_BY
, GM.CREATION_DATE
, GM.LAST_UPDATED_BY
, GM.LAST_UPDATE_DATE
, GM.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_BASE_V PE
, IGS_PE_PRSID_GRP_MEM_ALL GM
WHERE GM.PERSON_ID = PE.PERSON_ID