eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: GL.GL_REVALUATIONS

Object Details

Object Name:	GL_REVALUATIONS
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_REVALUATIONS
Subobject Name:
Status:	VALID

GL_REVALUATIONS stores Revaluation definitions. Each row includes a revaluation's id, name, description, the corresponding ledger, the currency or currencies to be revalued, and other revaluation options. They include the currency conversion options, the unrealized gain account, the unrealized loss account, and the automatic post flag. There is a one-to-many relationship from each revaluation stored in this table to the revaluation account ranges stored in GL_REVAL_ACCOUNT_RANGES.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_REVALUATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REVALUATION_ID
GL_REVALUATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SET_OF_BOOKS_ID_11I NAME

Columns

Name	Datatype	Length	Mandatory	Comments
REVALUATION_ID	NUMBER	(15)	Yes	Revaluation defining column
NAME	VARCHAR2	(35)	Yes	Revaluation name
SET_OF_BOOKS_ID_11I	NUMBER	(15)		No Longer Used in R12
FROM_CURRENCY_OPTION_CODE	VARCHAR2	(30)	Yes	Determines the currency or currencies to be revalued
RANGE_MODE_FLAG	VARCHAR2	(1)	Yes	Method by which ranges are obtained
CONVERSION_RATE_OPTION_CODE	VARCHAR2	(30)	Yes	Determines the type of currency conversion rates to be used to revalue balances (Period, Daily, or One-time)
AUTOMATIC_POST_FLAG	VARCHAR2	(1)	Yes	Indicates if revaluation journal batches should automatically be posted
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
FROM_CURRENCY_CODE	VARCHAR2	(15)		Currency to be revalued when only a single currency is to be revalued
CONVERSION_RATE_TYPE	VARCHAR2	(30)		Currency conversion type to be used to revalue balances when daily rates are used
REVALUATION_RATE	NUMBER			User defined revaluation rate to be used to revalue balances when one-time rate is used
GAIN_SEGMENT1	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT1	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT2	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT2	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT3	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT3	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT4	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT4	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT5	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT5	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT6	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT6	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT7	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT7	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT8	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT8	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT9	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT9	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT10	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT10	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT11	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT11	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT12	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT12	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT13	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT13	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT14	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT14	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT15	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT15	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT16	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT16	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT17	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT17	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT18	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT18	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT19	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT19	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT20	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT20	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT21	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT21	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT22	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT22	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT23	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT23	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT24	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT24	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT25	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT25	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT26	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT26	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT27	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT27	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT28	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT28	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT29	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT29	VARCHAR2	(25)		Unrealized loss account key flexfield segment
GAIN_SEGMENT30	VARCHAR2	(25)		Unrealized loss account key flexfield segment
LOSS_SEGMENT30	VARCHAR2	(25)		Unrealized loss account key flexfield segment
DESCRIPTION	VARCHAR2	(240)		Revaluation description
CONTEXT	VARCHAR2	(150)		Descriptive flexfield context column
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
FROM_PRIMARY_CURRENCY_FLAG	VARCHAR2	(1)		Oracle internal use - reporting currency revaluation from source ledger currency flag
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
SECURITY_FLAG	VARCHAR2	(1)	Yes	Enable definition access set security flag

Query Text

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;

Dependencies

[top of page]

GL.GL_REVALUATIONS does not reference any database object

GL.GL_REVALUATIONS is referenced by following:

APPS: GL_REVALUATIONS