View: IGS_PE_DUP_PERSON_V

Product:	IGS - Student System
Description:
Implementation/DBA Data:	APPS.IGS_PE_DUP_PERSON_V

View Text

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')

Columns