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_CATEGORY_BOOK_DEFAULTS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FA_CATEGORY_BOOK_DEFAULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CATEGORY_ID BOOK_TYPE_CODE START_DPIS

Columns

Name	Datatype	Length	Mandatory
CATEGORY_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
START_DPIS	DATE		Yes
END_DPIS	DATE
LIFE_IN_MONTHS	NUMBER	(4)
DEPRN_METHOD	VARCHAR2	(12)	Yes
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes
ITC_ELIGIBLE_FLAG	VARCHAR2	(3)	Yes
USE_ITC_CEILINGS_FLAG	VARCHAR2	(3)	Yes
CEILING_NAME	VARCHAR2	(30)
BASIC_RATE	NUMBER
ADJUSTED_RATE	NUMBER
BONUS_RULE	VARCHAR2	(30)
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes
RETIREMENT_PRORATE_CONVENTION	VARCHAR2	(10)	Yes
PRICE_INDEX_NAME	VARCHAR2	(40)
USE_STL_RETIREMENTS_FLAG	VARCHAR2	(3)	Yes
STL_METHOD_CODE	VARCHAR2	(12)
STL_LIFE_IN_MONTHS	NUMBER	(4)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
SUBCOMPONENT_LIFE_RULE	VARCHAR2	(13)
MINIMUM_LIFE_IN_MONTHS	NUMBER	(4)
PRODUCTION_CAPACITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
CAPITAL_GAIN_THRESHOLD	NUMBER
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
ATTRIBUTE_CATEGORY_CODE	VARCHAR2	(30)
USE_DEPRN_LIMITS_FLAG	VARCHAR2	(3)
ALLOWED_DEPRN_LIMIT	NUMBER
SPECIAL_DEPRN_LIMIT_AMOUNT	NUMBER
PERCENT_SALVAGE_VALUE	NUMBER
CUA_LIFE_END_DATE	DATE
CUA_RULE_SET_ID	NUMBER
GROUP_ASSET_ID	NUMBER	(15)
MASS_PROPERTY_FLAG	VARCHAR2	(1)
RECOGNIZE_GAIN_LOSS	VARCHAR2	(30)
RECAPTURE_RESERVE_FLAG	VARCHAR2	(1)
LIMIT_PROCEEDS_FLAG	VARCHAR2	(1)
TERMINAL_GAIN_LOSS	VARCHAR2	(30)
TRACKING_METHOD	VARCHAR2	(30)
EXCLUDE_FULLY_RSV_FLAG	VARCHAR2	(1)
EXCESS_ALLOCATION_OPTION	VARCHAR2	(30)
DEPRECIATION_OPTION	VARCHAR2	(30)
MEMBER_ROLLUP_FLAG	VARCHAR2	(1)
ALLOCATE_TO_FULLY_RSV_FLAG	VARCHAR2	(1)
ALLOCATE_TO_FULLY_RET_FLAG	VARCHAR2	(1)

Query Text

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


SELECT CATEGORY_ID
,      BOOK_TYPE_CODE
,      START_DPIS
,      END_DPIS
,      LIFE_IN_MONTHS
,      DEPRN_METHOD
,      PRORATE_CONVENTION_CODE
,      ITC_ELIGIBLE_FLAG
,      USE_ITC_CEILINGS_FLAG
,      CEILING_NAME
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      DEPRECIATE_FLAG
,      RETIREMENT_PRORATE_CONVENTION
,      PRICE_INDEX_NAME
,      USE_STL_RETIREMENTS_FLAG
,      STL_METHOD_CODE
,      STL_LIFE_IN_MONTHS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      SUBCOMPONENT_LIFE_RULE
,      MINIMUM_LIFE_IN_MONTHS
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      CAPITAL_GAIN_THRESHOLD
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY_CODE
,      USE_DEPRN_LIMITS_FLAG
,      ALLOWED_DEPRN_LIMIT
,      SPECIAL_DEPRN_LIMIT_AMOUNT
,      PERCENT_SALVAGE_VALUE
,      CUA_LIFE_END_DATE
,      CUA_RULE_SET_ID
,      GROUP_ASSET_ID
,      MASS_PROPERTY_FLAG
,      RECOGNIZE_GAIN_LOSS
,      RECAPTURE_RESERVE_FLAG
,      LIMIT_PROCEEDS_FLAG
,      TERMINAL_GAIN_LOSS
,      TRACKING_METHOD
,      EXCLUDE_FULLY_RSV_FLAG
,      EXCESS_ALLOCATION_OPTION
,      DEPRECIATION_OPTION
,      MEMBER_ROLLUP_FLAG
,      ALLOCATE_TO_FULLY_RSV_FLAG
,      ALLOCATE_TO_FULLY_RET_FLAG
FROM FA.FA_CATEGORY_BOOK_DEFAULTS;

Dependencies

[top of page]

FA.FA_CATEGORY_BOOK_DEFAULTS does not reference any database object

FA.FA_CATEGORY_BOOK_DEFAULTS is referenced by following:

APPS: FA_CATEGORY_BOOK_DEFAULTS