VIEW: GL.GL_REVALUATIONS#

Source

View Text - Preformatted

select REVALUATION_ID REVALUATION_ID, NAME NAME, SET_OF_BOOKS_ID_11I SET_OF_BOOKS_ID_11I, FROM_CURRENCY_OPTION_CODE FROM_CURRENCY_OPTION_CODE, RANGE_MODE_FLAG RANGE_MODE_FLAG, CONVERSION_RATE_OPTION_CODE CONVERSION_RATE_OPTION_CODE, AUTOMATIC_POST_FLAG AUTOMATIC_POST_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FROM_CURRENCY_CODE FROM_CURRENCY_CODE, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE, REVALUATION_RATE REVALUATION_RATE, GAIN_SEGMENT1 GAIN_SEGMENT1, LOSS_SEGMENT1 LOSS_SEGMENT1, GAIN_SEGMENT2 GAIN_SEGMENT2, LOSS_SEGMENT2 LOSS_SEGMENT2, GAIN_SEGMENT3 GAIN_SEGMENT3, LOSS_SEGMENT3 LOSS_SEGMENT3, GAIN_SEGMENT4 GAIN_SEGMENT4, LOSS_SEGMENT4 LOSS_SEGMENT4, GAIN_SEGMENT5 GAIN_SEGMENT5, LOSS_SEGMENT5 LOSS_SEGMENT5, GAIN_SEGMENT6 GAIN_SEGMENT6, LOSS_SEGMENT6 LOSS_SEGMENT6, GAIN_SEGMENT7 GAIN_SEGMENT7, LOSS_SEGMENT7 LOSS_SEGMENT7, GAIN_SEGMENT8 GAIN_SEGMENT8, LOSS_SEGMENT8 LOSS_SEGMENT8, GAIN_SEGMENT9 GAIN_SEGMENT9, LOSS_SEGMENT9 LOSS_SEGMENT9, GAIN_SEGMENT10 GAIN_SEGMENT10, LOSS_SEGMENT10 LOSS_SEGMENT10, GAIN_SEGMENT11 GAIN_SEGMENT11, LOSS_SEGMENT11 LOSS_SEGMENT11, GAIN_SEGMENT12 GAIN_SEGMENT12, LOSS_SEGMENT12 LOSS_SEGMENT12, GAIN_SEGMENT13 GAIN_SEGMENT13, LOSS_SEGMENT13 LOSS_SEGMENT13, GAIN_SEGMENT14 GAIN_SEGMENT14, LOSS_SEGMENT14 LOSS_SEGMENT14, GAIN_SEGMENT15 GAIN_SEGMENT15, LOSS_SEGMENT15 LOSS_SEGMENT15, GAIN_SEGMENT16 GAIN_SEGMENT16, LOSS_SEGMENT16 LOSS_SEGMENT16, GAIN_SEGMENT17 GAIN_SEGMENT17, LOSS_SEGMENT17 LOSS_SEGMENT17, GAIN_SEGMENT18 GAIN_SEGMENT18, LOSS_SEGMENT18 LOSS_SEGMENT18, GAIN_SEGMENT19 GAIN_SEGMENT19, LOSS_SEGMENT19 LOSS_SEGMENT19, GAIN_SEGMENT20 GAIN_SEGMENT20, LOSS_SEGMENT20 LOSS_SEGMENT20, GAIN_SEGMENT21 GAIN_SEGMENT21, LOSS_SEGMENT21 LOSS_SEGMENT21, GAIN_SEGMENT22 GAIN_SEGMENT22, LOSS_SEGMENT22 LOSS_SEGMENT22, GAIN_SEGMENT23 GAIN_SEGMENT23, LOSS_SEGMENT23 LOSS_SEGMENT23, GAIN_SEGMENT24 GAIN_SEGMENT24, LOSS_SEGMENT24 LOSS_SEGMENT24, GAIN_SEGMENT25 GAIN_SEGMENT25, LOSS_SEGMENT25 LOSS_SEGMENT25, GAIN_SEGMENT26 GAIN_SEGMENT26, LOSS_SEGMENT26 LOSS_SEGMENT26, GAIN_SEGMENT27 GAIN_SEGMENT27, LOSS_SEGMENT27 LOSS_SEGMENT27, GAIN_SEGMENT28 GAIN_SEGMENT28, LOSS_SEGMENT28 LOSS_SEGMENT28, GAIN_SEGMENT29 GAIN_SEGMENT29, LOSS_SEGMENT29 LOSS_SEGMENT29, GAIN_SEGMENT30 GAIN_SEGMENT30, LOSS_SEGMENT30 LOSS_SEGMENT30, DESCRIPTION DESCRIPTION, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, FROM_PRIMARY_CURRENCY_FLAG FROM_PRIMARY_CURRENCY_FLAG, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID, SECURITY_FLAG SECURITY_FLAG from "GL"."GL_REVALUATIONS"

View Text - HTML Formatted

