[Home] [Help] [Dependency Information]
Object Name: | GL_DYNAMIC_SUMM_COMBINATIONS |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_DYNAMIC_SUMM_COMBINATIONS |
Subobject Name: | |
Status: | VALID |
GL_DYNAMIC_SUMM_COMBINATIONS is used by the Application Object Library (AOL) user exit that maintains account hierarchies and budget organizations by adding dynamically created accounts. This table temporarily stores new parent accounts that are created. The AOL flex routine determines which detail accounts fall under this parent and adds the parent/detail relationship to GL_ACCOUNT_HIERARCHIES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_DYN_SUMM_COMBINATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DYNAMIC_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DYNAMIC_GROUP_ID | NUMBER | (15) | Yes | Group defining column |
LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
TEMPLATE_ID | NUMBER | (15) | Yes | Summary template defining column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield defining column | |
SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT21 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT22 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT23 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT24 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT25 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT26 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT27 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT28 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT29 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT30 | VARCHAR2 | (25) | Key flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT DYNAMIC_GROUP_ID
, LEDGER_ID
, TEMPLATE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CODE_COMBINATION_ID
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
FROM GL.GL_DYNAMIC_SUMM_COMBINATIONS;
GL.GL_DYNAMIC_SUMM_COMBINATIONS does not reference any database object
GL.GL_DYNAMIC_SUMM_COMBINATIONS is referenced by following:
|
|
|