VIEW: APPS.IGS_PE_SS_PERSON_V

Source

View Text - Preformatted

SELECT P.ROWID ROW_ID, P.PARTY_ID PERSON_ID, P.PARTY_NUMBER PERSON_NUMBER, P.PERSON_PRE_NAME_ADJUNCT PREFIX, 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, P.ATTRIBUTE_CATEGORY, P.ATTRIBUTE1, P.ATTRIBUTE2, P.ATTRIBUTE3, P.ATTRIBUTE4, P.ATTRIBUTE5, P.ATTRIBUTE6, P.ATTRIBUTE7, P.ATTRIBUTE8, P.ATTRIBUTE9, P.ATTRIBUTE10, P.ATTRIBUTE11, P.ATTRIBUTE12, P.ATTRIBUTE13, P.ATTRIBUTE14, P.ATTRIBUTE15, P.ATTRIBUTE16, P.ATTRIBUTE17, P.ATTRIBUTE18, P.ATTRIBUTE19, P.ATTRIBUTE20, P.ATTRIBUTE21, P.ATTRIBUTE22, P.ATTRIBUTE23, P.ATTRIBUTE24, PP.DECLARED_ETHNICITY, PP.MARITAL_STATUS, PP.MARITAL_STATUS_EFFECTIVE_DATE, PHP.BIRTH_CITY, PHP.BIRTH_COUNTRY, PHP.VETERAN FROM HZ_PARTIES P, HZ_PERSON_PROFILES PP, IGS_PE_HZ_PARTIES PHP WHERE P.PARTY_ID = PP.PARTY_ID AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) AND P.PARTY_ID = PHP.PARTY_ID(+)

View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_PRE_NAME_ADJUNCT PREFIX
, 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
, P.ATTRIBUTE_CATEGORY
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.ATTRIBUTE16
, P.ATTRIBUTE17
, P.ATTRIBUTE18
, P.ATTRIBUTE19
, P.ATTRIBUTE20
, P.ATTRIBUTE21
, P.ATTRIBUTE22
, P.ATTRIBUTE23
, P.ATTRIBUTE24
, PP.DECLARED_ETHNICITY
, PP.MARITAL_STATUS
, PP.MARITAL_STATUS_EFFECTIVE_DATE
, PHP.BIRTH_CITY
, PHP.BIRTH_COUNTRY
, PHP.VETERAN
FROM HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PE_HZ_PARTIES PHP
WHERE P.PARTY_ID = PP.PARTY_ID
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PHP.PARTY_ID(+)