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_PRIM_PPA_V

Object Details

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

View Type

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

Contains data of a person and his primary address.This view is used in duplicate matching of person.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Unique identifier of a person
PERSON_NUMBER	VARCHAR2	(30)	Yes	Unique identification of a person
SURNAME	VARCHAR2	(150)		Surname
SURNAME_5_CHAR	VARCHAR2	(0)		Obsolete
GIVEN_NAMES	VARCHAR2	(150)		Given Name
GIVEN_NAME_1_CHAR	VARCHAR2	(1)		first character of given name
SEX	VARCHAR2	(30)		Gender
BIRTH_DT	DATE			Date of Birth
PREF_ALTERNATE_ID	VARCHAR2	(20)		Preffered alternate id
API_PERSON_ID	VARCHAR2	(20)		Alternate person ID
PERSON_ID_TYPE	VARCHAR2	(10)		Person ID type
ETHNIC_ORIGIN	VARCHAR2	(60)		Ethnic origin
CONCT_ADDRESS_LINES	VARCHAR2	(960)		Concatenated address lines
ADDR_LINE_1	VARCHAR2	(240)		Address line 1
ADDR_LINE_2	VARCHAR2	(240)		Address line 2
ADDR_LINE_3	VARCHAR2	(240)		Address line 3
ADDR_LINE_4	VARCHAR2	(240)		Address line 4
CITY	VARCHAR2	(60)		City
STATE	VARCHAR2	(60)		State
PROVINCE	VARCHAR2	(60)		Province
COUNTY	VARCHAR2	(60)		County
COUNTRY	VARCHAR2	(60)		Country
POSTCODE	VARCHAR2	(60)		Postcode
STATUS	VARCHAR2	(1)	Yes	Party status flag
API_START_DATE	DATE			Start Date of the Alternate Person ID
API_END_DATE	DATE			End Date of the Alternate Person ID

Query Text

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


SELECT PERSON_ID
,      PERSON_NUMBER
,      SURNAME
,      SURNAME_5_CHAR
,      GIVEN_NAMES
,      GIVEN_NAME_1_CHAR
,      SEX
,      BIRTH_DT
,      PREF_ALTERNATE_ID
,      API_PERSON_ID
,      PERSON_ID_TYPE
,      ETHNIC_ORIGIN
,      CONCT_ADDRESS_LINES
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTCODE
,      STATUS
,      API_START_DATE
,      API_END_DATE
FROM APPS.IGS_PE_DUP_MATCHES_PRIM_PPA_V;

Dependencies

[top of page]

APPS.IGS_PE_DUP_MATCHES_PRIM_PPA_V references the following:

APPS: HZ_PARTIES; HZ_PERSON_PROFILES; IGS_PE_ALT_PERS_ID; IGS_PE_PERSON_ID_TYPE_V

APPS.IGS_PE_DUP_MATCHES_PRIM_PPA_V is referenced by following:

APPS: IGS_PE_IDENTIFY_DUPS - show dependent code