VIEW: APPS.IGS_PE_DUP_PERSON_V

Source

View Text - Preformatted

SELECT P.ROW_ID ROW_ID, P.PERSON_ID, P.PERSON_NUMBER, P.LAST_NAME SURNAME, NULL SURNAME_5_CHAR, P.FIRST_NAME GIVEN_NAMES, SUBSTR(P.FIRST_NAME, 1, 1) GIVEN_NAMES_1_CHAR, API.API_PERSON_ID, API.API_PERSON_ID PREF_ALTERNATE_ID, P.GENDER SEX, LK.MEANING SEX_MEANING, P.BIRTH_DATE BIRTH_DT, U1.USER_NAME CREATED_BY_USER_NAME, U2.USER_NAME LAST_UPDATED_BY_USER_NAME, P.CREATED_BY, P.CREATION_DATE, P.LAST_UPDATED_BY, P.LAST_UPDATE_DATE, P.LAST_UPDATE_LOGIN FROM IGS_PE_PERSON_BASE_V P, IGS_PE_PERSON_ID_TYPE_V API, FND_LOOKUP_VALUES LK, FND_USER U1, FND_USER U2 WHERE p.person_id = api.pe_person_id (+) AND P.CREATED_BY = U1.USER_ID AND P.LAST_UPDATED_BY = U2.USER_ID AND p.gender = lk.lookup_code (+) AND lk.lookup_type(+) = 'HZ_GENDER' AND lk.view_application_id(+) = 222 AND lk.SECURITY_GROUP_ID(+) = 0 AND LK.LANGUAGE(+) = USERENV('LANG')

View Text - HTML Formatted

SELECT P.ROW_ID ROW_ID
, P.PERSON_ID
, P.PERSON_NUMBER
, P.LAST_NAME SURNAME
, NULL SURNAME_5_CHAR
, P.FIRST_NAME GIVEN_NAMES
, SUBSTR(P.FIRST_NAME
, 1
, 1) GIVEN_NAMES_1_CHAR
, API.API_PERSON_ID
, API.API_PERSON_ID PREF_ALTERNATE_ID
, P.GENDER SEX
, LK.MEANING SEX_MEANING
, P.BIRTH_DATE BIRTH_DT
, U1.USER_NAME CREATED_BY_USER_NAME
, U2.USER_NAME LAST_UPDATED_BY_USER_NAME
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
FROM IGS_PE_PERSON_BASE_V P
, IGS_PE_PERSON_ID_TYPE_V API
, FND_LOOKUP_VALUES LK
, FND_USER U1
, FND_USER U2
WHERE P.PERSON_ID = API.PE_PERSON_ID (+)
AND P.CREATED_BY = U1.USER_ID
AND P.LAST_UPDATED_BY = U2.USER_ID
AND P.GENDER = LK.LOOKUP_CODE (+)
AND LK.LOOKUP_TYPE(+) = 'HZ_GENDER'
AND LK.VIEW_APPLICATION_ID(+) = 222
AND LK.SECURITY_GROUP_ID(+) = 0
AND LK.LANGUAGE(+) = USERENV('LANG')