VIEW: APPS.FABV_BOOKS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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