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 Source]

Columns

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

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
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 not referenced by any database object