SELECT REVALUATION_ID REVALUATION_ID
, NAME NAME
, SET_OF_BOOKS_ID_11I SET_OF_BOOKS_ID_11I
, FROM_CURRENCY_OPTION_CODE FROM_CURRENCY_OPTION_CODE
, RANGE_MODE_FLAG RANGE_MODE_FLAG
, CONVERSION_RATE_OPTION_CODE CONVERSION_RATE_OPTION_CODE
, AUTOMATIC_POST_FLAG AUTOMATIC_POST_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FROM_CURRENCY_CODE FROM_CURRENCY_CODE
, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE
, REVALUATION_RATE REVALUATION_RATE
, GAIN_SEGMENT1 GAIN_SEGMENT1
, LOSS_SEGMENT1 LOSS_SEGMENT1
, GAIN_SEGMENT2 GAIN_SEGMENT2
, LOSS_SEGMENT2 LOSS_SEGMENT2
, GAIN_SEGMENT3 GAIN_SEGMENT3
, LOSS_SEGMENT3 LOSS_SEGMENT3
, GAIN_SEGMENT4 GAIN_SEGMENT4
, LOSS_SEGMENT4 LOSS_SEGMENT4
, GAIN_SEGMENT5 GAIN_SEGMENT5
, LOSS_SEGMENT5 LOSS_SEGMENT5
, GAIN_SEGMENT6 GAIN_SEGMENT6
, LOSS_SEGMENT6 LOSS_SEGMENT6
, GAIN_SEGMENT7 GAIN_SEGMENT7
, LOSS_SEGMENT7 LOSS_SEGMENT7
, GAIN_SEGMENT8 GAIN_SEGMENT8
, LOSS_SEGMENT8 LOSS_SEGMENT8
, GAIN_SEGMENT9 GAIN_SEGMENT9
, LOSS_SEGMENT9 LOSS_SEGMENT9
, GAIN_SEGMENT10 GAIN_SEGMENT10
, LOSS_SEGMENT10 LOSS_SEGMENT10
, GAIN_SEGMENT11 GAIN_SEGMENT11
, LOSS_SEGMENT11 LOSS_SEGMENT11
, GAIN_SEGMENT12 GAIN_SEGMENT12
, LOSS_SEGMENT12 LOSS_SEGMENT12
, GAIN_SEGMENT13 GAIN_SEGMENT13
, LOSS_SEGMENT13 LOSS_SEGMENT13
, GAIN_SEGMENT14 GAIN_SEGMENT14
, LOSS_SEGMENT14 LOSS_SEGMENT14
, GAIN_SEGMENT15 GAIN_SEGMENT15
, LOSS_SEGMENT15 LOSS_SEGMENT15
, GAIN_SEGMENT16 GAIN_SEGMENT16
, LOSS_SEGMENT16 LOSS_SEGMENT16
, GAIN_SEGMENT17 GAIN_SEGMENT17
, LOSS_SEGMENT17 LOSS_SEGMENT17
, GAIN_SEGMENT18 GAIN_SEGMENT18
, LOSS_SEGMENT18 LOSS_SEGMENT18
, GAIN_SEGMENT19 GAIN_SEGMENT19
, LOSS_SEGMENT19 LOSS_SEGMENT19
, GAIN_SEGMENT20 GAIN_SEGMENT20
, LOSS_SEGMENT20 LOSS_SEGMENT20
, GAIN_SEGMENT21 GAIN_SEGMENT21
, LOSS_SEGMENT21 LOSS_SEGMENT21
, GAIN_SEGMENT22 GAIN_SEGMENT22
, LOSS_SEGMENT22 LOSS_SEGMENT22
, GAIN_SEGMENT23 GAIN_SEGMENT23
, LOSS_SEGMENT23 LOSS_SEGMENT23
, GAIN_SEGMENT24 GAIN_SEGMENT24
, LOSS_SEGMENT24 LOSS_SEGMENT24
, GAIN_SEGMENT25 GAIN_SEGMENT25
, LOSS_SEGMENT25 LOSS_SEGMENT25
, GAIN_SEGMENT26 GAIN_SEGMENT26
, LOSS_SEGMENT26 LOSS_SEGMENT26
, GAIN_SEGMENT27 GAIN_SEGMENT27
, LOSS_SEGMENT27 LOSS_SEGMENT27
, GAIN_SEGMENT28 GAIN_SEGMENT28
, LOSS_SEGMENT28 LOSS_SEGMENT28
, GAIN_SEGMENT29 GAIN_SEGMENT29
, LOSS_SEGMENT29 LOSS_SEGMENT29
, GAIN_SEGMENT30 GAIN_SEGMENT30
, LOSS_SEGMENT30 LOSS_SEGMENT30
, DESCRIPTION DESCRIPTION
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, FROM_PRIMARY_CURRENCY_FLAG FROM_PRIMARY_CURRENCY_FLAG
, CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, SECURITY_FLAG SECURITY_FLAG
FROM "GL"."GL_REVALUATIONS"