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_STAT_ACCOUNT_UOM

Object Details

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

GL_STAT_ACCOUNT_UOM stores the units of measure that you enter in the Statistical Units of Measure form.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_STAT_ACCOUNT_UOM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNT_SEGMENT_VALUE CHART_OF_ACCOUNTS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNT_SEGMENT_VALUE	VARCHAR2	(25)	Yes	Account segment value using this statistical unit of measure
UNIT_OF_MEASURE	VARCHAR2	(25)	Yes	Statistical unit of measure name
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
DESCRIPTION	VARCHAR2	(240)		Statistical unit of measure description
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column

Query Text

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


SELECT ACCOUNT_SEGMENT_VALUE
,      UNIT_OF_MEASURE
,      CHART_OF_ACCOUNTS_ID
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM GL.GL_STAT_ACCOUNT_UOM;

Dependencies

[top of page]

GL.GL_STAT_ACCOUNT_UOM does not reference any database object

GL.GL_STAT_ACCOUNT_UOM is referenced by following:

GL: GL_STAT_ACCOUNT_UOM#