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: FA.FA_BOOKS#

Object Details

Object Name:	FA_BOOKS#
Object Type:	VIEW
Owner:	FA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
ASSET_ID	NUMBER	(15)	Yes
DATE_PLACED_IN_SERVICE	DATE		Yes
DATE_EFFECTIVE	DATE		Yes
DEPRN_START_DATE	DATE		Yes
DEPRN_METHOD_CODE	VARCHAR2	(12)	Yes
LIFE_IN_MONTHS	NUMBER	(4)
RATE_ADJUSTMENT_FACTOR	NUMBER		Yes
ADJUSTED_COST	NUMBER		Yes
COST	NUMBER		Yes
ORIGINAL_COST	NUMBER		Yes
SALVAGE_VALUE	NUMBER		Yes
PRORATE_CONVENTION_CODE	VARCHAR2	(10)	Yes
PRORATE_DATE	DATE		Yes
COST_CHANGE_FLAG	VARCHAR2	(3)	Yes
ADJUSTMENT_REQUIRED_STATUS	VARCHAR2	(4)	Yes
CAPITALIZE_FLAG	VARCHAR2	(3)	Yes
RETIREMENT_PENDING_FLAG	VARCHAR2	(3)	Yes
DEPRECIATE_FLAG	VARCHAR2	(3)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
DATE_INEFFECTIVE	DATE
TRANSACTION_HEADER_ID_IN	NUMBER	(15)	Yes
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		Yes
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)
PRODUCTION_CAPACITY	NUMBER
REVAL_AMORTIZATION_BASIS	NUMBER
REVAL_CEILING	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
UNREVALUED_COST	NUMBER		Yes
ANNUAL_DEPRN_ROUNDING_FLAG	VARCHAR2	(5)
PERCENT_SALVAGE_VALUE	NUMBER
ALLOWED_DEPRN_LIMIT	NUMBER
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER
PERIOD_COUNTER_LIFE_COMPLETE	NUMBER	(15)
ADJUSTED_RECOVERABLE_COST	NUMBER
ANNUAL_ROUNDING_FLAG	VARCHAR2	(5)
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)
EOFY_ADJ_COST	NUMBER
EOFY_FORMULA_FACTOR	NUMBER
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)
CONVERSION_DATE	DATE
ORIGINAL_DEPRN_START_DATE	DATE
REMAINING_LIFE1	NUMBER	(4)
REMAINING_LIFE2	NUMBER	(4)
OLD_ADJUSTED_COST	NUMBER
FORMULA_FACTOR	NUMBER
GROUP_ASSET_ID	NUMBER	(15)
SALVAGE_TYPE	VARCHAR2	(30)	Yes
DEPRN_LIMIT_TYPE	VARCHAR2	(30)	Yes
REDUCTION_RATE	NUMBER
REDUCE_ADDITION_FLAG	VARCHAR2	(1)
REDUCE_ADJUSTMENT_FLAG	VARCHAR2	(1)
REDUCE_RETIREMENT_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)
TERMINAL_GAIN_LOSS_AMOUNT	NUMBER
CIP_COST	NUMBER
YTD_PROCEEDS	NUMBER
LTD_PROCEEDS	NUMBER
LTD_COST_OF_REMOVAL	NUMBER
EOFY_RESERVE	NUMBER
PRIOR_EOFY_RESERVE	NUMBER
EOP_ADJ_COST	NUMBER
EOP_FORMULA_FACTOR	NUMBER
EXCLUDE_PROCEEDS_FROM_BASIS	VARCHAR2	(1)
RETIREMENT_DEPRN_OPTION	VARCHAR2	(30)
TERMINAL_GAIN_LOSS_FLAG	VARCHAR2	(1)
SUPER_GROUP_ID	NUMBER	(15)
OVER_DEPRECIATE_OPTION	VARCHAR2	(30)
DISABLED_FLAG	VARCHAR2	(1)
OLD_ADJUSTED_CAPACITY	NUMBER
DRY_HOLE_FLAG	VARCHAR2	(1)
CASH_GENERATING_UNIT_ID	NUMBER	(15)
CONTRACT_ID	NUMBER
EXTENDED_DEPRN_FLAG	VARCHAR2	(1)
EXTENDED_DEPRECIATION_PERIOD	NUMBER	(15)
PERIOD_COUNTER_FULLY_EXTENDED	NUMBER	(15)
RATE_IN_USE	NUMBER
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

Query Text

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


SELECT 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
,      LAST_UPDATE_LOGIN
,      ADJUSTED_CAPACITY
,      FULLY_RSVD_REVALS_COUNTER
,      IDLED_FLAG
,      PERIOD_COUNTER_CAPITALIZED
,      PERIOD_COUNTER_FULLY_RESERVED
,      PERIOD_COUNTER_FULLY_RETIRED
,      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
,      PERIOD_COUNTER_LIFE_COMPLETE
,      ADJUSTED_RECOVERABLE_COST
,      ANNUAL_ROUNDING_FLAG
,      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
,      EOFY_ADJ_COST
,      EOFY_FORMULA_FACTOR
,      SHORT_FISCAL_YEAR_FLAG
,      CONVERSION_DATE
,      ORIGINAL_DEPRN_START_DATE
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      OLD_ADJUSTED_COST
,      FORMULA_FACTOR
,      GROUP_ASSET_ID
,      SALVAGE_TYPE
,      DEPRN_LIMIT_TYPE
,      REDUCTION_RATE
,      REDUCE_ADDITION_FLAG
,      REDUCE_ADJUSTMENT_FLAG
,      REDUCE_RETIREMENT_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
,      TERMINAL_GAIN_LOSS_AMOUNT
,      CIP_COST
,      YTD_PROCEEDS
,      LTD_PROCEEDS
,      LTD_COST_OF_REMOVAL
,      EOFY_RESERVE
,      PRIOR_EOFY_RESERVE
,      EOP_ADJ_COST
,      EOP_FORMULA_FACTOR
,      EXCLUDE_PROCEEDS_FROM_BASIS
,      RETIREMENT_DEPRN_OPTION
,      TERMINAL_GAIN_LOSS_FLAG
,      SUPER_GROUP_ID
,      OVER_DEPRECIATE_OPTION
,      DISABLED_FLAG
,      OLD_ADJUSTED_CAPACITY
,      DRY_HOLE_FLAG
,      CASH_GENERATING_UNIT_ID
,      CONTRACT_ID
,      EXTENDED_DEPRN_FLAG
,      EXTENDED_DEPRECIATION_PERIOD
,      PERIOD_COUNTER_FULLY_EXTENDED
,      RATE_IN_USE
,      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
FROM FA.FA_BOOKS#;

Dependencies

[top of page]

FA.FA_BOOKS# references the following:

FA: FA_BOOKS

FA.FA_BOOKS# is referenced by following:

APPS: FA_BOOKS; FA_BOOKS_BAS; JL_ZZ_FA_BOOKS_GLOB_FLEX_RL; JL_ZZ_FA_BOOKS_GLOB_FLEX_SL