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

TABLE: GL.GL_JE_SEGMENT_VALUES

Object Details
Object Name: GL_JE_SEGMENT_VALUES
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_JE_SEGMENT_VALUES
Subobject Name:
Status: VALID


GL_JE_SEGMENT_VALUES stores the balancing and management segment values used in each journal entry. Each row in this table stores the associated journal entry ID, the segment type (balancing or management), and the segment value. There is a one-to-many relationship between the journal entries in the GL_JE_HEADERS table and this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_JE_SEGMENT_VALUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_HEADER_ID
ColumnSEGMENT_TYPE_CODE
ColumnSEGMENT_VALUE
Columns
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15) Yes Journal entry defining column
SEGMENT_TYPE_CODE VARCHAR2 (1) Yes Segment Type (balancing or management)
SEGMENT_VALUE VARCHAR2 (30) Yes Segment value
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes 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 JE_HEADER_ID
,      SEGMENT_TYPE_CODE
,      SEGMENT_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GL.GL_JE_SEGMENT_VALUES;

Dependencies

[top of page]

GL.GL_JE_SEGMENT_VALUES does not reference any database object

GL.GL_JE_SEGMENT_VALUES is referenced by following:

SchemaAPPS
SynonymGL_JE_SEGMENT_VALUES