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_BONUS_RATES

Object Details

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

FA_BONUS_RATES stores the bonus rates used by the depreciation
program to calculate depreciation for your assets that use bonus
depreciation.
.
When you create a bonus rate using the Bonus Depreciation Rules
form, Oracle Assets inserts a row into this table for each bonus
rate you define. The master bonus rule row is in FA_BONUS_RULES
table.
.
.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_BONUS_RATES_U1	NORMAL	UNIQUE	APPS_TS_SEED	BONUS_RULE START_YEAR ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
BONUS_RULE	VARCHAR2	(30)	Yes	Name of the bonus rule
START_YEAR	NUMBER	(4)	Yes	First year of life to which this bonus rate applies
END_YEAR	NUMBER	(4)		Last year of life to which the bonus rate applies
BONUS_RATE	NUMBER		Yes	Bonus rate for the year
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	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
DEPRN_FACTOR	NUMBER			A denominator that is used to derive the depreciation rate for declining methods that function under Polish regulations.
ALTERNATE_DEPRN_FACTOR	NUMBER			The depreciation factor for the Declining Modified method.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT BONUS_RULE
,      START_YEAR
,      END_YEAR
,      BONUS_RATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      DEPRN_FACTOR
,      ALTERNATE_DEPRN_FACTOR
,      ZD_EDITION_NAME
FROM FA.FA_BONUS_RATES;

Dependencies

[top of page]

FA.FA_BONUS_RATES does not reference any database object

FA.FA_BONUS_RATES is referenced by following:

FA: FA_BONUS_RATES#