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: AR.HZ_DUP_RESULTS

Object Details

Object Name:	HZ_DUP_RESULTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_DUP_RESULTS
Subobject Name:
Status:	VALID

The HZ_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables. The table includes information about the potential from and to parties. Data in this table is only used for the duration of the duplicate identification process, and is emptied at the end of it. Duplicate identification of interface tables resolves duplicates before you import the records into the TCA Registry

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_DUP_RESULTS_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TID FID SCORE
HZ_DUP_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORD_FID ORD_TID

Columns

Name	Datatype	Length	Mandatory	Comments
FID	NUMBER	(15)	Yes	Source party identifier from TCA
TID	NUMBER	(15)	Yes	Duplicate party identifier from TCA
ORD_FID	NUMBER	(15)		Lesser of the from and to party identifiers
ORD_TID	NUMBER	(15)		Greater of the from and to party identifiers
SCORE	NUMBER			Match score

Query Text

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


SELECT FID
,      TID
,      ORD_FID
,      ORD_TID
,      SCORE
FROM AR.HZ_DUP_RESULTS;

Dependencies

[top of page]

AR.HZ_DUP_RESULTS does not reference any database object

AR.HZ_DUP_RESULTS is referenced by following:

APPS: HZ_DUP_RESULTS