VIEW: APPS.IGS_PE_DUP_MATCHES_PRIM_PA_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, PP.GENDER SEX, PP.DATE_OF_BIRTH BIRTH_DT, PIT.API_PERSON_ID PREF_ALTERNATE_ID, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID, REPLACE (P.ADDRESS1,' ','')|| REPLACE (P.ADDRESS2,' ','')|| REPLACE (P.ADDRESS3,' ','')|| REPLACE (P.ADDRESS4,' ','') CONCT_ADDRESS_LINES, REPLACE (P.ADDRESS1,' ','') ADDR_LINE_1, REPLACE (P.ADDRESS2,' ','') ADDR_LINE_2, REPLACE (P.ADDRESS3,' ','') ADDR_LINE_3, REPLACE (P.ADDRESS4,' ','') ADDR_LINE_4, P.CITY, P.STATE, P.PROVINCE, P.COUNTY, P.COUNTRY, P.POSTAL_CODE POSTCODE, P.STATUS FROM HZ_PARTIES P, IGS_PE_PERSON_ID_TYPE_V PIT, 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) AND P.PARTY_ID = PIT.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
, PP.GENDER SEX
, PP.DATE_OF_BIRTH BIRTH_DT
, PIT.API_PERSON_ID PREF_ALTERNATE_ID
, PP.DECLARED_ETHNICITY ETHNIC_ORIGIN_ID
, REPLACE (P.ADDRESS1
, ' '
, '')|| REPLACE (P.ADDRESS2
, ' '
, '')|| REPLACE (P.ADDRESS3
, ' '
, '')|| REPLACE (P.ADDRESS4
, ' '
, '') CONCT_ADDRESS_LINES
, REPLACE (P.ADDRESS1
, ' '
, '') ADDR_LINE_1
, REPLACE (P.ADDRESS2
, ' '
, '') ADDR_LINE_2
, REPLACE (P.ADDRESS3
, ' '
, '') ADDR_LINE_3
, REPLACE (P.ADDRESS4
, ' '
, '') ADDR_LINE_4
, P.CITY
, P.STATE
, P.PROVINCE
, P.COUNTY
, P.COUNTRY
, P.POSTAL_CODE POSTCODE
, P.STATUS
FROM HZ_PARTIES P
, IGS_PE_PERSON_ID_TYPE_V PIT
, 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)
AND P.PARTY_ID = PIT.PE_PERSON_ID (+)