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_IMP_INT_DEDUP_RESULTS

Object Details

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

The HZ_IMP_INT_DEDEUP_RESULTS table stores the set of duplicates identified as part of the duplicate identification of interface tables. Each set is identified by a unique "winner" record that should remain if the other duplicates in the set are removed or merged into the winner record. 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_IMP_INT_DEDUP_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(15)	Yes	Interface batch identifier
WINNER_RECORD_OSR	VARCHAR2	(255)	Yes	Source identifier of the winner record in the interface tables
WINNER_RECORD_OS	VARCHAR2	(30)	Yes	Source system of the winner record in the interface tables
DUP_RECORD_OSR	VARCHAR2	(255)	Yes	Source identifier of the duplicate record in the interface tables
DUP_RECORD_OS	VARCHAR2	(30)	Yes	Source system of the duplicate record in the interface tables
DETAIL_PARTY_OSR	VARCHAR2	(255)		Source identifier of the party in the interface table that the duplicate detail record belongs to
DETAIL_PARTY_OS	VARCHAR2	(30)		Source system of the party in the interface table that the duplicate detail record belongs to
ENTITY	VARCHAR2	(30)		Duplicate entity.PARTIES, PARTY_SITES, CONTACTS, or CONTACT_POINTS
SCORE	NUMBER			Match score
DUP_CREATION_DATE	DATE			Creation date of duplicate record
DUP_LAST_UPDATE_DATE	DATE			Last update date of duplicate record
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column

Query Text

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


SELECT BATCH_ID
,      WINNER_RECORD_OSR
,      WINNER_RECORD_OS
,      DUP_RECORD_OSR
,      DUP_RECORD_OS
,      DETAIL_PARTY_OSR
,      DETAIL_PARTY_OS
,      ENTITY
,      SCORE
,      DUP_CREATION_DATE
,      DUP_LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
FROM AR.HZ_IMP_INT_DEDUP_RESULTS;

Dependencies

[top of page]

AR.HZ_IMP_INT_DEDUP_RESULTS does not reference any database object

AR.HZ_IMP_INT_DEDUP_RESULTS is referenced by following:

AR: HZ_IMP_INT_DEDUP_RESULTS#