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: OKC.OKC_WORD_SYNC_T

Object Details

Object Name:	OKC_WORD_SYNC_T
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_WORD_SYNC_T
Subobject Name:
Status:	VALID

Temporary table to store the contract document and clauses in word format

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKC_WORD_SYNC_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID DOC_ID DOC_TYPE
SYS_IL0000523182C00004$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000523182C00007$$	LOB	UNIQUE	APPS_TS_TX_DATA
OKC_WORD_SYNC_T_NU1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOC_TYPE DOC_ID ACTION

Columns

Name	Datatype	Length	Comments
ID	NUMBER		This is to store the id for each row in this table
DOC_ID	NUMBER		Stores the id of the businnes document
DOC_TYPE	VARCHAR2	(100)	Stores the type of the business document
BLOB_DATA	BLOB	(4000)	This column stores the WML content of the document or clause
CAT_ID	NUMBER		This column stores the id in okc_k_articles_b table
ACTION	VARCHAR2	(30)	This column specifies the status of the record during Word upload
CLOB_DATA	CLOB	(4000)	This stores the content of the clause text in CLOB format

Query Text

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


SELECT ID
,      DOC_ID
,      DOC_TYPE
,      BLOB_DATA
,      CAT_ID
,      ACTION
,      CLOB_DATA
FROM OKC.OKC_WORD_SYNC_T;

Dependencies

[top of page]

OKC.OKC_WORD_SYNC_T does not reference any database object

OKC.OKC_WORD_SYNC_T is referenced by following:

OKC: OKC_WORD_SYNC_T#