VIEW: APPS.IGS_PE_PRSID_GRP_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 UNION ALL SELECT PE.ROWID ROW_ID, GP.GROUP_ID, PE.PERSON_ID, PE.PERSON_NUMBER, PE.FULL_NAME, PE.GENDER SEX, PE.BIRTH_DATE BIRTH_DT, SYSDATE, TO_DATE(NULL), 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, PE.CREATED_BY, PE.CREATION_DATE, PE.LAST_UPDATED_BY, PE.LAST_UPDATE_DATE, PE.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_BASE_V PE, IGS_PE_PERSID_GROUP_ALL GP WHERE GP.FILE_NAME IS NOT NULL AND PE.PERSON_ID=IGS_PE_DYNAMIC_PERSID_GROUP.DYN_PIG_MEMBER(GP.GROUP_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 UNION ALL SELECT PE.ROWID ROW_ID
, GP.GROUP_ID
, PE.PERSON_ID
, PE.PERSON_NUMBER
, PE.FULL_NAME
, PE.GENDER SEX
, PE.BIRTH_DATE BIRTH_DT
, SYSDATE
, TO_DATE(NULL)
, 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
, PE.CREATED_BY
, PE.CREATION_DATE
, PE.LAST_UPDATED_BY
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_BASE_V PE
, IGS_PE_PERSID_GROUP_ALL GP
WHERE GP.FILE_NAME IS NOT NULL
AND PE.PERSON_ID=IGS_PE_DYNAMIC_PERSID_GROUP.DYN_PIG_MEMBER(GP.GROUP_ID
, PE.PERSON_ID)