VIEW: APPS.IGS_PE_PERSON_DTLS_V

Source

View Text - Preformatted

SELECT P.ROWID ROW_ID, P.PARTY_ID PERSON_ID, P.PARTY_NUMBER PERSON_NUMBER, P.PERSON_LAST_NAME SURNAME, P.PERSON_FIRST_NAME GIVEN_NAMES, P.PERSON_NAME_SUFFIX SUFFIX, P.PERSON_MIDDLE_NAME MIDDLE_NAME, P.PERSON_PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT, LK1.MEANING PRE_NAME_ADJUNCT_MEANING, PP.GENDER SEX, LK.MEANING SEX_MEANING, P.PERSON_TITLE TITLE, DECODE(PP.DATE_OF_DEATH,NULL,NVL(PD.DECEASED_IND,'N'),'Y') DECEASED_IND, PP.DATE_OF_DEATH DECEASED_DATE, PD.ARCHIVE_EXCLUSION_IND, PD.ARCHIVE_DT, PD.PURGE_EXCLUSION_IND, PD.PURGE_DT, PP.BIRTH_DATE BIRTH_DT, P.EMAIL_ADDRESS EMAIL_ADDR, P.SALUTATION, P.KNOWN_AS PREFERRED_GIVEN_NAME, IGS_EN_GEN_003.enrp_get_encmbrd_ind(p.party_id) ENCUMBERED_IND, PD.PROOF_OF_INS, PD.PROOF_OF_IMMU, PD.ORACLE_USERNAME, PD.LEVEL_OF_QUAL LEVEL_OF_QUAL_ID, PD.MILITARY_SERVICE_REG, PD.VETERAN, IGS_EN_GEN_003.GET_STAFF_IND(p.party_id) STAFF_MEMBER_IND, PIT.PERSON_ID_TYPE, PIT.API_PERSON_ID, 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, P.CREATED_BY, P.CREATION_DATE, P.LAST_UPDATED_BY, P.LAST_UPDATE_DATE, P.LAST_UPDATE_LOGIN, P.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM HZ_PARTIES P, IGS_PE_PERSON_BASE_V PP, IGS_PE_HZ_PARTIES PD, FND_LOOKUP_VALUES LK, FND_LOOKUP_VALUES LK1, IGS_PE_PERSON_ID_TYPE_V PIT WHERE P.PARTY_ID = PIT.PE_PERSON_ID(+) AND P.PARTY_ID = PP.PERSON_ID AND P.PARTY_ID = PD.PARTY_ID(+) AND PP.GENDER = LK.LOOKUP_CODE(+) AND LK.LOOKUP_TYPE(+) = 'HZ_GENDER' AND LK.VIEW_APPLICATION_ID(+) = 222 AND LK.SECURITY_GROUP_ID (+)= 0 AND LK.LANGUAGE(+) = USERENV('LANG') AND P.PERSON_PRE_NAME_ADJUNCT = LK1.LOOKUP_CODE(+) AND LK1.LOOKUP_TYPE(+) = 'CONTACT_TITLE' AND LK1.LANGUAGE(+) = USERENV('LANG') AND LK1.VIEW_APPLICATION_ID(+) =222 AND LK1.SECURITY_GROUP_ID(+) = 0

View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_LAST_NAME SURNAME
, P.PERSON_FIRST_NAME GIVEN_NAMES
, P.PERSON_NAME_SUFFIX SUFFIX
, P.PERSON_MIDDLE_NAME MIDDLE_NAME
, P.PERSON_PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, LK1.MEANING PRE_NAME_ADJUNCT_MEANING
, PP.GENDER SEX
, LK.MEANING SEX_MEANING
, P.PERSON_TITLE TITLE
, DECODE(PP.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y') DECEASED_IND
, PP.DATE_OF_DEATH DECEASED_DATE
, PD.ARCHIVE_EXCLUSION_IND
, PD.ARCHIVE_DT
, PD.PURGE_EXCLUSION_IND
, PD.PURGE_DT
, PP.BIRTH_DATE BIRTH_DT
, P.EMAIL_ADDRESS EMAIL_ADDR
, P.SALUTATION
, P.KNOWN_AS PREFERRED_GIVEN_NAME
, IGS_EN_GEN_003.ENRP_GET_ENCMBRD_IND(P.PARTY_ID) ENCUMBERED_IND
, PD.PROOF_OF_INS
, PD.PROOF_OF_IMMU
, PD.ORACLE_USERNAME
, PD.LEVEL_OF_QUAL LEVEL_OF_QUAL_ID
, PD.MILITARY_SERVICE_REG
, PD.VETERAN
, IGS_EN_GEN_003.GET_STAFF_IND(P.PARTY_ID) STAFF_MEMBER_IND
, PIT.PERSON_ID_TYPE
, PIT.API_PERSON_ID
, 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
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
, P.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM HZ_PARTIES P
, IGS_PE_PERSON_BASE_V PP
, IGS_PE_HZ_PARTIES PD
, FND_LOOKUP_VALUES LK
, FND_LOOKUP_VALUES LK1
, IGS_PE_PERSON_ID_TYPE_V PIT
WHERE P.PARTY_ID = PIT.PE_PERSON_ID(+)
AND P.PARTY_ID = PP.PERSON_ID
AND P.PARTY_ID = PD.PARTY_ID(+)
AND PP.GENDER = LK.LOOKUP_CODE(+)
AND LK.LOOKUP_TYPE(+) = 'HZ_GENDER'
AND LK.VIEW_APPLICATION_ID(+) = 222
AND LK.SECURITY_GROUP_ID (+)= 0
AND LK.LANGUAGE(+) = USERENV('LANG')
AND P.PERSON_PRE_NAME_ADJUNCT = LK1.LOOKUP_CODE(+)
AND LK1.LOOKUP_TYPE(+) = 'CONTACT_TITLE'
AND LK1.LANGUAGE(+) = USERENV('LANG')
AND LK1.VIEW_APPLICATION_ID(+) =222
AND LK1.SECURITY_GROUP_ID(+) = 0