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_DQM_SYNC_INTERFACE

Object Details

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

The HZ_DQM_SYNC_INTERFACE table stores the list of parties,
party sites, contacts, and contact points that are created or updated by the
API. The contents of this table are used to synchronize the staged schema with
the base tables. The staged schema is used for Data Quality Management.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_DQM_SYNC_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENTITY PARTY_ID RECORD_ID
HZ_DQM_SYNC_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REALTIME_SYNC_FLAG
HZ_DQM_SYNC_INTERFACE_N3	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PARTY_ID
HZ_DQM_SYNC_INTERFACE_N4	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RECORD_ID ENTITY
HZ_DQM_SYNC_INTERFACE_N5	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	SYNC_INTERFACE_NUM
HZ_DQM_SYNC_INTERFACE_N6	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	IMPORT_OSR
HZ_DQM_SYNC_INTERFACE_N7	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ENTITY SYNC_INTERFACE_NUM OPERATION STAGED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	ID of the party that has been created or updated
RECORD_ID	NUMBER			ID of the detail that has been created or updated. This column can contain the PARTY_SITE_ID or ORG_CONTACT_ID or CONTACT_POINT_ID.
ENTITY	VARCHAR2	(30)	Yes	The logical entity that has been created or updated
OPERATION	VARCHAR2	(1)	Yes	Flag to indicate if the operation was create or update. 'C' for Create, and 'U' for update.
STAGED_FLAG	VARCHAR2	(1)	Yes	Indicates if this record has been synchronized
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ORG_CONTACT_ID	NUMBER	(15)		Identifier for Organization Contact Record. Foreign Key to HZ_ORG_CONTACTS
PARTY_SITE_ID	NUMBER	(15)		Identifier for party site record. Foreign Key to HZ_PARTY_SITES
REALTIME_SYNC_FLAG	VARCHAR2	(1)		Y or N indicates whether or not the record is to be immediately synchronized with the staged schema by the DQM workflow.
ERROR_DATA	VARCHAR2	(2000)		Error text for the records from which an error arose during synchronization.
IMPORT_OSR	VARCHAR2	(240)		Party source identifier of the imported record to be synchronized
SYNC_INTERFACE_NUM	NUMBER			Sequence generated number for partitioning work among parallel workers during synchronization

Query Text

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


SELECT PARTY_ID
,      RECORD_ID
,      ENTITY
,      OPERATION
,      STAGED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ORG_CONTACT_ID
,      PARTY_SITE_ID
,      REALTIME_SYNC_FLAG
,      ERROR_DATA
,      IMPORT_OSR
,      SYNC_INTERFACE_NUM
FROM AR.HZ_DQM_SYNC_INTERFACE;

Dependencies

[top of page]

AR.HZ_DQM_SYNC_INTERFACE does not reference any database object

AR.HZ_DQM_SYNC_INTERFACE is referenced by following:

APPS: HZ_DQM_SYNC_INTERFACE