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]

VIEW: APPS.FA_BOOKS_V

Object Details

Object Name:	FA_BOOKS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OFA.FA_BOOKS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)	Refer to base table
BOOK_TYPE_CODE	VARCHAR2	(15)	Refer to base table
ASSET_ID	NUMBER	(15)	Refer to base table
DATE_PLACED_IN_SERVICE	DATE		Refer to base table
DATE_EFFECTIVE	DATE		Refer to base table
DEPRN_START_DATE	DATE		Refer to base table
DEPRN_METHOD_CODE	VARCHAR2	(12)	Refer to base table
LIFE_IN_MONTHS	NUMBER	(4)	Refer to base table
RATE_ADJUSTMENT_FACTOR	NUMBER		Refer to base table
ADJUSTED_COST	NUMBER		Refer to base table
COST	NUMBER		Refer to base table
ORIGINAL_COST	NUMBER		Refer to base table
SALVAGE_VALUE	NUMBER		Refer to base table
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Refer to base table
PRORATE_DATE	DATE		Refer to base table
COST_CHANGE_FLAG	VARCHAR2	(3)	Refer to base table
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Refer to base table
CAPITALIZE_FLAG	VARCHAR2	(3)	Refer to base table
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Refer to base table
DEPRECIATE_FLAG	VARCHAR2	(3)	Refer to base table
LAST_UPDATE_DATE	DATE		Refer to base table
LAST_UPDATED_BY	NUMBER	(15)	Refer to base table
DATE_INEFFECTIVE	DATE		Refer to base table
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Refer to base table
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)	Refer to base table
ITC_AMOUNT_ID	NUMBER	(15)	Refer to base table
ITC_AMOUNT	NUMBER		Refer to base table
RETIREMENT_ID	NUMBER	(15)	Refer to base table
TAX_REQUEST_ID	NUMBER	(15)	Refer to base table
ITC_BASIS	NUMBER		Refer to base table
BASIC_RATE	NUMBER		Refer to base table
ADJUSTED_RATE	NUMBER		Refer to base table
BONUS_RULE	VARCHAR2	(30)	Refer to base table
CEILING_NAME	VARCHAR2	(30)	Refer to base table
RECOVERABLE_COST	NUMBER		Refer to base table
ADJUSTED_RECOVERABLE_COST	NUMBER		Refer to base table
LAST_UPDATE_LOGIN	NUMBER	(15)	Refer to base table
ADJUSTED_CAPACITY	NUMBER		Refer to base table
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)	Refer to base table
IDLED_FLAG	VARCHAR2	(3)	Refer to base table
PERIOD_COUNTER_CAPITALIZED	NUMBER	(15)	Refer to base table
PERIOD_COUNTER_FULLY_RESERVED	NUMBER	(15)	Refer to base table
PERIOD_COUNTER_FULLY_RETIRED	NUMBER	(15)	Refer to base table
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)	Refer to base table
PRODUCTION_CAPACITY	NUMBER		Refer to base table
REVAL_AMORTIZATION_BASIS	NUMBER		Refer to base table
REVAL_CEILING	NUMBER		Refer to base table
UNIT_OF_MEASURE	VARCHAR2	(25)	Refer to base table
UNREVALUED_COST	NUMBER		Refer to base table
ANNUAL_DEPRN_ROUNDING_FLAG	VARCHAR2	(5)	Refer to base table
PERCENT_SALVAGE_VALUE	NUMBER		Refer to base table
ALLOWED_DEPRN_LIMIT	NUMBER		Refer to base table
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER		Refer to base table
ALLOW_REVAL_FLAG	VARCHAR2	(1)	Refer to base table
RATE_SOURCE_RULE	VARCHAR2	(10)	Refer to base table
DEPRN_BASIS_RULE	VARCHAR2	(4)	Refer to base table
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)	Refer to base table
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Refer to base table
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)	Refer to base table
CONVERSION_DATE	DATE		Refer to base table
ORIGINAL_DEPRN_START_DATE	DATE		Refer to base table
FORMULA_FACTOR	NUMBER		Refer to base table
GROUP_ASSET_ID	NUMBER	(15)	Refer to base table
SUPER_GROUP_ID	NUMBER	(15)	Refer to base table
REDUCTION_RATE	NUMBER		Refer to base table
REDUCE_ADDITION_FLAG	VARCHAR2	(1)	Refer to base table
REDUCE_ADJUSTMENT_FLAG	VARCHAR2	(1)	Refer to base table
REDUCE_RETIREMENT_FLAG	VARCHAR2	(1)	Refer to base table
OVER_DEPRECIATE_OPTION	VARCHAR2	(30)	Refer to base table
RECOGNIZE_GAIN_LOSS	VARCHAR2	(30)	Refer to base table
RECAPTURE_RESERVE_FLAG	VARCHAR2	(1)	Refer to base table
LIMIT_PROCEEDS_FLAG	VARCHAR2	(1)	Refer to base table
TERMINAL_GAIN_LOSS	VARCHAR2	(30)	Refer to base table
SALVAGE_TYPE	VARCHAR2	(30)	Refer to base table
DEPRN_LIMIT_TYPE	VARCHAR2	(30)	Refer to base table
TRACKING_METHOD	VARCHAR2	(30)	Refer to base table
ALLOCATE_TO_FULLY_RSV_FLAG	VARCHAR2	(1)	Refer to base table
ALLOCATE_TO_FULLY_RET_FLAG	VARCHAR2	(1)	Refer to base table
EXCESS_ALLOCATION_OPTION	VARCHAR2	(30)	Refer to base table
DEPRECIATION_OPTION	VARCHAR2	(30)	Refer to base table
MEMBER_ROLLUP_FLAG	VARCHAR2	(1)	Refer to base table
YTD_PROCEEDS	NUMBER		Refer to base table
LTD_PROCEEDS	NUMBER		Refer to base table
EXCLUDE_FULLY_RSV_FLAG	VARCHAR2	(1)	Refer to base table
EOFY_RESERVE	NUMBER		Refer to base table
TERMINAL_GAIN_LOSS_AMOUNT	NUMBER		Refer to base table
LTD_COST_OF_REMOVAL	NUMBER		Refer to base table
EXCLUDE_PROCEEDS_FROM_BASIS	VARCHAR2	(1)	Refer to base table
RETIREMENT_DEPRN_OPTION	VARCHAR2	(30)	Refer to base table
TERMINAL_GAIN_LOSS_FLAG	VARCHAR2	(1)	Refer to base table
DISABLED_FLAG	VARCHAR2	(1)
OLD_ADJUSTED_CAPACITY	NUMBER		Old net remaining capacity before the last depreciation run
CASH_GENERATING_UNIT_ID	NUMBER	(15)
NBV_AT_SWITCH	NUMBER
PRIOR_DEPRN_LIMIT_TYPE	VARCHAR2	(30)
PRIOR_DEPRN_LIMIT_AMOUNT	NUMBER
PRIOR_DEPRN_LIMIT	NUMBER
PRIOR_DEPRN_METHOD	VARCHAR2	(12)
PRIOR_LIFE_IN_MONTHS	NUMBER	(6)
PRIOR_BASIC_RATE	NUMBER
PRIOR_ADJUSTED_RATE	NUMBER
EXTENDED_DEPRECIATION_PERIOD	NUMBER	(15)
EXTENDED_DEPRN_FLAG	VARCHAR2	(1)

