VIEW: APPS.FA_BOOKS_SUMMARY_MRC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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