View: FAFV_BOOKS

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FAFV_BOOKS

View Text

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

Columns