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

TABLE: GMF.GL_SRCE_MST

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


Subsystem master table.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_SRCE_MST_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTRANS_SOURCE_TYPE
GL_SRCE_MST_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTRANS_SOURCE_CODE
Columns
Name Datatype Length Mandatory Comments
TRANS_SOURCE_TYPE NUMBER (5) Yes Number assigned to subsystem.
TRANS_SOURCE_CODE VARCHAR2 (4) Yes Abbreviation assigned to subsystem.
TRANS_SOURCE_DESC VARCHAR2 (70) Yes Subsystem description.
RATE_TYPE_CODE VARCHAR2 (4) Yes Classification of subsystem exchange rate.
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 TRANS_SOURCE_TYPE
,      TRANS_SOURCE_CODE
,      TRANS_SOURCE_DESC
,      RATE_TYPE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANS_CNT
,      TEXT_CODE
,      DELETE_MARK
FROM GMF.GL_SRCE_MST;

Dependencies

[top of page]

GMF.GL_SRCE_MST does not reference any database object

GMF.GL_SRCE_MST is referenced by following:

SchemaAPPS
SynonymGL_SRCE_MST