eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGS_PE_DUP_MATCHES_P_V

Object Details

Object Name:	IGS_PE_DUP_MATCHES_P_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_PE_DUP_MATCHES_P_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

IGS_PE_DUP_MATCHES_P_V is used for the duplicate information about persons

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person identifier
SURNAME	VARCHAR2	(150)		Surname of the person
SURNAME_5_CHAR	VARCHAR2	(0)		Obsolete
GIVEN_NAMES	VARCHAR2	(150)		Given name of the person
GIVEN_NAME_1_CHAR	VARCHAR2	(0)		Given name of the person
SEX	VARCHAR2	(30)		Sex of the person
BIRTH_DT	DATE			Birth date of the person
ETHNIC_ORIGIN	VARCHAR2	(60)		Ethnic origin of the person
PREF_ALTERNATE_ID	VARCHAR2	(20)		Preferable alternate identifier
STATUS	VARCHAR2	(1)	Yes	Party status flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      SURNAME
,      SURNAME_5_CHAR
,      GIVEN_NAMES
,      GIVEN_NAME_1_CHAR
,      SEX
,      BIRTH_DT
,      ETHNIC_ORIGIN
,      PREF_ALTERNATE_ID
,      STATUS
FROM APPS.IGS_PE_DUP_MATCHES_P_V;

Dependencies

[top of page]

APPS.IGS_PE_DUP_MATCHES_P_V references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_PE_PERSON_ID_TYPE_V

APPS.IGS_PE_DUP_MATCHES_P_V is not referenced by any database object