[Home] [Help] [Dependency Information]
Object Name: | GL_EFB_UPGRADE_ADB |
---|---|
Object Type: | TABLE |
Owner: | GL |
Subobject Name: | |
Status: | VALID |
GL.GL_EFB_UPGRADE_ADB 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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_EFB_UPGRADE_ADB_N1 | NORMAL | NONUNIQUE |
CODE_COMBINATION_ID
PERIOD_NAME CURRENCY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEDGER_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_START_DATE | DATE | |||
PERIOD_END_DATE | DATE | |||
QUARTER_START_DATE | DATE | |||
YEAR_START_DATE | DATE | |||
PERIOD_TYPE | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
TEMPLATE_ID | NUMBER | (15) | ||
OPENING_PERIOD_AGGREGATE | NUMBER | |||
OPENING_QUARTER_AGGREGATE | NUMBER | |||
OPENING_YEAR_AGGREGATE | NUMBER | |||
PERIOD_AGGREGATE1 | NUMBER | |||
PERIOD_AGGREGATE2 | NUMBER | |||
PERIOD_AGGREGATE3 | NUMBER | |||
PERIOD_AGGREGATE4 | NUMBER | |||
PERIOD_AGGREGATE5 | NUMBER | |||
PERIOD_AGGREGATE6 | NUMBER | |||
PERIOD_AGGREGATE7 | NUMBER | |||
PERIOD_AGGREGATE8 | NUMBER | |||
PERIOD_AGGREGATE9 | NUMBER | |||
PERIOD_AGGREGATE10 | NUMBER | |||
PERIOD_AGGREGATE11 | NUMBER | |||
PERIOD_AGGREGATE12 | NUMBER | |||
PERIOD_AGGREGATE13 | NUMBER | |||
PERIOD_AGGREGATE14 | NUMBER | |||
PERIOD_AGGREGATE15 | NUMBER | |||
PERIOD_AGGREGATE16 | NUMBER | |||
PERIOD_AGGREGATE17 | NUMBER | |||
PERIOD_AGGREGATE18 | NUMBER | |||
PERIOD_AGGREGATE19 | NUMBER | |||
PERIOD_AGGREGATE20 | NUMBER | |||
PERIOD_AGGREGATE21 | NUMBER | |||
PERIOD_AGGREGATE22 | NUMBER | |||
PERIOD_AGGREGATE23 | NUMBER | |||
PERIOD_AGGREGATE24 | NUMBER | |||
PERIOD_AGGREGATE25 | NUMBER | |||
PERIOD_AGGREGATE26 | NUMBER | |||
PERIOD_AGGREGATE27 | NUMBER | |||
PERIOD_AGGREGATE28 | NUMBER | |||
PERIOD_AGGREGATE29 | NUMBER | |||
PERIOD_AGGREGATE30 | NUMBER | |||
PERIOD_AGGREGATE31 | NUMBER | |||
PERIOD_AGGREGATE32 | NUMBER | |||
PERIOD_AGGREGATE33 | NUMBER | |||
PERIOD_AGGREGATE34 | NUMBER | |||
PERIOD_AGGREGATE35 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LEDGER_ID
, CODE_COMBINATION_ID
, CURRENCY_CODE
, PERIOD_NAME
, PERIOD_START_DATE
, PERIOD_END_DATE
, QUARTER_START_DATE
, YEAR_START_DATE
, PERIOD_TYPE
, PERIOD_YEAR
, PERIOD_NUM
, TEMPLATE_ID
, OPENING_PERIOD_AGGREGATE
, OPENING_QUARTER_AGGREGATE
, OPENING_YEAR_AGGREGATE
, PERIOD_AGGREGATE1
, PERIOD_AGGREGATE2
, PERIOD_AGGREGATE3
, PERIOD_AGGREGATE4
, PERIOD_AGGREGATE5
, PERIOD_AGGREGATE6
, PERIOD_AGGREGATE7
, PERIOD_AGGREGATE8
, PERIOD_AGGREGATE9
, PERIOD_AGGREGATE10
, PERIOD_AGGREGATE11
, PERIOD_AGGREGATE12
, PERIOD_AGGREGATE13
, PERIOD_AGGREGATE14
, PERIOD_AGGREGATE15
, PERIOD_AGGREGATE16
, PERIOD_AGGREGATE17
, PERIOD_AGGREGATE18
, PERIOD_AGGREGATE19
, PERIOD_AGGREGATE20
, PERIOD_AGGREGATE21
, PERIOD_AGGREGATE22
, PERIOD_AGGREGATE23
, PERIOD_AGGREGATE24
, PERIOD_AGGREGATE25
, PERIOD_AGGREGATE26
, PERIOD_AGGREGATE27
, PERIOD_AGGREGATE28
, PERIOD_AGGREGATE29
, PERIOD_AGGREGATE30
, PERIOD_AGGREGATE31
, PERIOD_AGGREGATE32
, PERIOD_AGGREGATE33
, PERIOD_AGGREGATE34
, PERIOD_AGGREGATE35
FROM GL.GL_EFB_UPGRADE_ADB;
GL.GL_EFB_UPGRADE_ADB does not reference any database object
GL.GL_EFB_UPGRADE_ADB is referenced by following:
|
|
|