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: GL.GL_STORAGE_PARAMETERS

Object Details

Object Name:	GL_STORAGE_PARAMETERS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_STORAGE_PARAMETERS
Subobject Name:
Status:	VALID

GL_STORAGE_PARAMETERS stores default storage parameters for interim tables in your Oracle General Ledger application. The storage parameter values determine the amount of space Oracle General Ledger allocates when it creates interim tables. You can update the values in this table by using the Storage Parameters form. There is a separate row in this table for each interim table in your Oracle General Ledger application. This table has no foreign keys.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_STORAGE_PARAMETERS_U1	NORMAL	UNIQUE	APPS_TS_SEED	OBJECT_NAME ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_NAME	VARCHAR2	(30)	Yes	Table or index name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
OBJECT_TYPE	VARCHAR2	(30)	Yes	Table or index
TABLESPACE_NAME	VARCHAR2	(30)	Yes	Tablespace name
INITIAL_EXTENT_SIZE_KB	NUMBER	(15)	Yes	Initial extent size in KBytes
NEXT_EXTENT_SIZE_KB	NUMBER	(15)	Yes	Next extent size in KBytes
MAX_EXTENTS	NUMBER	(15)	Yes	Maximum number of extents
PCT_INCREASE	NUMBER	(15)	Yes	Percentage increase of new extent size
PCT_FREE	NUMBER	(15)		Percentage of free space reserved for future updates
DESCRIPTION	VARCHAR2	(240)		Description
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT OBJECT_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_TYPE
,      TABLESPACE_NAME
,      INITIAL_EXTENT_SIZE_KB
,      NEXT_EXTENT_SIZE_KB
,      MAX_EXTENTS
,      PCT_INCREASE
,      PCT_FREE
,      DESCRIPTION
,      ZD_EDITION_NAME
FROM GL.GL_STORAGE_PARAMETERS;

Dependencies

[top of page]

GL.GL_STORAGE_PARAMETERS does not reference any database object

GL.GL_STORAGE_PARAMETERS is referenced by following:

GL: GL_STORAGE_PARAMETERS#