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_MC_BOOKS_SUMMARY#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
SET_OF_BOOKS_ID	NUMBER	(15)	Yes
ASSET_ID	NUMBER	(15)	Yes
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes
PERIOD_COUNTER	NUMBER	(15)	Yes
FISCAL_YEAR	NUMBER	(15)
PERIOD_NUM	NUMBER	(15)
CALENDAR_PERIOD_OPEN_DATE	DATE
CALENDAR_PERIOD_CLOSE_DATE	DATE
RESET_ADJUSTED_COST_FLAG	VARCHAR2	(1)
CHANGE_IN_COST	NUMBER
CHANGE_IN_ADDITIONS_COST	NUMBER
CHANGE_IN_ADJUSTMENTS_COST	NUMBER
CHANGE_IN_RETIREMENTS_COST	NUMBER
CHANGE_IN_GROUP_REC_COST	NUMBER
CHANGE_IN_CIP_COST	NUMBER
COST	NUMBER
CIP_COST	NUMBER
SALVAGE_TYPE	VARCHAR2	(30)
PERCENT_SALVAGE_VALUE	NUMBER
SALVAGE_VALUE	NUMBER
MEMBER_SALVAGE_VALUE	NUMBER
RECOVERABLE_COST	NUMBER
DEPRN_LIMIT_TYPE	VARCHAR2	(30)
ALLOWED_DEPRN_LIMIT	NUMBER
ALLOWED_DEPRN_LIMIT_AMOUNT	NUMBER
MEMBER_DEPRN_LIMIT_AMOUNT	NUMBER
ADJUSTED_RECOVERABLE_COST	NUMBER
ADJUSTED_COST	NUMBER
DEPRECIATE_FLAG	VARCHAR2	(3)
DISABLED_FLAG	VARCHAR2	(1)
DATE_PLACED_IN_SERVICE	DATE
DEPRN_METHOD_CODE	VARCHAR2	(12)
LIFE_IN_MONTHS	NUMBER	(4)
RATE_ADJUSTMENT_FACTOR	NUMBER
ADJUSTED_RATE	NUMBER
BONUS_RULE	VARCHAR2	(30)
ADJUSTED_CAPACITY	NUMBER
PRODUCTION_CAPACITY	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(25)
REMAINING_LIFE1	NUMBER	(4)
REMAINING_LIFE2	NUMBER	(4)
FORMULA_FACTOR	NUMBER
UNREVALUED_COST	NUMBER
REVAL_AMORTIZATION_BASIS	NUMBER
REVAL_CEILING	NUMBER
CEILING_NAME	VARCHAR2	(30)
EOFY_ADJ_COST	NUMBER
EOFY_FORMULA_FACTOR	NUMBER
EOFY_RESERVE	NUMBER
EOP_ADJ_COST	NUMBER
EOP_FORMULA_FACTOR	NUMBER
SHORT_FISCAL_YEAR_FLAG	VARCHAR2	(3)
GROUP_ASSET_ID	NUMBER	(15)
SUPER_GROUP_ID	NUMBER	(15)
OVER_DEPRECIATE_OPTION	VARCHAR2	(30)
FULLY_RSVD_REVALS_COUNTER	NUMBER	(5)
CAPITALIZED_FLAG	VARCHAR2	(1)
FULLY_RESERVED_FLAG	VARCHAR2	(1)
FULLY_RETIRED_FLAG	VARCHAR2	(1)
LIFE_COMPLETE_FLAG	VARCHAR2	(1)
TERMINAL_GAIN_LOSS_AMOUNT	NUMBER
TERMINAL_GAIN_LOSS_FLAG	VARCHAR2	(1)
DEPRN_AMOUNT	NUMBER
YTD_DEPRN	NUMBER
DEPRN_RESERVE	NUMBER
BONUS_DEPRN_AMOUNT	NUMBER
BONUS_YTD_DEPRN	NUMBER
BONUS_DEPRN_RESERVE	NUMBER
BONUS_RATE	NUMBER
LTD_PRODUCTION	NUMBER
YTD_PRODUCTION	NUMBER
PRODUCTION	NUMBER
REVAL_AMORTIZATION	NUMBER
REVAL_DEPRN_EXPENSE	NUMBER
REVAL_RESERVE	NUMBER
YTD_REVAL_DEPRN_EXPENSE	NUMBER
DEPRN_OVERRIDE_FLAG	VARCHAR2	(1)
SYSTEM_DEPRN_AMOUNT	NUMBER
SYSTEM_BONUS_DEPRN_AMOUNT	NUMBER
YTD_PROCEEDS_OF_SALE	NUMBER
LTD_PROCEEDS_OF_SALE	NUMBER
YTD_COST_OF_REMOVAL	NUMBER
LTD_COST_OF_REMOVAL	NUMBER
DEPRN_ADJUSTMENT_AMOUNT	NUMBER
EXPENSE_ADJUSTMENT_AMOUNT	NUMBER
UNPLANNED_AMOUNT	NUMBER
RESERVE_ADJUSTMENT_AMOUNT	NUMBER
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
CHANGE_IN_EOFY_RESERVE	NUMBER
SWITCH_CODE	VARCHAR2	(2)
TRANSACTION_HEADER_ID_IN	NUMBER	(15)
TRANSACTION_HEADER_ID_OUT	NUMBER	(15)
POLISH_DEPRN_BASIS	NUMBER
POLISH_ADJ_REC_COST	NUMBER
IMPAIRMENT_AMOUNT	NUMBER
YTD_IMPAIRMENT	NUMBER
IMPAIRMENT_RESERVE	NUMBER
CAPITAL_ADJUSTMENT	NUMBER
GENERAL_FUND	NUMBER
REVAL_LOSS_BALANCE	NUMBER

