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

TABLE: GL.GL_LEDGER_SET_ASSIGNMENTS

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


GL_LEDGER_SET_ASSIGNMENTS stores information about each ledger or ledger set that is contained within a ledger set. This table stores the flattened information from the GL_LEDGER_SET_NORM_ASSIGN table. Each ledger set contained within another ledger set in the GL_LEDGER_SET_NORM_ASSIGN table will be expanded into the corresponding ledgers before it is stored in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_LEDGER_SET_ASSIGNMENTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEDGER_SET_ID
ColumnLEDGER_ID
GL_LEDGER_SET_ASSIGNMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEDGER_ID
Columns
Name Datatype Length Mandatory Comments
LEDGER_SET_ID NUMBER (15) Yes Ledger set defining column
LEDGER_ID NUMBER (15) Yes Ledger defining 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
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
START_DATE DATE

Start date
END_DATE DATE

End date
STATUS_CODE VARCHAR2 (1)
Status code
Query Text

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


SELECT LEDGER_SET_ID
,      LEDGER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      START_DATE
,      END_DATE
,      STATUS_CODE
FROM GL.GL_LEDGER_SET_ASSIGNMENTS;

Dependencies

[top of page]

GL.GL_LEDGER_SET_ASSIGNMENTS does not reference any database object

GL.GL_LEDGER_SET_ASSIGNMENTS is referenced by following:

SchemaAPPS
Materialized ViewGL_ACCESS_SET_LEDGERS
SchemaGL
ViewGL_LEDGER_SET_ASSIGNMENTS#