VIEW: APPS.IGS_PE_DUP_PAIRS_V

Source

View Text - Preformatted

SELECT DP.ROWID ROW_ID, DP.DUPLICATE_PAIR_ID, DP.BATCH_ID, DP.ACTUAL_PERSON_ID, P1.PERSON_NUMBER ACTUAL_PERSON_NUMBER, DP.DUPLICATE_PERSON_ID, P2.PERSON_NUMBER DUPLICATE_PERSON_NUMBER, DP.OBSOLETE_ID, DP.MATCH_CATEGORY, DP.MATCH_SET_ID, DP.DUP_STATUS, DP.ADDRESS_TYPE ADDR_TYPE, DP.LOCATION_ID LOCATION_ID, DP.PERSON_ID_TYPE, (P1.SURNAME || ', ' || INITCAP(P1.TITLE) || ' ' || P1.GIVEN_NAMES) ACT_PERSON_NAME, (P2.SURNAME || ', ' || INITCAP(P2.TITLE) || ' ' || P2.GIVEN_NAMES) DUP_PERSON_NAME, MS.MATCH_SET_NAME, DP.CREATED_BY, DP.CREATION_DATE, DP.LAST_UPDATED_BY, DP.LAST_UPDATE_DATE, DP.LAST_UPDATE_LOGIN FROM IGS_PE_DUP_PAIRS DP, IGS_PE_PERSON P1, IGS_PE_PERSON P2, IGS_PE_MATCH_SETS MS WHERE DP.ACTUAL_PERSON_ID = P1.PERSON_ID AND DP.DUPLICATE_PERSON_ID = P2.PERSON_ID AND DP.MATCH_SET_ID = MS.MATCH_SET_ID

View Text - HTML Formatted

SELECT DP.ROWID ROW_ID
, DP.DUPLICATE_PAIR_ID
, DP.BATCH_ID
, DP.ACTUAL_PERSON_ID
, P1.PERSON_NUMBER ACTUAL_PERSON_NUMBER
, DP.DUPLICATE_PERSON_ID
, P2.PERSON_NUMBER DUPLICATE_PERSON_NUMBER
, DP.OBSOLETE_ID
, DP.MATCH_CATEGORY
, DP.MATCH_SET_ID
, DP.DUP_STATUS
, DP.ADDRESS_TYPE ADDR_TYPE
, DP.LOCATION_ID LOCATION_ID
, DP.PERSON_ID_TYPE
, (P1.SURNAME || '
, ' || INITCAP(P1.TITLE) || ' ' || P1.GIVEN_NAMES) ACT_PERSON_NAME
, (P2.SURNAME || '
, ' || INITCAP(P2.TITLE) || ' ' || P2.GIVEN_NAMES) DUP_PERSON_NAME
, MS.MATCH_SET_NAME
, DP.CREATED_BY
, DP.CREATION_DATE
, DP.LAST_UPDATED_BY
, DP.LAST_UPDATE_DATE
, DP.LAST_UPDATE_LOGIN
FROM IGS_PE_DUP_PAIRS DP
, IGS_PE_PERSON P1
, IGS_PE_PERSON P2
, IGS_PE_MATCH_SETS MS
WHERE DP.ACTUAL_PERSON_ID = P1.PERSON_ID
AND DP.DUPLICATE_PERSON_ID = P2.PERSON_ID
AND DP.MATCH_SET_ID = MS.MATCH_SET_ID