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_SH_SYNC_INTERFACE

Object Details

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

Stores the list of entities that have been created or updated by the DQM API since the DQM Shadow Staging Program concurrent program was last run.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_DQM_SH_SYNC_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY SYNC_INTERFACE_NUM OPERATION STAGED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party identifier created or updated
RECORD_ID	NUMBER			Identifier of the detail created or updated. This column can containPARTY_SITE_ID, ORG_CONTACT_ID, or CONTACT_POINT_ID.
ENTITY	VARCHAR2	(30)	Yes	Logical entity created or updated
OPERATION	VARCHAR2	(1)	Yes	Flag to indicate the operation, 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. Foreign key to FND_USER.USER_ID
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column. Foreign key to FND_LOGINS.LOGIN_ID
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column. 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 the record is to be immediately synchronized with the staged schema by the DQM workflow
ERROR_DATA	VARCHAR2	(2000)		Error text for records that produced errors 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_SH_SYNC_INTERFACE;

Dependencies

[top of page]

AR.HZ_DQM_SH_SYNC_INTERFACE does not reference any database object

AR.HZ_DQM_SH_SYNC_INTERFACE is referenced by following:

AR: HZ_DQM_SH_SYNC_INTERFACE#