eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.IGS_PE_DUP_MATCHES_PRIM_PPA_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, PIT.API_PERSON_ID PREF_ALTERNATE_ID, API.API_PERSON_ID, API.PERSON_ID_TYPE, S.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, 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 PIT WHERE P.PARTY_ID = S.PARTY_ID AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE AND NVL(S.EFFECTIVE_END_DATE,SYSDATE) AND P.PARTY_ID = PIT.PE_PERSON_ID (+) AND P.PARTY_ID = API.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
, PIT.API_PERSON_ID PREF_ALTERNATE_ID
, API.API_PERSON_ID
, API.PERSON_ID_TYPE
, S.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
, 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 PIT
WHERE P.PARTY_ID = S.PARTY_ID
AND SYSDATE BETWEEN S.EFFECTIVE_START_DATE
AND NVL(S.EFFECTIVE_END_DATE
, SYSDATE)
AND P.PARTY_ID = PIT.PE_PERSON_ID (+)
AND P.PARTY_ID = API.PE_PERSON_ID (+)