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_PPA_V

Object Details

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

View Type

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

IGS_PE_MATCHES_PPA_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	(1)		Given name of the person
SEX	VARCHAR2	(30)		Sex of the person
BIRTH_DT	DATE			Birth date of the person
PREF_ALTERNATE_ID	VARCHAR2	(20)		Preferable alternate identifier
API_PERSON_ID	VARCHAR2	(20)		Altrenate person identifier
PERSON_ID_TYPE	VARCHAR2	(10)		Type of the person identifier
PREFERRED_IND	VARCHAR2	(0)		Flag indicates whether the person ID type is preferred or not
ETHNIC_ORIGIN	VARCHAR2	(60)		Ethnic origin of the person
ADDR_TYPE	VARCHAR2	(30)		Address type
LOCATION_ID	NUMBER	(15)		Location identifier
CONCT_ADDRESS_LINES	VARCHAR2	(960)		Concatenated Address Line 1-4
ADDR_LINE_1	VARCHAR2	(240)		Address line
ADDR_LINE_2	VARCHAR2	(240)		Address line
ADDR_LINE_3	VARCHAR2	(240)		Address line
ADDR_LINE_4	VARCHAR2	(240)		Address line
CITY	VARCHAR2	(60)		City of the address
STATE	VARCHAR2	(60)		State of the address
PROVINCE	VARCHAR2	(60)		Province of the address
COUNTY	VARCHAR2	(60)		County of the address
COUNTRY	VARCHAR2	(60)		Country of the address
POSTCODE	VARCHAR2	(60)		Postal code of the address
PARTY_SITE_ID	NUMBER	(15)		Party site identifier
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
,      SURNAME
,      SURNAME_5_CHAR
,      GIVEN_NAMES
,      GIVEN_NAME_1_CHAR
,      SEX
,      BIRTH_DT
,      PREF_ALTERNATE_ID
,      API_PERSON_ID
,      PERSON_ID_TYPE
,      PREFERRED_IND
,      ETHNIC_ORIGIN
,      ADDR_TYPE
,      LOCATION_ID
,      CONCT_ADDRESS_LINES
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTCODE
,      PARTY_SITE_ID
,      STATUS
,      API_START_DATE
,      API_END_DATE
FROM APPS.IGS_PE_DUP_MATCHES_PPA_V;

Dependencies

[top of page]

APPS.IGS_PE_DUP_MATCHES_PPA_V references the following:

APPS: HZ_LOCATIONS; HZ_PARTIES; HZ_PARTY_SITES; HZ_PARTY_SITE_USES; HZ_PERSON_PROFILES; IGS_PE_ALT_PERS_ID; IGS_PE_PERSON_ID_TYPE_V

APPS.IGS_PE_DUP_MATCHES_PPA_V is referenced by following:

APPS: IGS_PE_IDENTIFY_DUPS - show dependent code