VIEW: APPS.FAFV_BOOKS

Source

View Text - Preformatted

SELECT BC.BOOK_TYPE_CODE , BC.BOOK_TYPE_NAME , BC.INITIAL_DATE , BC.LAST_DEPRN_RUN_DATE , BC.AMORTIZE_FLAG , BC.DEPRN_CALENDAR , BC.BOOK_CLASS , BC.GL_POSTING_ALLOWED_FLAG, BC.CURRENT_FISCAL_YEAR , BC.ALLOW_MASS_CHANGES , BC.ALLOW_DEPRN_ADJUSTMENTS , BC.PRORATE_CALENDAR , BC.DATE_INEFFECTIVE , BC.JE_RETIREMENT_CATEGORY, BC.JE_DEPRECIATION_CATEGORY , BC.JE_RECLASS_CATEGORY , BC.GL_JE_SOURCE , BC.JE_ADDITION_CATEGORY , BC.JE_ADJUSTMENT_CATEGORY , BC.DISTRIBUTION_SOURCE_BOOK, BC.JE_TRANSFER_CATEGORY , BC.COPY_RETIREMENTS_FLAG , BC.COPY_ADJUSTMENTS_FLAG, BC.ALLOW_COST_CEILING , BC.ALLOW_DEPRN_EXP_CEILING , BC.JE_DEFERRED_DEPRN_CATEGORY, BC.ITC_ALLOWED_FLAG , BC.ALLOW_MASS_COPY , BC.ALLOW_PURGE_FLAG , BC.ALLOW_REVAL_FLAG, BC.AMORTIZE_REVAL_RESERVE_FLAG , BC.AP_INTERCOMPANY_ACCT , BC.AR_INTERCOMPANY_ACCT , BC.CAPITAL_GAIN_THRESHOLD , BC.COPY_SALVAGE_VALUE_FLAG , BC.COST_OF_REMOVAL_CLEARING_ACCT , BC.COST_OF_REMOVAL_GAIN_ACCT , BC.COST_OF_REMOVAL_LOSS_ACCT , BC.DEFAULT_LIFE_EXTENSION_CEILING , BC.DEFAULT_LIFE_EXTENSION_FACTOR , BC.DEFERRED_DEPRN_EXPENSE_ACCT , BC.DEFERRED_DEPRN_RESERVE_ACCT , BC.FISCAL_YEAR_NAME, BC.JE_CIP_ADJUSTMENT_CATEGORY , BC.JE_CIP_ADDITION_CATEGORY , BC.JE_CIP_RECLASS_CATEGORY, BC.JE_CIP_RETIREMENT_CATEGORY , BC.JE_CIP_REVAL_CATEGORY , BC.JE_CIP_TRANSFER_CATEGORY , BC.JE_REVAL_CATEGORY , BC.MASS_COPY_SOURCE_BOOK , BC.NBV_RETIRED_GAIN_ACCT , BC.NBV_RETIRED_LOSS_ACCT , BC.PROCEEDS_OF_SALE_CLEARING_ACCT , BC.PROCEEDS_OF_SALE_GAIN_ACCT , BC.PROCEEDS_OF_SALE_LOSS_ACCT , BC.REVALUE_ON_RETIREMENT_FLAG, BC.REVAL_DEPRN_RESERVE_FLAG , BC.REVAL_RSV_RETIRED_GAIN_ACCT, BC.REVAL_RSV_RETIRED_LOSS_ACCT , BC.DEPRN_ADJUSTMENT_ACCT , BC.JE_DEPRN_ADJUSTMENT_CATEGORY , BC.DEPR_FIRST_YEAR_RET_FLAG , BC.RETIRE_REVAL_RESERVE_FLAG , BC.COPY_ADDITIONS_FLAG , BC.MC_SOURCE_FLAG , BC.SET_OF_BOOKS_ID , SB.NAME , BC.LAST_PERIOD_COUNTER , DP.PERIOD_NAME , BC.LAST_UPDATE_DATE , BC.LAST_UPDATED_BY , BC.CREATED_BY , BC.CREATION_DATE FROM FA_BOOK_CONTROLS BC, FA_DEPRN_PERIODS DP, GL_SETS_OF_BOOKS SB WHERE BC.LAST_PERIOD_COUNTER = DP.PERIOD_COUNTER AND BC.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY

View Text - HTML Formatted

