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_GEN_INTERFACE

Object Details

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

IGI_MHC_GEN_INTERFACE stores the details of the asset level distribution information during upgrade to the 11i version of MHCA.
When the Upgrade scripts are run or if any other interface program is run , the records would be imported into this generic interface table, IGI_MHC_GEN_INTERFACE, a record created for each distribution of an asset.
After validations are performed, the data is either rejected or imported by the Interface Import routines.
The data are imported into the MHCA Revaluation Audit tables and the synchronized with the Fixed Assets.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_MHC_GEN_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BOOK_TYPE_CODE ASSET_ID DISTRIBUTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INTERFACE_SEQ_ID	NUMBER	(15)	Yes	Sequence to order the records in order of their creation.
LATEST_MASS_REVAL_ID	NUMBER	(15)	Yes	Latest Mass Revaluation Identifier
LATEST_TXN_HEADER_ID	NUMBER	(15)	Yes	Latest Transaction header identifier.
LAST_DEPRN_PERIOD_COUNTER	NUMBER	(15)	Yes	Latest Depreciation Period Counter.
ASSET_ID	NUMBER	(15)	Yes	Asset Identifier
DISTRIBUTION_ID	NUMBER	(15)	Yes	Identifies the distribution line that contains the asset
CATEGORY_ID	NUMBER	(15)	Yes	Category Identifier to which the asset belongs.
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the book
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	Current Modified Historic Cost Accounting Counter
PERIOD_COUNTER	NUMBER		Yes	Current Depreciation Period Counter
TRANSFER_DATA_FLAG	VARCHAR2	(1)	Yes	Transfer Data flag.
UPGRADE_DATA_FLAG	VARCHAR2	(1)	Yes	Upgraded Data Flag.
PURGE_DATA_FLAG	VARCHAR2	(1)	Yes	Purge after Import Flag.
NUMBER_OF_UNITS_ASSIGNED	NUMBER	(15)		The number of units that have been assigned for this distribution.
NUMBER_OF_UNITS_RETIRED	NUMBER	(15)		The number of units which have been retired for this distribution.
ASSET_COST	NUMBER			Asset Cost apportioned for the Distribution Unit
SALVAGE_VALUE	NUMBER			Salvage Value of the Asset, which is the value of the asset after it has been fully depreciated.
ACCUMULATED_DEPRECIATION	NUMBER			Depreciation reserve for the asset allocated to the distribution line as calculated by the Modified Historic Cost Accounting processes.
PRIOR_YRS_ACCUM_DEPRECIATION	NUMBER			Depreciation reserve for the asset allocated to the distribution line for the previous years.
YTD_DEPRECIATION_RESERVE	NUMBER			Year-to-date depreciation expense allocated to the distribution line as calculated by the Modified Historic Cost Accounting processes.
CURR_MHC_PRD_BACKLOG_DEPRN	NUMBER			Extra Depreciation calculated for the current period as a result of Revaluation.
ACCUMULATED_BACKLOG_DEPRN	NUMBER			Sum of the extra Depreciation calculated over the periods as a result of Revaluation for the distribution
NET_BOOK_VALUE	NUMBER			Net Book Value, which equals the Recoverable Cost less the Depreciation Reserve
REVALUATION_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.
DEPRECIATION_EXPENSE	NUMBER			Depreciation expense allocated to the distribution line for the current period
CURR_YEAR_OPERATING_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Current Year
CURR_YR_PRIOR_PRDS_DEPRN	NUMBER			Current Year Depreciation till the prior period
CURR_YR_PRIOR_PRDS_DEPRN_REVAL	NUMBER			Effect of revaluation on the current year portion portion of Depreciation calculated till the previous period.
PRIOR_YEAR_OPERATING_EXPENSE	NUMBER			Amount in the Profit Loss Accounts for the Previous Year
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 each distribution of the Asset for the fiscal year
PRORATE_PERCENT	NUMBER			Prorate Percent is the ratio of the period between the Assets Date Placed in Service and the Prorate Start Date. This is used by the Revaluation Engine in the calculation of the Catchup Revaluation.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created 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_BY	NUMBER	(15)		Standard Who Column
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).
LAST_TXN_TYPE	VARCHAR2	(30)		Type of the latest transaction.
GENERATE_SEQ_ID_IMPORT	NUMBER	(15)		Generate Sequence of the Record imported.

Query Text

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


SELECT INTERFACE_SEQ_ID
,      LATEST_MASS_REVAL_ID
,      LATEST_TXN_HEADER_ID
,      LAST_DEPRN_PERIOD_COUNTER
,      ASSET_ID
,      DISTRIBUTION_ID
,      CATEGORY_ID
,      BOOK_TYPE_CODE
,      CURRENT_MHC_PERIOD_COUNTER
,      PERIOD_COUNTER
,      TRANSFER_DATA_FLAG
,      UPGRADE_DATA_FLAG
,      PURGE_DATA_FLAG
,      NUMBER_OF_UNITS_ASSIGNED
,      NUMBER_OF_UNITS_RETIRED
,      ASSET_COST
,      SALVAGE_VALUE
,      ACCUMULATED_DEPRECIATION
,      PRIOR_YRS_ACCUM_DEPRECIATION
,      YTD_DEPRECIATION_RESERVE
,      CURR_MHC_PRD_BACKLOG_DEPRN
,      ACCUMULATED_BACKLOG_DEPRN
,      NET_BOOK_VALUE
,      REVALUATION_RESERVE
,      DEPRECIATION_EXPENSE
,      CURR_YEAR_OPERATING_EXPENSE
,      CURR_YR_PRIOR_PRDS_DEPRN
,      CURR_YR_PRIOR_PRDS_DEPRN_REVAL
,      PRIOR_YEAR_OPERATING_EXPENSE
,      GENERAL_FUND
,      ACCUMULATED_GENERAL_FUND
,      PRORATE_PERCENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_BY
,      LAST_UPDATE_LOGIN
,      LAST_TXN_TYPE
,      GENERATE_SEQ_ID_IMPORT
FROM IGI.IGI_MHC_GEN_INTERFACE;

Dependencies

[top of page]

IGI.IGI_MHC_GEN_INTERFACE does not reference any database object

IGI.IGI_MHC_GEN_INTERFACE is referenced by following:

APPS: IGI_MHC_GEN_INTERFACE