VIEW: APPS.IGS_PE_PAIR_ACT_PERSON_V

Source

View Text - Preformatted

SELECT DP.ROWID ROW_ID, P.PERSON_ID, P.SURNAME, NULL SURNAME_5_CHAR, P.GIVEN_NAMES, SUBSTR(P.GIVEN_NAMES,1,1) GIVEN_NAME_1_CHAR, P.SEX, P.BIRTH_DT, P.API_PERSON_ID PREF_ALTERNATE_ID, S.ETHNIC_ORIGIN, DP.ACTUAL_PERSON_ID, P.PERSON_NUMBER ACTUAL_PERSON_NUMBER, DP.DUPLICATE_PERSON_ID, DP.DUPLICATE_PAIR_ID, DP.BATCH_ID, DP.DUP_STATUS, DP.MATCH_SET_ID, DP.MATCH_CATEGORY, DP.ADDRESS_TYPE ADDR_TYPE, DP.LOCATION_ID, DP.PERSON_ID_TYPE, DP.OBSOLETE_ID, DECODE (DP.OBSOLETE_ID, DP.ACTUAL_PERSON_ID, 'Y', DP.DUPLICATE_PERSON_ID, 'N', 'N') OBSOLETE , P.CREATED_BY, P.CREATION_DATE, P.LAST_UPDATED_BY, P.LAST_UPDATE_DATE, P.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_V P, IGS_PE_STAT_V S, IGS_PE_DUP_PAIRS DP WHERE DP.ACTUAL_PERSON_ID = P.PERSON_ID AND P.PERSON_ID = S.PERSON_ID (+)

View Text - HTML Formatted

SELECT DP.ROWID ROW_ID
, P.PERSON_ID
, P.SURNAME
, NULL SURNAME_5_CHAR
, P.GIVEN_NAMES
, SUBSTR(P.GIVEN_NAMES
, 1
, 1) GIVEN_NAME_1_CHAR
, P.SEX
, P.BIRTH_DT
, P.API_PERSON_ID PREF_ALTERNATE_ID
, S.ETHNIC_ORIGIN
, DP.ACTUAL_PERSON_ID
, P.PERSON_NUMBER ACTUAL_PERSON_NUMBER
, DP.DUPLICATE_PERSON_ID
, DP.DUPLICATE_PAIR_ID
, DP.BATCH_ID
, DP.DUP_STATUS
, DP.MATCH_SET_ID
, DP.MATCH_CATEGORY
, DP.ADDRESS_TYPE ADDR_TYPE
, DP.LOCATION_ID
, DP.PERSON_ID_TYPE
, DP.OBSOLETE_ID
, DECODE (DP.OBSOLETE_ID
, DP.ACTUAL_PERSON_ID
, 'Y'
, DP.DUPLICATE_PERSON_ID
, 'N'
, 'N') OBSOLETE
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_V P
, IGS_PE_STAT_V S
, IGS_PE_DUP_PAIRS DP
WHERE DP.ACTUAL_PERSON_ID = P.PERSON_ID
AND P.PERSON_ID = S.PERSON_ID (+)