VIEW: APPS.FA_QUICK_BOOKS_V

Source

View Text - Preformatted

SELECT BK.ROWID ROW_ID , BK.BOOK_TYPE_CODE , BK.ASSET_ID , BK.DATE_PLACED_IN_SERVICE , BK.DATE_EFFECTIVE , BK.DEPRN_START_DATE , BK.DEPRN_METHOD_CODE , BK.LIFE_IN_MONTHS , BK.RATE_ADJUSTMENT_FACTOR , BK.ADJUSTED_COST , BK.COST , BK.ORIGINAL_COST , BK.SALVAGE_VALUE , BK.PRORATE_CONVENTION_CODE , BK.PRORATE_DATE , BK.COST_CHANGE_FLAG , BK.ADJUSTMENT_REQUIRED_STATUS , BK.CAPITALIZE_FLAG , BK.RETIREMENT_PENDING_FLAG , BK.DEPRECIATE_FLAG , BK.LAST_UPDATE_DATE , BK.LAST_UPDATED_BY , BK.DATE_INEFFECTIVE , BK.TRANSACTION_HEADER_ID_IN , BK.TRANSACTION_HEADER_ID_OUT , BK.ITC_AMOUNT_ID , BK.ITC_AMOUNT , BK.RETIREMENT_ID , BK.TAX_REQUEST_ID , BK.ITC_BASIS , BK.BASIC_RATE , BK.ADJUSTED_RATE , BK.BONUS_RULE , BK.CEILING_NAME , BK.RECOVERABLE_COST , BK.LAST_UPDATE_LOGIN , BK.ADJUSTED_CAPACITY , BK.FULLY_RSVD_REVALS_COUNTER , BK.IDLED_FLAG , BK.PERIOD_COUNTER_CAPITALIZED , BK.PERIOD_COUNTER_FULLY_RESERVED , BK.PERIOD_COUNTER_FULLY_RETIRED , BK.PRODUCTION_CAPACITY , BK.REVAL_AMORTIZATION_BASIS , BK.REVAL_CEILING , BK.UNIT_OF_MEASURE , BK.UNREVALUED_COST , BK.PERIOD_COUNTER_LIFE_COMPLETE , BK.ALLOWED_DEPRN_LIMIT , BK.ALLOWED_DEPRN_LIMIT_AMOUNT , BK.PERCENT_SALVAGE_VALUE , BK.ADJUSTED_RECOVERABLE_COST , BC.ACCOUNTING_FLEX_STRUCTURE ACCT_FLEX_NUM , BK.GROUP_ASSET_ID , BK.SUPER_GROUP_ID , BK.REDUCTION_RATE , BK.REDUCE_ADDITION_FLAG , BK.REDUCE_ADJUSTMENT_FLAG , BK.REDUCE_RETIREMENT_FLAG , BK.OVER_DEPRECIATE_OPTION , BK.RECOGNIZE_GAIN_LOSS , BK.RECAPTURE_RESERVE_FLAG , BK.LIMIT_PROCEEDS_FLAG , BK.TERMINAL_GAIN_LOSS , BK.SALVAGE_TYPE , BK.DEPRN_LIMIT_TYPE , BK.TRACKING_METHOD , BK.ALLOCATE_TO_FULLY_RSV_FLAG , BK.ALLOCATE_TO_FULLY_RET_FLAG , BK.EXCESS_ALLOCATION_OPTION , BK.DEPRECIATION_OPTION , BK.MEMBER_ROLLUP_FLAG , BK.YTD_PROCEEDS , BK.LTD_PROCEEDS , BK.EXCLUDE_FULLY_RSV_FLAG , BK.EOFY_RESERVE , BK.TERMINAL_GAIN_LOSS_AMOUNT , BK.EXCLUDE_PROCEEDS_FROM_BASIS , BK.RETIREMENT_DEPRN_OPTION ,bk.terminal_gain_loss_flag ,bk.disabled_flag FROM FA_BOOKS BK , FA_BOOK_CONTROLS BC WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE

View Text - HTML Formatted

SELECT BK.ROWID ROW_ID
, BK.BOOK_TYPE_CODE
, BK.ASSET_ID
, BK.DATE_PLACED_IN_SERVICE
, BK.DATE_EFFECTIVE
, BK.DEPRN_START_DATE
, BK.DEPRN_METHOD_CODE
, BK.LIFE_IN_MONTHS
, BK.RATE_ADJUSTMENT_FACTOR
, BK.ADJUSTED_COST
, BK.COST
, BK.ORIGINAL_COST
, BK.SALVAGE_VALUE
, BK.PRORATE_CONVENTION_CODE
, BK.PRORATE_DATE
, BK.COST_CHANGE_FLAG
, BK.ADJUSTMENT_REQUIRED_STATUS
, BK.CAPITALIZE_FLAG
, BK.RETIREMENT_PENDING_FLAG
, BK.DEPRECIATE_FLAG
, BK.LAST_UPDATE_DATE
, BK.LAST_UPDATED_BY
, BK.DATE_INEFFECTIVE
, BK.TRANSACTION_HEADER_ID_IN
, BK.TRANSACTION_HEADER_ID_OUT
, BK.ITC_AMOUNT_ID
, BK.ITC_AMOUNT
, BK.RETIREMENT_ID
, BK.TAX_REQUEST_ID
, BK.ITC_BASIS
, BK.BASIC_RATE
, BK.ADJUSTED_RATE
, BK.BONUS_RULE
, BK.CEILING_NAME
, BK.RECOVERABLE_COST
, BK.LAST_UPDATE_LOGIN
, BK.ADJUSTED_CAPACITY
, BK.FULLY_RSVD_REVALS_COUNTER
, BK.IDLED_FLAG
, BK.PERIOD_COUNTER_CAPITALIZED
, BK.PERIOD_COUNTER_FULLY_RESERVED
, BK.PERIOD_COUNTER_FULLY_RETIRED
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.PERIOD_COUNTER_LIFE_COMPLETE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, BK.PERCENT_SALVAGE_VALUE
, BK.ADJUSTED_RECOVERABLE_COST
, BC.ACCOUNTING_FLEX_STRUCTURE ACCT_FLEX_NUM
, BK.GROUP_ASSET_ID
, BK.SUPER_GROUP_ID
, BK.REDUCTION_RATE
, BK.REDUCE_ADDITION_FLAG
, BK.REDUCE_ADJUSTMENT_FLAG
, BK.REDUCE_RETIREMENT_FLAG
, BK.OVER_DEPRECIATE_OPTION
, BK.RECOGNIZE_GAIN_LOSS
, BK.RECAPTURE_RESERVE_FLAG
, BK.LIMIT_PROCEEDS_FLAG
, BK.TERMINAL_GAIN_LOSS
, BK.SALVAGE_TYPE
, BK.DEPRN_LIMIT_TYPE
, BK.TRACKING_METHOD
, BK.ALLOCATE_TO_FULLY_RSV_FLAG
, BK.ALLOCATE_TO_FULLY_RET_FLAG
, BK.EXCESS_ALLOCATION_OPTION
, BK.DEPRECIATION_OPTION
, BK.MEMBER_ROLLUP_FLAG
, BK.YTD_PROCEEDS
, BK.LTD_PROCEEDS
, BK.EXCLUDE_FULLY_RSV_FLAG
, BK.EOFY_RESERVE
, BK.TERMINAL_GAIN_LOSS_AMOUNT
, BK.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
WHERE BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE