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: OE.SO_NOTE_REPLICATION

Object Details

Object Name:	SO_NOTE_REPLICATION
Object Type:	TABLE
Owner:	OE
FND Design Data:	OE.SO_NOTE_REPLICATION
Subobject Name:
Status:	VALID

SO_NOTE_REPLICATION temporarily stores information about rows in
FND_DOCUMENTS and FND_ATTACHED_DOCUMENTS, and determines how
information in the latter tables should be replicated into SO_NOTES
and SO_NOTE_REFERENCES, respectively.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
SOURCE_ID	NUMBER		Document or attachment being replicated
DATATYPE_ID	NUMBER		Data type of document being replicated
SOURCE_CODE	VARCHAR2	(30)	Source of replication (document, attachment, note or note reference)
OPERATION_CODE	VARCHAR2	(30)	Replication operation (insert, update or delete)
VERSION	VARCHAR2	(30)	Version of document or attachment

Query Text

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


SELECT SOURCE_ID
,      DATATYPE_ID
,      SOURCE_CODE
,      OPERATION_CODE
,      VERSION
FROM OE.SO_NOTE_REPLICATION;

Dependencies

[top of page]

OE.SO_NOTE_REPLICATION does not reference any database object

OE.SO_NOTE_REPLICATION is referenced by following:

APPS: SO_NOTE_REPLICATION