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_ADDITIONAL_DEPRN

Object Details

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

IGI_MHC_ADDITIONAL_DEPRECIATION stores the extra depreciation expense to be calculated by the Modified Historic Cost Accounting processes. This table is maintained for future use.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ADDITONAL_DEPRN_ID	NUMBER	(15)	Yes	Unique Identifier
ASSET_ID	NUMBER	(15)	Yes	Asset Identifier
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the Book
START_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	Modified Historic Cost Accounting Period Counter from which the Additional Depreciation needs to be taken care of
START_PERIOD_COUNTER	NUMBER	(15)	Yes	Period Counter from which the Additional Depreciation needs to be taken care of
DEPRN_EVENT_TYPE	VARCHAR2	(30)	Yes	Event which caused the additional Depreciation
DEPRN_AMOUNT	NUMBER		Yes	The Depreciation Amount
END_MHC_PERIOD_COUNTER	NUMBER	(15)		Period counter upto which the additional depreciation needs to be done.
END_PERIOD_COUNTER	NUMBER	(15)		End period counter
FULLY_USED_FLAG	VARCHAR2	(1)		Flag to indicate whether the asset has been fully depreciated.
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_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	VARCHAR2	(240)		Standard Who column - date when a user last updated this row.

Query Text

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


SELECT ADDITONAL_DEPRN_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      START_MHC_PERIOD_COUNTER
,      START_PERIOD_COUNTER
,      DEPRN_EVENT_TYPE
,      DEPRN_AMOUNT
,      END_MHC_PERIOD_COUNTER
,      END_PERIOD_COUNTER
,      FULLY_USED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
FROM IGI.IGI_MHC_ADDITIONAL_DEPRN;

Dependencies

[top of page]

IGI.IGI_MHC_ADDITIONAL_DEPRN does not reference any database object

IGI.IGI_MHC_ADDITIONAL_DEPRN is referenced by following:

APPS: IGI_MHC_ADDITIONAL_DEPRN