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

TABLE: GMF.GL_EVNT_MST

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


This table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_EVNT_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnEVENT_TYPE
Columns
Name Datatype Length Mandatory Comments
EVENT_TYPE NUMBER (5) Yes Surrogate for Event Code
EVENT_CODE VARCHAR2 (4) Yes Event Code
EVENT_DESC VARCHAR2 (70) Yes Event Code description
TRANS_SOURCE_TYPE NUMBER (5) Yes Source to which this Event belongs
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
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 EVENT_TYPE
,      EVENT_CODE
,      EVENT_DESC
,      TRANS_SOURCE_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GMF.GL_EVNT_MST;

Dependencies

[top of page]

GMF.GL_EVNT_MST does not reference any database object

GMF.GL_EVNT_MST is referenced by following:

SchemaAPPS
SynonymGL_EVNT_MST