[Home] [Help] [Dependency Information]
Object Name: | GL_ELIM_ACCOUNTS_MAP |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_ELIM_ACCOUNTS_MAP |
Subobject Name: | |
Status: | VALID |
GL_ELIM_ACCOUNTS_MAP stores source and target account mappings for an elimination set. This table corresponds to the account mapping section of the Define Elimination Mappings window of the Define Elimination Set form. For each account mapping for a journal in an elimination set, there exists a row in this table. That row indicates the line number, source and target segments for an account mapping.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_ELIM_ACCOUNTS_MAP_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
JOURNAL_ID
LINE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_ID | NUMBER | (15) | Yes | Elimination journal defining column |
LINE_NUMBER | NUMBER | (15) | Yes | Line number for account mapping |
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 |
SOURCE_SEGMENT1 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT2 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT3 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT4 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT5 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT6 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT7 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT8 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT9 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT10 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT11 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT12 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT13 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT14 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT15 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT16 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT17 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT18 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT19 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT20 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT21 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT22 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT23 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT24 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT25 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT26 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT27 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT28 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT29 | VARCHAR2 | (25) | Source key flexfield segment | |
SOURCE_SEGMENT30 | VARCHAR2 | (25) | Source key flexfield segment | |
TARGET_SEGMENT1 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT2 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT3 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT4 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT5 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT6 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT7 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT8 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT9 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT10 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT11 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT12 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT13 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT14 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT15 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT16 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT17 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT18 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT19 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT20 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT21 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT22 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT23 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT24 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT25 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT26 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT27 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT28 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT29 | VARCHAR2 | (25) | Target key flexfield segment | |
TARGET_SEGMENT30 | VARCHAR2 | (25) | Target key flexfield segment | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT JOURNAL_ID
, LINE_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SOURCE_SEGMENT1
, SOURCE_SEGMENT2
, SOURCE_SEGMENT3
, SOURCE_SEGMENT4
, SOURCE_SEGMENT5
, SOURCE_SEGMENT6
, SOURCE_SEGMENT7
, SOURCE_SEGMENT8
, SOURCE_SEGMENT9
, SOURCE_SEGMENT10
, SOURCE_SEGMENT11
, SOURCE_SEGMENT12
, SOURCE_SEGMENT13
, SOURCE_SEGMENT14
, SOURCE_SEGMENT15
, SOURCE_SEGMENT16
, SOURCE_SEGMENT17
, SOURCE_SEGMENT18
, SOURCE_SEGMENT19
, SOURCE_SEGMENT20
, SOURCE_SEGMENT21
, SOURCE_SEGMENT22
, SOURCE_SEGMENT23
, SOURCE_SEGMENT24
, SOURCE_SEGMENT25
, SOURCE_SEGMENT26
, SOURCE_SEGMENT27
, SOURCE_SEGMENT28
, SOURCE_SEGMENT29
, SOURCE_SEGMENT30
, TARGET_SEGMENT1
, TARGET_SEGMENT2
, TARGET_SEGMENT3
, TARGET_SEGMENT4
, TARGET_SEGMENT5
, TARGET_SEGMENT6
, TARGET_SEGMENT7
, TARGET_SEGMENT8
, TARGET_SEGMENT9
, TARGET_SEGMENT10
, TARGET_SEGMENT11
, TARGET_SEGMENT12
, TARGET_SEGMENT13
, TARGET_SEGMENT14
, TARGET_SEGMENT15
, TARGET_SEGMENT16
, TARGET_SEGMENT17
, TARGET_SEGMENT18
, TARGET_SEGMENT19
, TARGET_SEGMENT20
, TARGET_SEGMENT21
, TARGET_SEGMENT22
, TARGET_SEGMENT23
, TARGET_SEGMENT24
, TARGET_SEGMENT25
, TARGET_SEGMENT26
, TARGET_SEGMENT27
, TARGET_SEGMENT28
, TARGET_SEGMENT29
, TARGET_SEGMENT30
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM GL.GL_ELIM_ACCOUNTS_MAP;
GL.GL_ELIM_ACCOUNTS_MAP does not reference any database object
GL.GL_ELIM_ACCOUNTS_MAP is referenced by following:
|
|
|