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: ICX.ICX_CONTEXT_RESULTS_TEMP

Object Details

Object Name:	ICX_CONTEXT_RESULTS_TEMP
Object Type:	TABLE
Owner:	ICX
FND Design Data:	ICX.ICX_CONTEXT_RESULTS_TEMP
Subobject Name:
Status:	VALID

ICX_CONTEXT_RESULTS_TEMP is a temporary table which contains the
results of any Oracle ConText queries.
.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ICX_CONTEXT_RESULTS_TEMP_U1	NORMAL	UNIQUE	APPS_TS_NOLOGGING	CONID TEXTKEY TEXTKEY2

Columns

Name	Datatype	Length	Comments
TEXTKEY	VARCHAR2	(64)	First Column for primary key returned by ConText query
TEXTKEY2	VARCHAR2	(64)	Second Column for primary key returned by ConText query
SCORE	NUMBER		Score returned by ConText query
CONID	NUMBER		Identifier for a specific ConText query result set
DATESTAMP	DATE		Creation date. It is used to remove old rows.

Query Text

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


SELECT TEXTKEY
,      TEXTKEY2
,      SCORE
,      CONID
,      DATESTAMP
FROM ICX.ICX_CONTEXT_RESULTS_TEMP;

Dependencies

[top of page]

ICX.ICX_CONTEXT_RESULTS_TEMP does not reference any database object

ICX.ICX_CONTEXT_RESULTS_TEMP is referenced by following:

APPS: ICX_CONTEXT_RESULTS_TEMP; ICX_CONTEXT_RES_TEMP_T1_ICX