DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_ETRM_SEARCH_TMP

Object Details
Object Name: FND_ETRM_SEARCH_TMP
Object Type: TABLE
Owner: APPLSYS
Subobject Name:
Status: VALID

A temporary table used to store intermediate results for eTRM's search engine.
eTRM writes raw 'hits' to this table and then queries it to sort the result.

Temporary Table Details

APPLSYS.FND_ETRM_SEARCH_TMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
APP_ID NUMBER (16)
The product's APPLICATION_ID
OBJ_ID NUMBER (22)
The table or view id of an object in the FND model
OBJ_TYPE VARCHAR2 (16)
'TAB' = Table, 'VW' = View
Query Text

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


SELECT APP_ID
,      OBJ_ID
,      OBJ_TYPE
FROM APPLSYS.FND_ETRM_SEARCH_TMP;

Dependencies

[top of page]

APPLSYS.FND_ETRM_SEARCH_TMP does not reference any database object

APPLSYS.FND_ETRM_SEARCH_TMP is referenced by following:

SchemaPUBLIC
SynonymFND_ETRM_SEARCH_TMP