Query Text

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


SELECT SET_OF_BOOKS_ID
,      ASSET_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      FISCAL_YEAR
,      PERIOD_NUM
,      CALENDAR_PERIOD_OPEN_DATE
,      CALENDAR_PERIOD_CLOSE_DATE
,      RESET_ADJUSTED_COST_FLAG
,      CHANGE_IN_COST
,      CHANGE_IN_ADDITIONS_COST
,      CHANGE_IN_ADJUSTMENTS_COST
,      CHANGE_IN_RETIREMENTS_COST
,      CHANGE_IN_GROUP_REC_COST
,      CHANGE_IN_CIP_COST
,      COST
,      CIP_COST
,      SALVAGE_TYPE
,      PERCENT_SALVAGE_VALUE
,      SALVAGE_VALUE
,      MEMBER_SALVAGE_VALUE
,      RECOVERABLE_COST
,      DEPRN_LIMIT_TYPE
,      ALLOWED_DEPRN_LIMIT
,      ALLOWED_DEPRN_LIMIT_AMOUNT
,      MEMBER_DEPRN_LIMIT_AMOUNT
,      ADJUSTED_RECOVERABLE_COST
,      ADJUSTED_COST
,      DEPRECIATE_FLAG
,      DISABLED_FLAG
,      DATE_PLACED_IN_SERVICE
,      DEPRN_METHOD_CODE
,      LIFE_IN_MONTHS
,      RATE_ADJUSTMENT_FACTOR
,      ADJUSTED_RATE
,      BONUS_RULE
,      ADJUSTED_CAPACITY
,      PRODUCTION_CAPACITY
,      UNIT_OF_MEASURE
,      REMAINING_LIFE1
,      REMAINING_LIFE2
,      FORMULA_FACTOR
,      UNREVALUED_COST
,      REVAL_AMORTIZATION_BASIS
,      REVAL_CEILING
,      CEILING_NAME
,      EOFY_ADJ_COST
,      EOFY_FORMULA_FACTOR
,      EOFY_RESERVE
,      EOP_ADJ_COST
,      EOP_FORMULA_FACTOR
,      SHORT_FISCAL_YEAR_FLAG
,      GROUP_ASSET_ID
,      SUPER_GROUP_ID
,      OVER_DEPRECIATE_OPTION
,      FULLY_RSVD_REVALS_COUNTER
,      CAPITALIZED_FLAG
,      FULLY_RESERVED_FLAG
,      FULLY_RETIRED_FLAG
,      LIFE_COMPLETE_FLAG
,      TERMINAL_GAIN_LOSS_AMOUNT
,      TERMINAL_GAIN_LOSS_FLAG
,      DEPRN_AMOUNT
,      YTD_DEPRN
,      DEPRN_RESERVE
,      BONUS_DEPRN_AMOUNT
,      BONUS_YTD_DEPRN
,      BONUS_DEPRN_RESERVE
,      BONUS_RATE
,      LTD_PRODUCTION
,      YTD_PRODUCTION
,      PRODUCTION
,      REVAL_AMORTIZATION
,      REVAL_DEPRN_EXPENSE
,      REVAL_RESERVE
,      YTD_REVAL_DEPRN_EXPENSE
,      DEPRN_OVERRIDE_FLAG
,      SYSTEM_DEPRN_AMOUNT
,      SYSTEM_BONUS_DEPRN_AMOUNT
,      YTD_PROCEEDS_OF_SALE
,      LTD_PROCEEDS_OF_SALE
,      YTD_COST_OF_REMOVAL
,      LTD_COST_OF_REMOVAL
,      DEPRN_ADJUSTMENT_AMOUNT
,      EXPENSE_ADJUSTMENT_AMOUNT
,      UNPLANNED_AMOUNT
,      RESERVE_ADJUSTMENT_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CHANGE_IN_EOFY_RESERVE
,      SWITCH_CODE
,      TRANSACTION_HEADER_ID_IN
,      TRANSACTION_HEADER_ID_OUT
,      POLISH_DEPRN_BASIS
,      POLISH_ADJ_REC_COST
,      IMPAIRMENT_AMOUNT
,      YTD_IMPAIRMENT
,      IMPAIRMENT_RESERVE
,      CAPITAL_ADJUSTMENT
,      GENERAL_FUND
,      REVAL_LOSS_BALANCE
FROM FA.FA_MC_BOOKS_SUMMARY#;

Dependencies

[top of page]

FA.FA_MC_BOOKS_SUMMARY# references the following:

FA: FA_MC_BOOKS_SUMMARY

FA.FA_MC_BOOKS_SUMMARY# is referenced by following:

APPS: FA_MC_BOOKS_SUMMARY