Skip to content

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

TABLE: OKL.OKL_G_REPORTS_GT

Object Details
Object Name: OKL_G_REPORTS_GT
Object Type: TABLE
Owner: OKL
FND Design Data: TableOKL.OKL_G_REPORTS_GT
Subobject Name:
Status: VALID

Temporary Table Details

OKL.OKL_G_REPORTS_GT 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
VALUE1_TEXT VARCHAR2 (500)
VALUE2_TEXT VARCHAR2 (500)
VALUE3_TEXT VARCHAR2 (500)
VALUE4_TEXT VARCHAR2 (500)
VALUE5_TEXT VARCHAR2 (500)
VALUE6_TEXT VARCHAR2 (500)
VALUE7_TEXT VARCHAR2 (500)
VALUE8_TEXT VARCHAR2 (500)
VALUE9_TEXT VARCHAR2 (500)
VALUE10_TEXT VARCHAR2 (500)
VALUE11_TEXT VARCHAR2 (500)
VALUE12_TEXT VARCHAR2 (500)
VALUE13_TEXT VARCHAR2 (500)
VALUE14_TEXT VARCHAR2 (500)
VALUE15_TEXT VARCHAR2 (500)
VALUE1_NUM NUMBER

VALUE2_NUM NUMBER

VALUE3_NUM NUMBER

VALUE4_NUM NUMBER

VALUE5_NUM NUMBER

VALUE6_NUM NUMBER

VALUE7_NUM NUMBER

VALUE8_NUM NUMBER

VALUE9_NUM NUMBER

VALUE10_NUM NUMBER

VALUE11_NUM NUMBER

VALUE12_NUM NUMBER

VALUE13_NUM NUMBER

VALUE14_NUM NUMBER

VALUE15_NUM NUMBER

VALUE1_DATE DATE

VALUE2_DATE DATE

VALUE3_DATE DATE

VALUE4_DATE DATE

VALUE5_DATE DATE

VALUE6_DATE DATE

VALUE7_DATE DATE

VALUE8_DATE DATE

VALUE9_DATE DATE

VALUE10_DATE DATE

VALUE16_NUM NUMBER

VALUE17_NUM NUMBER

VALUE18_NUM NUMBER

VALUE19_NUM NUMBER

VALUE20_NUM NUMBER

VALUE16_TEXT VARCHAR2 (500)
VALUE17_TEXT VARCHAR2 (500)
VALUE18_TEXT VARCHAR2 (500)
VALUE19_TEXT VARCHAR2 (500)
VALUE20_TEXT VARCHAR2 (500)
Query Text

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


SELECT VALUE1_TEXT
,      VALUE2_TEXT
,      VALUE3_TEXT
,      VALUE4_TEXT
,      VALUE5_TEXT
,      VALUE6_TEXT
,      VALUE7_TEXT
,      VALUE8_TEXT
,      VALUE9_TEXT
,      VALUE10_TEXT
,      VALUE11_TEXT
,      VALUE12_TEXT
,      VALUE13_TEXT
,      VALUE14_TEXT
,      VALUE15_TEXT
,      VALUE1_NUM
,      VALUE2_NUM
,      VALUE3_NUM
,      VALUE4_NUM
,      VALUE5_NUM
,      VALUE6_NUM
,      VALUE7_NUM
,      VALUE8_NUM
,      VALUE9_NUM
,      VALUE10_NUM
,      VALUE11_NUM
,      VALUE12_NUM
,      VALUE13_NUM
,      VALUE14_NUM
,      VALUE15_NUM
,      VALUE1_DATE
,      VALUE2_DATE
,      VALUE3_DATE
,      VALUE4_DATE
,      VALUE5_DATE
,      VALUE6_DATE
,      VALUE7_DATE
,      VALUE8_DATE
,      VALUE9_DATE
,      VALUE10_DATE
,      VALUE16_NUM
,      VALUE17_NUM
,      VALUE18_NUM
,      VALUE19_NUM
,      VALUE20_NUM
,      VALUE16_TEXT
,      VALUE17_TEXT
,      VALUE18_TEXT
,      VALUE19_TEXT
,      VALUE20_TEXT
FROM OKL.OKL_G_REPORTS_GT;

Dependencies

[top of page]

OKL.OKL_G_REPORTS_GT does not reference any database object

OKL.OKL_G_REPORTS_GT is referenced by following:

SchemaAPPS
SynonymOKL_G_REPORTS_GT