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_DEPRN_SUMMARY

Object Details

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

IGI_MHC_DEPRN_SUMMARY is an extension of FA_DEPRN_SUMMARY.
The Depreciation Post Processor inserts one row per Asset in this table , thus summing up the details of the asset stored in the IGI_MHC_DEPRN_DETAIL table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_MHC_DEPRN_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID BOOK_TYPE_CODE PERIOD_COUNTER
IGI_MHC_DEPRN_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FA_DEPRN_SUMMARY_ROWID ASSET_ID BOOK_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
FA_DEPRN_SUMMARY_ROWID	ROWID	(10)	Yes	ROWID of the record in FA_DEPRN_SUMMARY table
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the Book
ASSET_ID	NUMBER		Yes	Unique identifier of the Asset
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	The current Modified Historic Cost Accounting period counter
PERIOD_COUNTER	NUMBER	(15)	Yes	Depreciation period
MHC_YTD_DEPRN	NUMBER			Year-to-date depreciation expense for the asset as calculated by the Modified Historic Cost Accounting processes.
MHC_DEPRN_RESERVE	NUMBER			Depreciation reserve for the asset as calculated by the Modified Historic Cost Accounting processes.
MHC_COST	NUMBER			Asset Cost as calculated by the Modified Historic Cost Accounting processes
MHC_SALVAGE_VALUE	NUMBER			Salvage Value of the Asset, which is the value of the asset after it has been fully depreciated.
MHC_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. This figure is as calcuated by the Modified Historic Cost Accounting Revaluation Engine.
MHC_NET_BOOK_VALUE	NUMBER			Net Book Value, which equals the Recoverable Cost less the Depreciation Reserve
MHC_DEPRN_EXPENSE	NUMBER			Depreciation expense allocated to the distribution line for the current period
CURRENT_MHC_PRD_BACKLOG_DEPRN	VARCHAR2	(240)		Extra Depreciation calculated for the current period as a result of Revaluation.
ACCUMULATED_BACKLOG_DEPRN	VARCHAR2	(240)		Sum of the extra Depreciation calculated over the periods as a result of Revaluation for the asset.
MHC_CURR_YR_OP_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Current Year
MHC_CURR_YR_PPS_DEPRN	NUMBER			Depreciation expense allocated to the asset for the pervious periods of the current fiscal year
MHC_CURR_YR_PPS_DEPRN_REVAL	NUMBER			Portion of depreciation expense due to revaluation of the asset cost for previous periods of the current fiscal year.
MHC_PRIOR_YR_OP_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Previous Year
MHC_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.
ACCUMULATED_GENERAL_FUND	NUMBER			The Sum of the General Fund for the Asset for the fiscal year
CREATION_DATE	VARCHAR2	(240)		Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	VARCHAR2	(240)		Standard Who column - date when a user last updated this row.
LAST_UPDATED_LOGIN	NUMBER			Standard Who Column
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Query Text

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


SELECT FA_DEPRN_SUMMARY_ROWID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
,      MHC_YTD_DEPRN
,      MHC_DEPRN_RESERVE
,      MHC_COST
,      MHC_SALVAGE_VALUE
,      MHC_REVAL_RESERVE
,      MHC_NET_BOOK_VALUE
,      MHC_DEPRN_EXPENSE
,      CURRENT_MHC_PRD_BACKLOG_DEPRN
,      ACCUMULATED_BACKLOG_DEPRN
,      MHC_CURR_YR_OP_EXPENSE
,      MHC_CURR_YR_PPS_DEPRN
,      MHC_CURR_YR_PPS_DEPRN_REVAL
,      MHC_PRIOR_YR_OP_EXPENSE
,      MHC_GENERAL_FUND
,      ACCUMULATED_GENERAL_FUND
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_LOGIN
,      LAST_UPDATED_BY
FROM IGI.IGI_MHC_DEPRN_SUMMARY;

Dependencies

[top of page]

IGI.IGI_MHC_DEPRN_SUMMARY does not reference any database object

IGI.IGI_MHC_DEPRN_SUMMARY is referenced by following:

APPS: IGI_MHC_DEPRN_SUMMARY