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_REVALUATION_SUMMARY

Object Details

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

IGI_MHC_REVALUATION_SUMMARY holds information like the new cost, revaluation reserve for the asset after the asset has been revalued by the Extended Mass Revaluations Program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_MHC_REVALUATION_SUMM_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE ASSET_ID
IGI_MHC_REVALUATION_SUMM_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE MASS_REVAL_ID ASSET_ID
IGI_MHC_REVALUATION_SUMM_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MASS_REVAL_ID BOOK_TYPE_CODE
IGI_MHC_REVAL_SUMMARY_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID MASS_REVAL_ID PERIOD_COUNTER BOOK_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
MASS_REVAL_ID	NUMBER	(15)	Yes	MASS_REVAL_ID from the IGI_MHC_IDX_REVALUATION table which identifies each run of Revaluation
ASSET_ID	NUMBER	(15)	Yes	Asset Identifier
CATEGORY_ID	NUMBER	(15)	Yes	Category Identifier to which the asset belongs.
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the bank
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	Current Modified Historic Cost Accounting Counter
PERIOD_COUNTER	NUMBER			Current Depreciation Period Counter
DPIS_MHC_PERIOD_COUNTER	NUMBER	(15)		The Modified Historic Cost Accounting Period Counter in which the Asset was placed in service.
LIFE_CHANGE_COUNT	NUMBER	(15)		The number of times the Life of the asset has been changed.
ACTIVE_FLAG	VARCHAR2	(1)		Flag to indicate the latest active record. This flag is used if there were many transactions that the asset has been through in the same period.
RUN_MODE	VARCHAR2	(240)		The mode in which the Revaluation process was run , For example Preview (P) or Live (L)
REVAL_MODE	VARCHAR2	(30)		Revaluation Mode
ORIGINAL_COST	NUMBER			Cost of the asset before revaluation.
NEW_ASSET_COST	NUMBER			Cost of the asset after Revaluation
NEW_SALVAGE_VALUE	NUMBER			New Salvage Value of the Asset, which is the value of the asset after it has been fully depreciated.
ORIGINAL_LIFE	NUMBER	(15)		The life of the asset when it was first created
PREVIOUS_LIFE	NUMBER	(15)		The life of the asset before the life was changed
CURRENT_LIFE	NUMBER	(15)		The current life of the asset.
OLD_ACCUM_DEPRN	NUMBER			Depreciation reserve for the asset before it has been revalued
OLD_REVAL_RESERVE	NUMBER			Revaluation reserve for the asset before the current Revaluation.
NEW_ACCUM_DEPRN	NUMBER			Depreciation reserve for the asset
NEW_REVAL_RESERVE	NUMBER			For a period in which this asset was revalued: change in net book value due to revaluation of the asset cost and sometimes also revaluation of depreciation reserve. For all other periods: revaluation reserve amount after depreciation run.
NEW_CURR_YR_EXPENSE	NUMBER			Depreciation expense for the current fiscal year
NEW_BACKLOG_DEPRN	NUMBER			Extra Depreciation calculated for the current period as a result of Revaluation.
NEW_CURR_YR_OP_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Current Year
NEW_PRIOR_YR_OP_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Previous Year
NEW_GENERAL_FUND	NUMBER			General Fund holds the Initial capital, apart from that financed from long term borrowing or Public Dividend Capital, plus subsequent movements in net assets, except where separate reserve accounts are operated.
NEW_ACCUM_GENERAL_FUND	NUMBER			The Sum of the General Fund for the Asset for the fiscal year
REVAL_CALCULATION_CODE	VARCHAR2	(1)		The type of calculation used for Revaluation of the asset for a given period.
LAST_TXN_EVENT	VARCHAR2	(240)		The last event that has changed the Revaluation figures.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	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).

Query Text

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


SELECT MASS_REVAL_ID
,      ASSET_ID
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
,      DPIS_MHC_PERIOD_COUNTER
,      LIFE_CHANGE_COUNT
,      ACTIVE_FLAG
,      RUN_MODE
,      REVAL_MODE
,      ORIGINAL_COST
,      NEW_ASSET_COST
,      NEW_SALVAGE_VALUE
,      ORIGINAL_LIFE
,      PREVIOUS_LIFE
,      CURRENT_LIFE
,      OLD_ACCUM_DEPRN
,      OLD_REVAL_RESERVE
,      NEW_ACCUM_DEPRN
,      NEW_REVAL_RESERVE
,      NEW_CURR_YR_EXPENSE
,      NEW_BACKLOG_DEPRN
,      NEW_CURR_YR_OP_EXPENSE
,      NEW_PRIOR_YR_OP_EXPENSE
,      NEW_GENERAL_FUND
,      NEW_ACCUM_GENERAL_FUND
,      REVAL_CALCULATION_CODE
,      LAST_TXN_EVENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGI.IGI_MHC_REVALUATION_SUMMARY;

Dependencies

[top of page]

IGI.IGI_MHC_REVALUATION_SUMMARY does not reference any database object

IGI.IGI_MHC_REVALUATION_SUMMARY is referenced by following:

APPS: IGI_MHC_REVALUATION_SUMMARY