VIEW: APPS.IGS_PE_PERSON_LKUPV_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, PP.GENDER SEX, L1.MEANING SEX_MEANING, P.PERSON_TITLE TITLE, IGS_EN_GEN_003.Get_Staff_Ind(p.party_id) STAFF_MEMBER_IND, DECODE(PP.DATE_OF_DEATH, NULL, NVL(PD.DECEASED_IND, 'N'), 'Y') DECEASED_IND, PD.ARCHIVE_EXCLUSION_IND ARCHIVE_EXCLUSION_IND, PD.ARCHIVE_DT ARCHIVE_DT, PD.PURGE_EXCLUSION_IND PURGE_EXCLUSION_IND, PD.PURGE_DT PURGE_DT, PP.DATE_OF_BIRTH BIRTH_DT, P.SALUTATION SALUTATION, PD.ORACLE_USERNAME , P.KNOWN_AS PREFERRED_GIVEN_NAME, P.EMAIL_ADDRESS EMAIL_ADDR, P.CREATED_BY CREATED_BY, P.CREATION_DATE CREATION_DATE, P.LAST_UPDATED_BY LAST_UPDATED_BY, P.LAST_UPDATE_DATE LAST_UPDATE_DATE, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, P.REQUEST_ID REQUEST_ID, P.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, P.PROGRAM_ID PROGRAM_ID, P.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE FROM HZ_PARTIES P, IGS_PE_HZ_PARTIES PD, HZ_PERSON_PROFILES PP, FND_LOOKUP_VALUES L1 WHERE P.PARTY_ID = PD.PARTY_ID (+) AND P.PARTY_ID = PP.PARTY_ID AND PP.CONTENT_SOURCE_TYPE = 'USER_ENTERED' AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE AND NVL(PP.EFFECTIVE_END_DATE,SYSDATE) AND PP.GENDER = L1.LOOKUP_CODE (+) AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER' AND L1.view_application_id(+) = 222 AND L1.SECURITY_GROUP_ID (+)= 0 AND L1.LANGUAGE(+) = USERENV('LANG')

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
, PP.GENDER SEX
, L1.MEANING SEX_MEANING
, P.PERSON_TITLE TITLE
, IGS_EN_GEN_003.GET_STAFF_IND(P.PARTY_ID) STAFF_MEMBER_IND
, DECODE(PP.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y') DECEASED_IND
, PD.ARCHIVE_EXCLUSION_IND ARCHIVE_EXCLUSION_IND
, PD.ARCHIVE_DT ARCHIVE_DT
, PD.PURGE_EXCLUSION_IND PURGE_EXCLUSION_IND
, PD.PURGE_DT PURGE_DT
, PP.DATE_OF_BIRTH BIRTH_DT
, P.SALUTATION SALUTATION
, PD.ORACLE_USERNAME
, P.KNOWN_AS PREFERRED_GIVEN_NAME
, P.EMAIL_ADDRESS EMAIL_ADDR
, P.CREATED_BY CREATED_BY
, P.CREATION_DATE CREATION_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.REQUEST_ID REQUEST_ID
, P.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, P.PROGRAM_ID PROGRAM_ID
, P.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM HZ_PARTIES P
, IGS_PE_HZ_PARTIES PD
, HZ_PERSON_PROFILES PP
, FND_LOOKUP_VALUES L1
WHERE P.PARTY_ID = PD.PARTY_ID (+)
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)
AND PP.GENDER = L1.LOOKUP_CODE (+)
AND L1.LOOKUP_TYPE (+) = 'HZ_GENDER'
AND L1.VIEW_APPLICATION_ID(+) = 222
AND L1.SECURITY_GROUP_ID (+)= 0
AND L1.LANGUAGE(+) = USERENV('LANG')