VIEW: APPS.FA_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.adjusted_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.period_counter_life_complete, bk.production_capacity, bk.reval_amortization_basis, bk.reval_ceiling, bk.unit_of_measure, bk.unrevalued_cost, bk.annual_deprn_rounding_flag, bk.percent_salvage_value, bk.allowed_deprn_limit, bk.allowed_deprn_limit_amount, decode ( bc.allow_reval_flag, 'YES', 'Y', 'N') allow_reval_flag, mth.rate_source_rule, mth.deprn_basis_rule, bk.global_attribute1, bk.global_attribute2, bk.global_attribute3, bk.global_attribute4, bk.global_attribute5, bk.global_attribute6, bk.global_attribute7, bk.global_attribute8, bk.global_attribute9, bk.global_attribute10, bk.global_attribute11, bk.global_attribute12, bk.global_attribute13, bk.global_attribute14, bk.global_attribute15, bk.global_attribute16, bk.global_attribute17, bk.global_attribute18, bk.global_attribute19, bk.global_attribute20, bk.global_attribute_category, bk.short_fiscal_year_flag, bk.conversion_date, bk.original_deprn_start_date, bk.formula_factor, 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.ltd_cost_of_removal , bk.exclude_proceeds_from_basis , bk.retirement_deprn_option , bk.terminal_gain_loss_flag , bk.disabled_flag , bk.old_adjusted_capacity , bk.cash_generating_unit_id ,bk.nbv_at_switch , bk.prior_deprn_limit_type , bk.prior_deprn_limit_amount , bk.prior_deprn_limit , bk.prior_deprn_method , bk.prior_life_in_months , bk.prior_basic_rate , bk.prior_adjusted_rate , bk.extended_depreciation_period , bk.extended_deprn_flag from fa_books bk, fa_book_controls bc, fa_methods mth WHERE bk.date_ineffective is null and bk.book_type_code = bc.book_type_code and bk.deprn_method_code = mth.method_code and bk.life_in_months = mth.life_in_months UNION 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.adjusted_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.period_counter_life_complete, bk.production_capacity, bk.reval_amortization_basis, bk.reval_ceiling, bk.unit_of_measure, bk.unrevalued_cost, bk.annual_deprn_rounding_flag, bk.percent_salvage_value, bk.allowed_deprn_limit, bk.allowed_deprn_limit_amount, decode ( bc.allow_reval_flag, 'YES', 'Y', 'N') allow_reval_flag, mth.rate_source_rule, mth.deprn_basis_rule, bk.global_attribute1, bk.global_attribute2, bk.global_attribute3, bk.global_attribute4, bk.global_attribute5, bk.global_attribute6, bk.global_attribute7, bk.global_attribute8, bk.global_attribute9, bk.global_attribute10, bk.global_attribute11, bk.global_attribute12, bk.global_attribute13, bk.global_attribute14, bk.global_attribute15, bk.global_attribute16, bk.global_attribute17, bk.global_attribute18, bk.global_attribute19, bk.global_attribute20, bk.global_attribute_category, bk.short_fiscal_year_flag, bk.conversion_date, bk.original_deprn_start_date, bk.formula_factor, 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.ltd_cost_of_removal , bk.exclude_proceeds_from_basis , bk.retirement_deprn_option , bk.terminal_gain_loss_flag , bk.disabled_flag , bk.old_adjusted_capacity , bk.cash_generating_unit_id ,bk.nbv_at_switch , bk.prior_deprn_limit_type , bk.prior_deprn_limit_amount , bk.prior_deprn_limit , bk.prior_deprn_method , bk.prior_life_in_months , bk.prior_basic_rate , bk.prior_adjusted_rate , bk.extended_depreciation_period , bk.extended_deprn_flag from fa_books bk, fa_book_controls bc, fa_methods mth where bk.date_ineffective is null and bk.book_type_code = bc.book_type_code and bk.deprn_method_code = mth.method_code and bk.life_in_months is null and mth.life_in_months is null

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.ADJUSTED_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.PERIOD_COUNTER_LIFE_COMPLETE
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, DECODE ( BC.ALLOW_REVAL_FLAG
, 'YES'
, 'Y'
, 'N') ALLOW_REVAL_FLAG
, MTH.RATE_SOURCE_RULE
, MTH.DEPRN_BASIS_RULE
, BK.GLOBAL_ATTRIBUTE1
, BK.GLOBAL_ATTRIBUTE2
, BK.GLOBAL_ATTRIBUTE3
, BK.GLOBAL_ATTRIBUTE4
, BK.GLOBAL_ATTRIBUTE5
, BK.GLOBAL_ATTRIBUTE6
, BK.GLOBAL_ATTRIBUTE7
, BK.GLOBAL_ATTRIBUTE8
, BK.GLOBAL_ATTRIBUTE9
, BK.GLOBAL_ATTRIBUTE10
, BK.GLOBAL_ATTRIBUTE11
, BK.GLOBAL_ATTRIBUTE12
, BK.GLOBAL_ATTRIBUTE13
, BK.GLOBAL_ATTRIBUTE14
, BK.GLOBAL_ATTRIBUTE15
, BK.GLOBAL_ATTRIBUTE16
, BK.GLOBAL_ATTRIBUTE17
, BK.GLOBAL_ATTRIBUTE18
, BK.GLOBAL_ATTRIBUTE19
, BK.GLOBAL_ATTRIBUTE20
, BK.GLOBAL_ATTRIBUTE_CATEGORY
, BK.SHORT_FISCAL_YEAR_FLAG
, BK.CONVERSION_DATE
, BK.ORIGINAL_DEPRN_START_DATE
, BK.FORMULA_FACTOR
, 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.LTD_COST_OF_REMOVAL
, BK.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
, BK.OLD_ADJUSTED_CAPACITY
, BK.CASH_GENERATING_UNIT_ID
, BK.NBV_AT_SWITCH
, BK.PRIOR_DEPRN_LIMIT_TYPE
, BK.PRIOR_DEPRN_LIMIT_AMOUNT
, BK.PRIOR_DEPRN_LIMIT
, BK.PRIOR_DEPRN_METHOD
, BK.PRIOR_LIFE_IN_MONTHS
, BK.PRIOR_BASIC_RATE
, BK.PRIOR_ADJUSTED_RATE
, BK.EXTENDED_DEPRECIATION_PERIOD
, BK.EXTENDED_DEPRN_FLAG
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, FA_METHODS MTH
WHERE BK.DATE_INEFFECTIVE IS NULL
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.DEPRN_METHOD_CODE = MTH.METHOD_CODE
AND BK.LIFE_IN_MONTHS = MTH.LIFE_IN_MONTHS UNION 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.ADJUSTED_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.PERIOD_COUNTER_LIFE_COMPLETE
, BK.PRODUCTION_CAPACITY
, BK.REVAL_AMORTIZATION_BASIS
, BK.REVAL_CEILING
, BK.UNIT_OF_MEASURE
, BK.UNREVALUED_COST
, BK.ANNUAL_DEPRN_ROUNDING_FLAG
, BK.PERCENT_SALVAGE_VALUE
, BK.ALLOWED_DEPRN_LIMIT
, BK.ALLOWED_DEPRN_LIMIT_AMOUNT
, DECODE ( BC.ALLOW_REVAL_FLAG
, 'YES'
, 'Y'
, 'N') ALLOW_REVAL_FLAG
, MTH.RATE_SOURCE_RULE
, MTH.DEPRN_BASIS_RULE
, BK.GLOBAL_ATTRIBUTE1
, BK.GLOBAL_ATTRIBUTE2
, BK.GLOBAL_ATTRIBUTE3
, BK.GLOBAL_ATTRIBUTE4
, BK.GLOBAL_ATTRIBUTE5
, BK.GLOBAL_ATTRIBUTE6
, BK.GLOBAL_ATTRIBUTE7
, BK.GLOBAL_ATTRIBUTE8
, BK.GLOBAL_ATTRIBUTE9
, BK.GLOBAL_ATTRIBUTE10
, BK.GLOBAL_ATTRIBUTE11
, BK.GLOBAL_ATTRIBUTE12
, BK.GLOBAL_ATTRIBUTE13
, BK.GLOBAL_ATTRIBUTE14
, BK.GLOBAL_ATTRIBUTE15
, BK.GLOBAL_ATTRIBUTE16
, BK.GLOBAL_ATTRIBUTE17
, BK.GLOBAL_ATTRIBUTE18
, BK.GLOBAL_ATTRIBUTE19
, BK.GLOBAL_ATTRIBUTE20
, BK.GLOBAL_ATTRIBUTE_CATEGORY
, BK.SHORT_FISCAL_YEAR_FLAG
, BK.CONVERSION_DATE
, BK.ORIGINAL_DEPRN_START_DATE
, BK.FORMULA_FACTOR
, 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.LTD_COST_OF_REMOVAL
, BK.EXCLUDE_PROCEEDS_FROM_BASIS
, BK.RETIREMENT_DEPRN_OPTION
, BK.TERMINAL_GAIN_LOSS_FLAG
, BK.DISABLED_FLAG
, BK.OLD_ADJUSTED_CAPACITY
, BK.CASH_GENERATING_UNIT_ID
, BK.NBV_AT_SWITCH
, BK.PRIOR_DEPRN_LIMIT_TYPE
, BK.PRIOR_DEPRN_LIMIT_AMOUNT
, BK.PRIOR_DEPRN_LIMIT
, BK.PRIOR_DEPRN_METHOD
, BK.PRIOR_LIFE_IN_MONTHS
, BK.PRIOR_BASIC_RATE
, BK.PRIOR_ADJUSTED_RATE
, BK.EXTENDED_DEPRECIATION_PERIOD
, BK.EXTENDED_DEPRN_FLAG
FROM FA_BOOKS BK
, FA_BOOK_CONTROLS BC
, FA_METHODS MTH
WHERE BK.DATE_INEFFECTIVE IS NULL
AND BK.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BK.DEPRN_METHOD_CODE = MTH.METHOD_CODE
AND BK.LIFE_IN_MONTHS IS NULL
AND MTH.LIFE_IN_MONTHS IS NULL