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]

TABLE: IGS.IGS_PE_DUP_PAIRS_ALL

Object Details

Object Name:	IGS_PE_DUP_PAIRS_ALL
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PE_DUP_PAIRS_ALL
Subobject Name:
Status:	VALID

IGS_PE_DUP_PAIRS_ALL describes the duplicate pair of persons in the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PEDUP_PAIRS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DUPLICATE_PAIR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DUPLICATE_PAIR_ID	NUMBER	(15)	Yes	Unique identifier for the duplicate pair
BATCH_ID	NUMBER	(15)	Yes	Identifier of the batch run
MATCH_SET_ID	NUMBER	(15)	Yes	Identifier of the duplicate match criteria selected for this batch run
ACTUAL_PERSON_ID	NUMBER	(15)	Yes	Person Identifier for that duplicate person is found
DUPLICATE_PERSON_ID	NUMBER	(15)	Yes	Identifier of the duplicate person
OBSOLETE_ID	NUMBER	(15)		Contains antiquated person identifier
MATCH_CATEGORY	VARCHAR2	(1)	Yes	Type of match whether exact match or partial match
DUP_STATUS	VARCHAR2	(30)	Yes	Status of the duplicate pair
ADDRESS_TYPE	VARCHAR2	(30)		Address type of duplicate address
LOCATION_ID	NUMBER	(15)		Location identifier of the duplicate pair
PERSON_ID_TYPE	VARCHAR2	(30)		Person ID type of the duplicate alternate identifier of the duplicate person
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Request Identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of the last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program Identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last Update Date of this record update by concurrent program
ORG_ID	NUMBER	(15)		Operating Unit Identifier

Query Text

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


SELECT DUPLICATE_PAIR_ID
,      BATCH_ID
,      MATCH_SET_ID
,      ACTUAL_PERSON_ID
,      DUPLICATE_PERSON_ID
,      OBSOLETE_ID
,      MATCH_CATEGORY
,      DUP_STATUS
,      ADDRESS_TYPE
,      LOCATION_ID
,      PERSON_ID_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ORG_ID
FROM IGS.IGS_PE_DUP_PAIRS_ALL;

Dependencies

[top of page]

IGS.IGS_PE_DUP_PAIRS_ALL does not reference any database object

IGS.IGS_PE_DUP_PAIRS_ALL is referenced by following:

APPS: IGS_PE_DUP_PAIRS_ALL