SELECT BC.BOOK_TYPE_CODE
, BC.BOOK_TYPE_NAME
, BC.INITIAL_DATE
, BC.LAST_DEPRN_RUN_DATE
, BC.AMORTIZE_FLAG
, BC.DEPRN_CALENDAR
, BC.BOOK_CLASS
, BC.GL_POSTING_ALLOWED_FLAG
, BC.CURRENT_FISCAL_YEAR
, BC.ALLOW_MASS_CHANGES
, BC.ALLOW_DEPRN_ADJUSTMENTS
, BC.PRORATE_CALENDAR
, BC.DATE_INEFFECTIVE
, BC.JE_RETIREMENT_CATEGORY
, BC.JE_DEPRECIATION_CATEGORY
, BC.JE_RECLASS_CATEGORY
, BC.GL_JE_SOURCE
, BC.JE_ADDITION_CATEGORY
, BC.JE_ADJUSTMENT_CATEGORY
, BC.DISTRIBUTION_SOURCE_BOOK
, BC.JE_TRANSFER_CATEGORY
, BC.COPY_RETIREMENTS_FLAG
, BC.COPY_ADJUSTMENTS_FLAG
, BC.ALLOW_COST_CEILING
, BC.ALLOW_DEPRN_EXP_CEILING
, BC.JE_DEFERRED_DEPRN_CATEGORY
, BC.ITC_ALLOWED_FLAG
, BC.ALLOW_MASS_COPY
, BC.ALLOW_PURGE_FLAG
, BC.ALLOW_REVAL_FLAG
, BC.AMORTIZE_REVAL_RESERVE_FLAG
, BC.AP_INTERCOMPANY_ACCT
, BC.AR_INTERCOMPANY_ACCT
, BC.CAPITAL_GAIN_THRESHOLD
, BC.COPY_SALVAGE_VALUE_FLAG
, BC.COST_OF_REMOVAL_CLEARING_ACCT
, BC.COST_OF_REMOVAL_GAIN_ACCT
, BC.COST_OF_REMOVAL_LOSS_ACCT
, BC.DEFAULT_LIFE_EXTENSION_CEILING
, BC.DEFAULT_LIFE_EXTENSION_FACTOR
, BC.DEFERRED_DEPRN_EXPENSE_ACCT
, BC.DEFERRED_DEPRN_RESERVE_ACCT
, BC.FISCAL_YEAR_NAME
, BC.JE_CIP_ADJUSTMENT_CATEGORY
, BC.JE_CIP_ADDITION_CATEGORY
, BC.JE_CIP_RECLASS_CATEGORY
, BC.JE_CIP_RETIREMENT_CATEGORY
, BC.JE_CIP_REVAL_CATEGORY
, BC.JE_CIP_TRANSFER_CATEGORY
, BC.JE_REVAL_CATEGORY
, BC.MASS_COPY_SOURCE_BOOK
, BC.NBV_RETIRED_GAIN_ACCT
, BC.NBV_RETIRED_LOSS_ACCT
, BC.PROCEEDS_OF_SALE_CLEARING_ACCT
, BC.PROCEEDS_OF_SALE_GAIN_ACCT
, BC.PROCEEDS_OF_SALE_LOSS_ACCT
, BC.REVALUE_ON_RETIREMENT_FLAG
, BC.REVAL_DEPRN_RESERVE_FLAG
, BC.REVAL_RSV_RETIRED_GAIN_ACCT
, BC.REVAL_RSV_RETIRED_LOSS_ACCT
, BC.DEPRN_ADJUSTMENT_ACCT
, BC.JE_DEPRN_ADJUSTMENT_CATEGORY
, BC.DEPR_FIRST_YEAR_RET_FLAG
, BC.RETIRE_REVAL_RESERVE_FLAG
, BC.COPY_ADDITIONS_FLAG
, BC.MC_SOURCE_FLAG
, BC.SET_OF_BOOKS_ID
, SB.NAME
, BC.LAST_PERIOD_COUNTER
, DP.PERIOD_NAME
, BC.LAST_UPDATE_DATE
, BC.LAST_UPDATED_BY
, BC.CREATED_BY
, BC.CREATION_DATE
FROM FA_BOOK_CONTROLS BC
, FA_DEPRN_PERIODS DP
, GL_SETS_OF_BOOKS SB
WHERE BC.LAST_PERIOD_COUNTER = DP.PERIOD_COUNTER
AND BC.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID WITH READ ONLY