Query Text

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


SELECT ROW_ID
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DATE_PLACED_IN_SERVICE
,      DATE_EFFECTIVE
,      DEPRN_START_DATE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_COST
,      COST
,      ORIGINAL_COST
,      SALVAGE_VALUE
,      PRORATE_CONVENTION_CODE
,      PRORATE_DATE
,      COST_CHANGE_FLAG
,      ADJUSTMENT_REQUIRED_STATUS
,      CAPITALIZE_FLAG
,      RETIREMENT_PENDING_FLAG
,      DEPRECIATE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      DATE_INEFFECTIVE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      ITC_AMOUNT_ID
,      ITC_AMOUNT
,      RETIREMENT_ID
,      TAX_REQUEST_ID
,      ITC_BASIS
,      BASIC_RATE
,      ADJUSTED_RATE
,      BONUS_RULE
,      CEILING_NAME
,      RECOVERABLE_COST
,      ADJUSTED_RECOVERABLE_COST
,      LAST_UPDATE_LOGIN
,      ADJUSTED_CAPACITY
,      FULLY_RSVD_REVALS_COUNTER
,      IDLED_FLAG
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RESERVED
,      PERIOD_COUNTER_FULLY_RETIRED
,      PERIOD_COUNTER_LIFE_COMPLETE
,      PRODUCTION_CAPACITY
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      UNIT_OF_MEASURE
,      UNREVALUED_COST
,      ANNUAL_DEPRN_ROUNDING_FLAG
,      PERCENT_SALVAGE_VALUE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      ALLOW_REVAL_FLAG
,      RATE_SOURCE_RULE
,      DEPRN_BASIS_RULE
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      FORMULA_FACTOR
,      GROUP_ASSET_ID
,      SUPER_GROUP_ID
,      REDUCTION_RATE
,      REDUCE_ADDITION_FLAG
,      REDUCE_ADJUSTMENT_FLAG
,      REDUCE_RETIREMENT_FLAG
,      OVER_DEPRECIATE_OPTION
,      RECOGNIZE_GAIN_LOSS
,      RECAPTURE_RESERVE_FLAG
,      LIMIT_PROCEEDS_FLAG
,      TERMINAL_GAIN_LOSS
,      SALVAGE_TYPE
,      DEPRN_LIMIT_TYPE
,      TRACKING_METHOD
,      ALLOCATE_TO_FULLY_RSV_FLAG
,      ALLOCATE_TO_FULLY_RET_FLAG
,      EXCESS_ALLOCATION_OPTION
,      DEPRECIATION_OPTION
,      MEMBER_ROLLUP_FLAG
,      YTD_PROCEEDS
,      LTD_PROCEEDS
,      EXCLUDE_FULLY_RSV_FLAG
,      EOFY_RESERVE
,      TERMINAL_GAIN_LOSS_AMOUNT
,      LTD_COST_OF_REMOVAL
,      EXCLUDE_PROCEEDS_FROM_BASIS
,      RETIREMENT_DEPRN_OPTION
,      TERMINAL_GAIN_LOSS_FLAG
,      DISABLED_FLAG
,      OLD_ADJUSTED_CAPACITY
,      CASH_GENERATING_UNIT_ID
,      NBV_AT_SWITCH
,      PRIOR_DEPRN_LIMIT_TYPE
,      PRIOR_DEPRN_LIMIT_AMOUNT
,      PRIOR_DEPRN_LIMIT
,      PRIOR_DEPRN_METHOD
,      PRIOR_LIFE_IN_MONTHS
,      PRIOR_BASIC_RATE
,      PRIOR_ADJUSTED_RATE
,      EXTENDED_DEPRECIATION_PERIOD
,      EXTENDED_DEPRN_FLAG
FROM APPS.FA_BOOKS_V;

Dependencies

[top of page]

APPS.FA_BOOKS_V references the following:

APPS: FA_BOOKS; FA_BOOK_CONTROLS; FA_METHODS

APPS.FA_BOOKS_V is referenced by following:

APPS: FA_SORP_UPG_PKG - show dependent code