[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_REVALUATIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | GL |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| REVALUATION_ID | NUMBER | (15) | Yes | |
| NAME | VARCHAR2 | (35) | Yes | |
| SET_OF_BOOKS_ID_11I | NUMBER | (15) | ||
| FROM_CURRENCY_OPTION_CODE | VARCHAR2 | (30) | Yes | |
| RANGE_MODE_FLAG | VARCHAR2 | (1) | Yes | |
| CONVERSION_RATE_OPTION_CODE | VARCHAR2 | (30) | Yes | |
| AUTOMATIC_POST_FLAG | VARCHAR2 | (1) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| FROM_CURRENCY_CODE | VARCHAR2 | (15) | ||
| CONVERSION_RATE_TYPE | VARCHAR2 | (30) | ||
| REVALUATION_RATE | NUMBER | |||
| GAIN_SEGMENT1 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT1 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT2 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT2 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT3 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT3 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT4 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT4 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT5 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT5 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT6 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT6 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT7 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT7 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT8 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT8 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT9 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT9 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT10 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT10 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT11 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT11 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT12 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT12 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT13 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT13 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT14 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT14 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT15 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT15 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT16 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT16 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT17 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT17 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT18 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT18 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT19 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT19 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT20 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT20 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT21 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT21 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT22 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT22 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT23 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT23 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT24 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT24 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT25 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT25 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT26 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT26 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT27 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT27 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT28 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT28 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT29 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT29 | VARCHAR2 | (25) | ||
| GAIN_SEGMENT30 | VARCHAR2 | (25) | ||
| LOSS_SEGMENT30 | VARCHAR2 | (25) | ||
| DESCRIPTION | VARCHAR2 | (240) | ||
| CONTEXT | VARCHAR2 | (150) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| FROM_PRIMARY_CURRENCY_FLAG | VARCHAR2 | (1) | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Yes | |
| SECURITY_FLAG | VARCHAR2 | (1) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT REVALUATION_ID
, NAME
, SET_OF_BOOKS_ID_11I
, FROM_CURRENCY_OPTION_CODE
, RANGE_MODE_FLAG
, CONVERSION_RATE_OPTION_CODE
, AUTOMATIC_POST_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FROM_CURRENCY_CODE
, CONVERSION_RATE_TYPE
, REVALUATION_RATE
, GAIN_SEGMENT1
, LOSS_SEGMENT1
, GAIN_SEGMENT2
, LOSS_SEGMENT2
, GAIN_SEGMENT3
, LOSS_SEGMENT3
, GAIN_SEGMENT4
, LOSS_SEGMENT4
, GAIN_SEGMENT5
, LOSS_SEGMENT5
, GAIN_SEGMENT6
, LOSS_SEGMENT6
, GAIN_SEGMENT7
, LOSS_SEGMENT7
, GAIN_SEGMENT8
, LOSS_SEGMENT8
, GAIN_SEGMENT9
, LOSS_SEGMENT9
, GAIN_SEGMENT10
, LOSS_SEGMENT10
, GAIN_SEGMENT11
, LOSS_SEGMENT11
, GAIN_SEGMENT12
, LOSS_SEGMENT12
, GAIN_SEGMENT13
, LOSS_SEGMENT13
, GAIN_SEGMENT14
, LOSS_SEGMENT14
, GAIN_SEGMENT15
, LOSS_SEGMENT15
, GAIN_SEGMENT16
, LOSS_SEGMENT16
, GAIN_SEGMENT17
, LOSS_SEGMENT17
, GAIN_SEGMENT18
, LOSS_SEGMENT18
, GAIN_SEGMENT19
, LOSS_SEGMENT19
, GAIN_SEGMENT20
, LOSS_SEGMENT20
, GAIN_SEGMENT21
, LOSS_SEGMENT21
, GAIN_SEGMENT22
, LOSS_SEGMENT22
, GAIN_SEGMENT23
, LOSS_SEGMENT23
, GAIN_SEGMENT24
, LOSS_SEGMENT24
, GAIN_SEGMENT25
, LOSS_SEGMENT25
, GAIN_SEGMENT26
, LOSS_SEGMENT26
, GAIN_SEGMENT27
, LOSS_SEGMENT27
, GAIN_SEGMENT28
, LOSS_SEGMENT28
, GAIN_SEGMENT29
, LOSS_SEGMENT29
, GAIN_SEGMENT30
, LOSS_SEGMENT30
, DESCRIPTION
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, FROM_PRIMARY_CURRENCY_FLAG
, CHART_OF_ACCOUNTS_ID
, SECURITY_FLAG
FROM GL.GL_REVALUATIONS#;
GL
GL_REVALUATIONS
APPS
GL_REVALUATIONS
|
|
|
|