VIEW: APPS.IGS_PE_DUP_MATCHES_PP_V

Source

View Text - Preformatted

SELECT P.PARTY_ID PERSON_ID, P.PARTY_NUMBER PERSON_NUMBER, P.PERSON_LAST_NAME SURNAME, NULL SURNAME_5_CHAR, P.PERSON_FIRST_NAME GIVEN_NAMES, SUBSTR(P.PERSON_FIRST_NAME, 1, 1) GIVEN_NAME_1_CHAR, S.GENDER SEX, S.DATE_OF_BIRTH BIRTH_DT, PIT2.API_PERSON_ID PREF_ALTERNATE_ID, API.API_PERSON_ID, API.PERSON_ID_TYPE, NULL, S.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID, P.STATUS, API.START_DT API_START_DATE, API.END_DT API_END_DATE FROM HZ_PARTIES P, IGS_PE_ALT_PERS_ID API, HZ_PERSON_PROFILES S, IGS_PE_PERSON_ID_TYPE_V PIT2 WHERE P.PARTY_ID = API.PE_PERSON_ID (+) AND P.PARTY_ID = S.PARTY_ID AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE AND NVL(S.EFFECTIVE_END_DATE, SYSDATE) AND P.PARTY_ID = PIT2.PE_PERSON_ID(+)

View Text - HTML Formatted

SELECT P.PARTY_ID PERSON_ID
, P.PARTY_NUMBER PERSON_NUMBER
, P.PERSON_LAST_NAME SURNAME
, NULL SURNAME_5_CHAR
, P.PERSON_FIRST_NAME GIVEN_NAMES
, SUBSTR(P.PERSON_FIRST_NAME
, 1
, 1) GIVEN_NAME_1_CHAR
, S.GENDER SEX
, S.DATE_OF_BIRTH BIRTH_DT
, PIT2.API_PERSON_ID PREF_ALTERNATE_ID
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, NULL
, S.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, P.STATUS
, API.START_DT API_START_DATE
, API.END_DT API_END_DATE
FROM HZ_PARTIES P
, IGS_PE_ALT_PERS_ID API
, HZ_PERSON_PROFILES S
, IGS_PE_PERSON_ID_TYPE_V PIT2
WHERE P.PARTY_ID = API.PE_PERSON_ID (+)
AND P.PARTY_ID = S.PARTY_ID
AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE
AND NVL(S.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PIT2.PE_PERSON_ID(+)