[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_ELIM_INT |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| Subobject Name: | |
| Status: | VALID |
GL.GL_ELIM_INT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
| Tablespace: |  |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_ELIM_INT_N1 | NORMAL | NONUNIQUE |
|
 SOURCE_CODE_COMBINATION_ID
TARGET_CODE_COMBINATION_ID
|
| GL_ELIM_INT_N2 | NORMAL | NONUNIQUE |
|
TARGET_CODE_COMBINATION_ID
|
| GL_ELIM_INT_N3 | NORMAL | NONUNIQUE |
|
TARGET_CC_STATUS_CODE
|
| GL_ELIM_INT_N4 | NORMAL | NONUNIQUE |
|
JOURNAL_ID
BALANCE_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| JOURNAL_ID | NUMBER | (15) | ||
| LINE_NUMBER | NUMBER | (15) | ||
| SOURCE_SEGMENT1 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT2 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT3 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT4 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT5 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT6 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT7 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT8 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT9 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT10 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT11 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT12 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT13 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT14 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT15 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT16 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT17 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT18 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT19 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT20 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT21 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT22 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT23 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT24 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT25 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT26 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT27 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT28 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT29 | VARCHAR2 | (25) | ||
| SOURCE_SEGMENT30 | VARCHAR2 | (25) | ||
| SOURCE_CODE_COMBINATION_ID | NUMBER | (15) | ||
| TARGET_SEGMENT1 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT2 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT3 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT4 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT5 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT6 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT7 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT8 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT9 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT10 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT11 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT12 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT13 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT14 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT15 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT16 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT17 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT18 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT19 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT20 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT21 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT22 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT23 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT24 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT25 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT26 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT27 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT28 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT29 | VARCHAR2 | (25) | ||
| TARGET_SEGMENT30 | VARCHAR2 | (25) | ||
| TARGET_ACCOUNT_TYPE | VARCHAR2 | (1) | ||
| TARGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
| TARGET_CC_STATUS_CODE | VARCHAR2 | (1) | ||
| BALANCE_FLAG | VARCHAR2 | (1) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| ENTERED_DR | NUMBER | |||
| ENTERED_CR | NUMBER | |||
| STATUS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT JOURNAL_ID
, LINE_NUMBER
, 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
, SOURCE_CODE_COMBINATION_ID
, 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
, TARGET_ACCOUNT_TYPE
, TARGET_CODE_COMBINATION_ID
, TARGET_CC_STATUS_CODE
, BALANCE_FLAG
, CURRENCY_CODE
, ENTERED_DR
, ENTERED_CR
, STATUS_FLAG
FROM GL.GL_ELIM_INT;
GL.GL_ELIM_INT does not reference any database object
GL.GL_ELIM_INT is referenced by following:
APPS
GL_ELIM_INT
|
|
|
|