[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#;
|
|
|