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: IGI.IGI_MHC_IDX_REVALUATION_RULES

Object Details

Object Name:	IGI_MHC_IDX_REVALUATION_RULES
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_MHC_IDX_REVALUATION_RULES
Subobject Name:
Status:	VALID

IGI_MHC_IDX_REVALUATION_RULES contains the default revaluation rules for the asset.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_MHC_IDX_REVALUATION_R_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_ID
IGI_MHC_IDX_REVALUATION_R_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID
IGI_MHC_IDX_REVAL_RULES_T_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	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
ORIGINAL_REVAL_PERCENT	NUMBER			Revaluation rate
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 - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORIGINAL_ASSET_COST	NUMBER			Current Cost of the Asset
NEW_ASSET_COST	NUMBER			New Cost of the Asset . This holds the user entered value for Adhoc Revaluation. At all other times, this field does not contain any value.

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
,      ORIGINAL_REVAL_PERCENT
,      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
,      ORIGINAL_ASSET_COST
,      NEW_ASSET_COST
FROM IGI.IGI_MHC_IDX_REVALUATION_RULES;

Dependencies

[top of page]

IGI.IGI_MHC_IDX_REVALUATION_RULES does not reference any database object

IGI.IGI_MHC_IDX_REVALUATION_RULES is referenced by following:

APPS: IGI_MHC_IDX_REVALUATION_RULES