Product: | IGS - Student System |
---|---|
Description: | Person Base View to hold basic person information |
Implementation/DBA Data: | APPS.IGS_PE_PERSON_BASE_V |
SELECT P.ROWID ROW_ID
, P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, P.PERSON_FIRST_NAME FIRST_NAME
, P.PERSON_MIDDLE_NAME MIDDLE_NAME
, P.PERSON_LAST_NAME LAST_NAME
, P.PERSON_TITLE TITLE
, PP.PERSON_NAME FULL_NAME
, P.PERSON_NAME_SUFFIX SUFFIX
, PP.DATE_OF_BIRTH BIRTH_DATE
, PP.GENDER GENDER
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
, PP.DATE_OF_DEATH
, P.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, P.STATUS
, P.KNOWN_AS KNOWN_AS
FROM HZ_PARTIES P
, HZ_PERSON_PROFILES PP
WHERE P.PARTY_ID = PP.PARTY_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)