[Home] [Help] [Dependency Information]
Object Name: | GL_CONSOLIDATION_SETS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_CONSOLIDATION_SETS |
Subobject Name: | |
Status: | VALID |
GL_CONSOLIDATION_SETS stores the consolidation sets you define in the Consolidation Mapping Sets form. Each row contains the name of the consolidation mapping set, the ID of the parent ledger being consolidated to, the method of consolidation (Balances or Transactions), and other information. There is a one-to-many relationship between rows in this table and rows in the GL_CONS_SET_ASSIGNMENTS table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_CONSOLIDATION_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CONSOLIDATION_SET_ID |
GL_CONSOLIDATION_SETS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
TO_LEDGER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONSOLIDATION_SET_ID | NUMBER | (15) | Yes | Consolidation set defining column |
TO_LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
NAME | VARCHAR2 | (30) | Yes | Consolidation set name |
RUN_JOURNAL_IMPORT_FLAG | VARCHAR2 | (1) | Yes | Automatically run journal import flag |
SUMMARIZE_LINES_FLAG | VARCHAR2 | (1) | Yes | Run journal import in summary mode flag |
AUDIT_MODE_FLAG | VARCHAR2 | (1) | Yes | Run journal import in audit mode flag |
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) | Yes | Standard Who column |
METHOD | VARCHAR2 | (1) | Consolidation method (Balances or Transactions) | |
DESCRIPTION | VARCHAR2 | (240) | Consolidation set description | |
CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
RUN_POSTING_FLAG | VARCHAR2 | (1) | Run journal posting flag | |
SECURITY_FLAG | VARCHAR2 | (1) | Yes | Enable definition access set security flag |
Cut, paste (and edit) the following text to query this object:
SELECT CONSOLIDATION_SET_ID
, TO_LEDGER_ID
, NAME
, RUN_JOURNAL_IMPORT_FLAG
, SUMMARIZE_LINES_FLAG
, AUDIT_MODE_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, METHOD
, DESCRIPTION
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, RUN_POSTING_FLAG
, SECURITY_FLAG
FROM GL.GL_CONSOLIDATION_SETS;
GL.GL_CONSOLIDATION_SETS does not reference any database object
GL.GL_CONSOLIDATION_SETS is referenced by following:
|
|
|