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: FA.FA_DEPRN_RULE_DETAILS

Object Details

Object Name:	FA_DEPRN_RULE_DETAILS
Object Type:	TABLE
Owner:	FA
FND Design Data:	OFA.FA_DEPRN_RULE_DETAILS
Subobject Name:
Status:	VALID

This table is to define the following detail information for depreciable basis
rule.
- Define the available combination of the method type and calculation basis.
- Define the available asset types.
- Define whether depreciable basis is update at the each period.
- Define to use the subtraction method for depreciation expense.
- Define to use eofy reserve.
- Allow reduction rate.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_DEPRN_RULE_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_SEED	DEPRN_RULE_DETAIL_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
DEPRN_RULE_DETAIL_ID	NUMBER	(15)	Yes	Unique identification number for a Depreciable basis rule details
DEPRN_BASIS_RULE_ID	NUMBER	(15)	Yes	Identifies Depreciable Basis Rule
RULE_NAME	VARCHAR2	(80)	Yes	The rule name of depreciable basis rule. The capitalized value only.
RATE_SOURCE_RULE	VARCHAR2	(15)	Yes	Identifies the depreciation rate source. Either CALCULATED, FLAT, PRODUCTION, FORMULA or TABLE.
DEPRN_BASIS_RULE	VARCHAR2	(15)	Yes	Indicates whether depreciation is based on cost or net book value.
ASSET_TYPE	VARCHAR2	(15)	Yes	Indicates whether asset type use depreciable basis rule on ALL, GROUP or NON_GROUP
PERIOD_UPDATE_FLAG	VARCHAR2	(1)		Periodic depreciable basis updating flag. Y: Adjusted cost is updated by every period after the depreciation expense calculation. N or Null: Adjusted cost is updated by fiscal year end only after the depreciation expense calculation.
SUBTRACT_YTD_FLAG	VARCHAR2	(1)		The flag is whether subtraction method is used for depreciation expense calculation. Y: Depreciation expense calculation uses the subtraction method. N or Null: Depreciation expense calculation doesn't use the subtraction method.
ALLOW_REDUCTION_RATE_FLAG	VARCHAR2	(1)		Description - Comment *: The flag is to allow entering reduction rate. Y: Allow to set reduction rate. N or Null: Not allow to set reduction rate.
USE_EOFY_RESERVE_FLAG	VARCHAR2	(1)		Description - Comment *: Y: Allow entering the prior year depreciation Reserve with Retirement and Reclassification. N or Null: Not allow entering the prior year depreciation Reserve with Retirement and Reclassification.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
USE_RSV_AFTER_IMP_FLAG	VARCHAR2	(1)		Indicates whether current reserve at the time of impairment will be deducted from depreciable basis or not
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT DEPRN_RULE_DETAIL_ID
,      DEPRN_BASIS_RULE_ID
,      RULE_NAME
,      RATE_SOURCE_RULE
,      DEPRN_BASIS_RULE
,      ASSET_TYPE
,      PERIOD_UPDATE_FLAG
,      SUBTRACT_YTD_FLAG
,      ALLOW_REDUCTION_RATE_FLAG
,      USE_EOFY_RESERVE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      USE_RSV_AFTER_IMP_FLAG
,      ZD_EDITION_NAME
FROM FA.FA_DEPRN_RULE_DETAILS;

Dependencies

[top of page]

FA.FA_DEPRN_RULE_DETAILS does not reference any database object

FA.FA_DEPRN_RULE_DETAILS is referenced by following:

FA: FA_DEPRN_RULE_DETAILS#