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: FA.FA_MASS_REVALUATION_RULES

Object Details

Object Name:	FA_MASS_REVALUATION_RULES
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_MASS_REVALUATION_RULES
Subobject Name:
Status:	VALID

FA_MASS_REVALUATIONS contains detail information about your mass
revaluation requests. Oracle Assets uses this information
to run a concurrent process that revalues the cost of your
assets.
.
When you define a Mass Revaluation request using the Mass
Revaluation form, Oracle Assets inserts rows defining
which assets and/or categories to revalue using which rules
and rates into this table.
A definition may have as many rows in this table as there are
categories or assets to be revalued.
Oracle Assets uses this information to generate the
Mass Revaluation Preview and the Mass Revaluation Review reports.
When you perform the mass revaluation, it
uses the information in this table to update your assets.
.
MASS_REVAL_ID identifies each mass revaluation definition.
.
Either CATEGORY_ID or ASSET_ID must be filled in with the
value of the category or asset this revaluation affects.
The category or asset, together with the MASS_REVAL_ID of
the definition, make up the primary key of this table.
.
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_MASS_REVALUATION_RULES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	MASS_REVAL_ID CATEGORY_ID
FA_MASS_REVALUATION_RULES_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	MASS_REVAL_ID ASSET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MASS_REVAL_ID	NUMBER		Yes	Unique mass revaluation identification number
CATEGORY_ID	NUMBER			Category to be revalued
ASSET_ID	NUMBER			Asset to be revalued
REVAL_PERCENT	NUMBER		Yes	Revaluation rate
OVERRIDE_DEFAULTS_FLAG	VARCHAR2	(3)	Yes	Indicates whether or not to override default revaluation rules
REVAL_FULLY_RSVD_FLAG	VARCHAR2	(3)		Indicates whether or not to revalue fully reserved assets
LIFE_EXTENSION_FACTOR	NUMBER			Factor by which to extend the life when revaluing a fully reserved asset
LIFE_EXTENSION_CEILING	NUMBER			Maximum factor by which the life can be multiplied when backing out depreciation during revaluation. Does not affect the actual asset life
MAX_FULLY_RSVD_REVALS	NUMBER	(3)		Maximum number of times an asset can be revalued as fully reserved
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
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column
REVAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Override defaults descriptive flexfield structure defining column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REVALUE_CIP_ASSETS_FLAG	VARCHAR2	(1)		Indicates whether or not to revalue CIP assets.
REASON	VARCHAR2	(100)		Reason for Revaluation. Used for SORP Compliance only
VALUE_TYPE	VARCHAR2	(30)		The type of entered revluation amount.It can take values 'NBV' or 'AMT' or 'PER'. Used for SORP Compliance only
LINKED_FLAG	VARCHAR2	(3)		This flag indicates if revaluation is linked to prior impairment or not.It can take values 'YES' or 'NO'. Used for SORP Compliance only
BOOK_TYPE_CODE	VARCHAR2	(15)		Book Name. Used for SORP Compliance only

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MASS_REVAL_ID
,      CATEGORY_ID
,      ASSET_ID
,      REVAL_PERCENT
,      OVERRIDE_DEFAULTS_FLAG
,      REVAL_FULLY_RSVD_FLAG
,      LIFE_EXTENSION_FACTOR
,      LIFE_EXTENSION_CEILING
,      MAX_FULLY_RSVD_REVALS
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      REVAL_ATTRIBUTE_CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REVALUE_CIP_ASSETS_FLAG
,      REASON
,      VALUE_TYPE
,      LINKED_FLAG
,      BOOK_TYPE_CODE
FROM FA.FA_MASS_REVALUATION_RULES;

Dependencies

[top of page]

FA.FA_MASS_REVALUATION_RULES does not reference any database object

FA.FA_MASS_REVALUATION_RULES is referenced by following:

FA: FA_MASS_REVALUATION_RULES#