[Home] [Help] [Dependency Information]
Object Name: | GL_LEDGER_CONFIG_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_LEDGER_CONFIG_DETAILS |
Subobject Name: | |
Status: | VALID |
GL_LEDGER_CONFIG_DETAILS stores information about a primary ledger, its related secondary ledgers and legal entities, and the state of each of their setup steps. The object type specifies the type of object stored in this row: primary ledger, secondary ledger, or legal entity. The object id and object name give the defining column and name of the object. Valid steps for objects include setup of ledgers, definition of reporting currencies, assignment of balancing segment values, mapping of primary ledger to secondary ledger, definition of operating units, definition of accounting sequences, definition of intercompany options, definition of intracompany options, and setup of subledger accounting.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_LEDGER_CONFIG_DETAILS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CONFIGURATION_ID
OBJECT_ID OBJECT_TYPE_CODE SETUP_STEP_CODE |
GL_LEDGER_CONFIG_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_TYPE_CODE
OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIGURATION_ID | NUMBER | (15) | Yes | Accounting setup defining column |
OBJECT_TYPE_CODE | VARCHAR2 | (30) | Yes | Object type |
OBJECT_ID | NUMBER | (15) | Yes | Object defining column |
OBJECT_NAME | VARCHAR2 | (240) | Yes | Object name |
SETUP_STEP_CODE | VARCHAR2 | (30) | Yes | Setup step |
NEXT_ACTION_CODE | VARCHAR2 | (30) | Next action | |
STATUS_CODE | VARCHAR2 | (30) | Setup step status | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIGURATION_ID
, OBJECT_TYPE_CODE
, OBJECT_ID
, OBJECT_NAME
, SETUP_STEP_CODE
, NEXT_ACTION_CODE
, STATUS_CODE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
FROM GL.GL_LEDGER_CONFIG_DETAILS;
GL.GL_LEDGER_CONFIG_DETAILS does not reference any database object
GL.GL_LEDGER_CONFIG_DETAILS is referenced by following:
|
|
|