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_METHODS

Object Details

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

FA_METHODS stores information about your depreciation methods. The
depreciation program uses this table to identify the appropriate
depreciation rates for table-based methods in FA_RATES.
.
.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_METHODS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	METHOD_ID ZD_EDITION_NAME
FA_METHODS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	METHOD_CODE LIFE_IN_MONTHS ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
METHOD_ID	NUMBER	(15)	Yes	Unique identification number for a depreciation method
METHOD_CODE	VARCHAR2	(12)	Yes	Short name for the method
LIFE_IN_MONTHS	NUMBER	(4)		Life of an asset that uses this depreciation method. Used only for life-based depreciation methods
DEPRECIATE_LASTYEAR_FLAG	VARCHAR2	(3)	Yes	Indicates whether the asset is to be depreciated in the last year of its life
STL_METHOD_FLAG	VARCHAR2	(3)	Yes	Indicates a Straight Line Method definition
RATE_SOURCE_RULE	VARCHAR2	(10)	Yes	Identifies the depreciation rate source. Either CALCULATED, FLAT, PRODUCTION, or TABLE
DEPRN_BASIS_RULE	VARCHAR2	(4)	Yes	Indicates whether depreciation is based on cost or net book value
PRORATE_PERIODS_PER_YEAR	NUMBER	(3)		Number of prorate periods for table-based methods
NAME	VARCHAR2	(80)		Full name of the depreciation method
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)		Descriptive flexfield structure defining column
EXCLUDE_SALVAGE_VALUE_FLAG	VARCHAR2	(3)		Indicates whether to exclude the salvage value from the depreciable basis.
DEPRN_BASIS_FORMULA	VARCHAR2	(25)		Formula used to base depreciation basis
DEPRN_BASIS_RULE_ID	NUMBER	(15)		Depreciable Basis Rule ID
POLISH_ADJ_CALC_BASIS_FLAG	VARCHAR2	(1)		Specifies whether a negative adjustment on an asset using a Polish depreciation basis rule should be subject to special depreciation basis rules
GUARANTEE_RATE_METHOD_FLAG	VARCHAR2	(3)		Indicates whether method is guarantee rate method
JP_IMP_CALC_BASIS_FLAG	VARCHAR2	(3)		Use Japan based NBV calculation for impairments
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT METHOD_ID
,      METHOD_CODE
,      LIFE_IN_MONTHS
,      DEPRECIATE_LASTYEAR_FLAG
,      STL_METHOD_FLAG
,      RATE_SOURCE_RULE
,      DEPRN_BASIS_RULE
,      PRORATE_PERIODS_PER_YEAR
,      NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      EXCLUDE_SALVAGE_VALUE_FLAG
,      DEPRN_BASIS_FORMULA
,      DEPRN_BASIS_RULE_ID
,      POLISH_ADJ_CALC_BASIS_FLAG
,      GUARANTEE_RATE_METHOD_FLAG
,      JP_IMP_CALC_BASIS_FLAG
,      ZD_EDITION_NAME
FROM FA.FA_METHODS;

Dependencies

[top of page]

FA.FA_METHODS does not reference any database object

FA.FA_METHODS is referenced by following:

FA: FA_METHODS#