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_TERMS_ARTSEC_DISP_TEMP

Object Details

Object Name:	OKC_TERMS_ARTSEC_DISP_TEMP
Object Type:	TABLE
Owner:	OKC
Subobject Name:
Status:	VALID

Temporary Table Details

OKC.OKC_TERMS_ARTSEC_DISP_TEMP 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Column
OKC_TERMS_ARTSEC_DISP_TEMP_U1	NORMAL	UNIQUE	TERMS_TYPE TERMS_ID PROCESSED_FLAG
OKC_TERMS_ARTSEC_DISP_TEMP_N1	NORMAL	NONUNIQUE	PARENT_ID
OKC_TERMS_ARTSEC_DISP_TEMP_N2	NORMAL	NONUNIQUE	DOCUMENT_ID DOCUMENT_TYPE RUNID

Columns

Name	Datatype	Length
DOCUMENT_ID	NUMBER
DOCUMENT_TYPE	VARCHAR2	(250)
TERMS_TYPE	VARCHAR2	(250)
TERMS_ID	NUMBER
PARENT_ID	NUMBER
TERMS_DISPLAY_SEQUENCE	NUMBER
TERMS_DISPLAY_LEVEL	NUMBER
TERMS_DISPLAY_ORDER	VARCHAR2	(2000)
PROCESSED_FLAG	VARCHAR2	(1)
RUNID	VARCHAR2	(150)

Query Text

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


SELECT DOCUMENT_ID
,      DOCUMENT_TYPE
,      TERMS_TYPE
,      TERMS_ID
,      PARENT_ID
,      TERMS_DISPLAY_SEQUENCE
,      TERMS_DISPLAY_LEVEL
,      TERMS_DISPLAY_ORDER
,      PROCESSED_FLAG
,      RUNID
FROM OKC.OKC_TERMS_ARTSEC_DISP_TEMP;

Dependencies

[top of page]

OKC.OKC_TERMS_ARTSEC_DISP_TEMP does not reference any database object

OKC.OKC_TERMS_ARTSEC_DISP_TEMP is referenced by following:

APPS: OKC_TERMS_ARTSEC_DISP_TEMP