VIEW: APPS.IGS_AD_IMP_MATCHES_P_V

Source

View Text - Preformatted

SELECT IP.ROWID ROW_ID, IP.INTERFACE_ID, IP.BATCH_ID, IP.PERSON_ID, IP.GIVEN_NAMES, SUBSTR(IP.GIVEN_NAMES, 1, 1) GIVEN_NAME_1_CHAR, IP.SURNAME, NULL SURNAME_5_CHAR, IP.PREFERRED_GIVEN_NAME, IP.SEX, IP.BIRTH_DT, IP.PREF_ALTERNATE_ID, SI.ETHNIC_ORIGIN, IP.CREATED_BY CREATED_BY, IP.CREATION_DATE CREATION_DATE, IP.LAST_UPDATED_BY LAST_UPDATED_BY, IP.LAST_UPDATE_DATE LAST_UPDATE_DATE, IP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, IP.REQUEST_ID REQUEST_ID, IP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, IP.PROGRAM_ID PROGRAM_ID, IP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE FROM IGS_AD_INTERFACE IP, IGS_AD_STAT_INT SI WHERE IP.INTERFACE_ID = SI.INTERFACE_ID(+)

View Text - HTML Formatted

SELECT IP.ROWID ROW_ID
, IP.INTERFACE_ID
, IP.BATCH_ID
, IP.PERSON_ID
, IP.GIVEN_NAMES
, SUBSTR(IP.GIVEN_NAMES
, 1
, 1) GIVEN_NAME_1_CHAR
, IP.SURNAME
, NULL SURNAME_5_CHAR
, IP.PREFERRED_GIVEN_NAME
, IP.SEX
, IP.BIRTH_DT
, IP.PREF_ALTERNATE_ID
, SI.ETHNIC_ORIGIN
, IP.CREATED_BY CREATED_BY
, IP.CREATION_DATE CREATION_DATE
, IP.LAST_UPDATED_BY LAST_UPDATED_BY
, IP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, IP.REQUEST_ID REQUEST_ID
, IP.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, IP.PROGRAM_ID PROGRAM_ID
, IP.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_AD_INTERFACE IP
, IGS_AD_STAT_INT SI
WHERE IP.INTERFACE_ID = SI.INTERFACE_ID(+)