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

TABLE: GMF.GL_ACCT_CLS

Object Details
Object Name: GL_ACCT_CLS
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.GL_ACCT_CLS
Subobject Name:
Status: VALID


This table contains the user-defined Account classs. These classes
are used to classify accounts and are used for reporting purposes
only. Note that this table is not used with Oracle Finanicial
Integration.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_ACCT_CLS_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnACCT_CLASS_CODE
Columns
Name Datatype Length Mandatory Comments
ACCT_CLASS_CODE VARCHAR2 (4) Yes User Defined Account Class Code.
ACCT_CLASS_DESC VARCHAR2 (70) Yes Account Class Description.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
Query Text

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


SELECT ACCT_CLASS_CODE
,      ACCT_CLASS_DESC
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GMF.GL_ACCT_CLS;

Dependencies

[top of page]

GMF.GL_ACCT_CLS does not reference any database object

GMF.GL_ACCT_CLS is referenced by following:

SchemaAPPS
SynonymGL_ACCT_CLS