VIEW: APPS.FA_BOOK_CONTROLS_MRC_V

Source

View Text - Preformatted

SELECT FBC.BOOK_TYPE_CODE, FBC.BOOK_TYPE_NAME, FMCBC.SET_OF_BOOKS_ID, FBC.INITIAL_DATE, FMCBC.LAST_DEPRN_RUN_DATE, FBC.AMORTIZE_FLAG, FBC.FULLY_RESERVED_FLAG, FBC.DEPRN_CALENDAR, FBC.BOOK_CLASS, FBC.GL_POSTING_ALLOWED_FLAG, FMCBC.CURRENT_FISCAL_YEAR, FBC.ALLOW_MASS_CHANGES, FBC.ALLOW_DEPRN_ADJUSTMENTS, FBC.ACCOUNTING_FLEX_STRUCTURE, FMCBC.LAST_UPDATE_DATE, FMCBC.LAST_UPDATED_BY, FBC.PRORATE_CALENDAR, FBC.DATE_INEFFECTIVE, FBC.JE_RETIREMENT_CATEGORY, FBC.JE_DEPRECIATION_CATEGORY, FBC.JE_RECLASS_CATEGORY, FBC.GL_JE_SOURCE, FBC.JE_ADDITION_CATEGORY, FBC.JE_ADJUSTMENT_CATEGORY, FBC.DISTRIBUTION_SOURCE_BOOK, FBC.JE_TRANSFER_CATEGORY, FBC.COPY_RETIREMENTS_FLAG, FBC.COPY_ADJUSTMENTS_FLAG, FMCBC.DEPRN_REQUEST_ID, FBC.ALLOW_COST_CEILING, FBC.ALLOW_DEPRN_EXP_CEILING, FBC.CALCULATE_NBV, FBC.RUN_YEAR_END_PROGRAM, FBC.JE_DEFERRED_DEPRN_CATEGORY, FBC.ITC_ALLOWED_FLAG, FBC.CREATED_BY, FBC.CREATION_DATE, FMCBC.LAST_UPDATE_LOGIN, FBC.ALLOW_MASS_COPY, FBC.ALLOW_PURGE_FLAG, FBC.ALLOW_REVAL_FLAG, FBC.AMORTIZE_REVAL_RESERVE_FLAG, FBC.AP_INTERCOMPANY_ACCT, FBC.AR_INTERCOMPANY_ACCT, FBC.ATTRIBUTE1, FBC.ATTRIBUTE2, FBC.ATTRIBUTE3, FBC.ATTRIBUTE4, FBC.ATTRIBUTE5, FBC.ATTRIBUTE6, FBC.ATTRIBUTE7, FBC.ATTRIBUTE8, FBC.ATTRIBUTE9, FBC.ATTRIBUTE10, FBC.ATTRIBUTE11, FBC.ATTRIBUTE12, FBC.ATTRIBUTE13, FBC.ATTRIBUTE14, FBC.ATTRIBUTE15, FBC.ATTRIBUTE_CATEGORY_CODE, FBC.CAPITAL_GAIN_THRESHOLD, FBC.COPY_SALVAGE_VALUE_FLAG, FBC.COST_OF_REMOVAL_CLEARING_ACCT, FBC.COST_OF_REMOVAL_GAIN_ACCT, FBC.COST_OF_REMOVAL_LOSS_ACCT, FBC.DEFAULT_LIFE_EXTENSION_CEILING, FBC.DEFAULT_LIFE_EXTENSION_FACTOR, FBC.DEFAULT_MAX_FULLY_RSVD_REVALS, FBC.DEFAULT_REVAL_FULLY_RSVD_FLAG, FBC.DEFERRED_DEPRN_EXPENSE_ACCT, FBC.DEFERRED_DEPRN_RESERVE_ACCT, FBC.DEPRN_ALLOCATION_CODE, FMCBC.DEPRN_STATUS, FBC.FISCAL_YEAR_NAME, FBC.INITIAL_PERIOD_COUNTER, FBC.JE_CIP_ADJUSTMENT_CATEGORY, FBC.JE_CIP_ADDITION_CATEGORY, FBC.JE_CIP_RECLASS_CATEGORY, FBC.JE_CIP_RETIREMENT_CATEGORY, FBC.JE_CIP_REVAL_CATEGORY, FBC.JE_CIP_TRANSFER_CATEGORY, FBC.JE_REVAL_CATEGORY, FBC.LAST_MASS_COPY_PERIOD_COUNTER, FMCBC.LAST_PERIOD_COUNTER, FBC.LAST_PURGE_PERIOD_COUNTER, FBC.MASS_COPY_SOURCE_BOOK, FMCBC.MASS_REQUEST_ID, FMCBC.NBV_AMOUNT_THRESHOLD, FBC.NBV_FRACTION_THRESHOLD, FBC.NBV_RETIRED_GAIN_ACCT, FBC.NBV_RETIRED_LOSS_ACCT, FBC.PROCEEDS_OF_SALE_CLEARING_ACCT, FBC.PROCEEDS_OF_SALE_GAIN_ACCT, FBC.PROCEEDS_OF_SALE_LOSS_ACCT, FBC.REVALUE_ON_RETIREMENT_FLAG, FBC.REVAL_DEPRN_RESERVE_FLAG, FBC.REVAL_RSV_RETIRED_GAIN_ACCT, FBC.REVAL_RSV_RETIRED_LOSS_ACCT, FBC.DEPRN_ADJUSTMENT_ACCT, FBC.IMMEDIATE_COPY_FLAG, FBC.JE_DEPRN_ADJUSTMENT_CATEGORY, FBC.DEPR_FIRST_YEAR_RET_FLAG, FBC.FLEXBUILDER_DEFAULTS_CCID, FBC.RETIRE_REVAL_RESERVE_FLAG, FBC.USE_CURRENT_NBV_FOR_DEPRN, FBC.COPY_ADDITIONS_FLAG, FBC.USE_PERCENT_SALVAGE_VALUE_FLAG, FBC.REVAL_POSTING_FLAG, FBC.MC_SOURCE_FLAG, FBC.REVAL_YTD_DEPRN_FLAG, FBC.GLOBAL_ATTRIBUTE1, FBC.GLOBAL_ATTRIBUTE2, FBC.GLOBAL_ATTRIBUTE3, FBC.GLOBAL_ATTRIBUTE4, FBC.GLOBAL_ATTRIBUTE5, FBC.GLOBAL_ATTRIBUTE6, FBC.GLOBAL_ATTRIBUTE7, FBC.GLOBAL_ATTRIBUTE8, FBC.GLOBAL_ATTRIBUTE9, FBC.GLOBAL_ATTRIBUTE10, FBC.GLOBAL_ATTRIBUTE11, FBC.GLOBAL_ATTRIBUTE12, FBC.GLOBAL_ATTRIBUTE13, FBC.GLOBAL_ATTRIBUTE14, FBC.GLOBAL_ATTRIBUTE15, FBC.GLOBAL_ATTRIBUTE16, FBC.GLOBAL_ATTRIBUTE17, FBC.GLOBAL_ATTRIBUTE18, FBC.GLOBAL_ATTRIBUTE19, FBC.GLOBAL_ATTRIBUTE20, FBC.GLOBAL_ATTRIBUTE_CATEGORY, FBC.ALLOW_CIP_ASSETS_FLAG, FBC.ORG_ID, FBC.ALLOW_GROUP_DEPRN_FLAG, FBC.ALLOW_CIP_DEP_GROUP_FLAG, FBC.ALLOW_INTERCO_GROUP_FLAG, FBC.COPY_GROUP_ASSIGNMENT_FLAG, FBC.COPY_GROUP_ADDITION_FLAG, FBC.ALLOW_CIP_MEMBER_FLAG, FBC.ALLOW_MEMBER_TRACKING_FLAG, FBC.INTERCOMPANY_POSTING_FLAG, FBC.ALLOW_BACKDATED_TRANSFERS_FLAG, FBC.ALLOW_COST_SIGN_CHANGE_FLAG, FBC.CREATE_ACCOUNTING_REQUEST_ID, FBC.ALLOW_IMPAIRMENT_FLAG, FBC.COPY_AMORT_ADAJ_EXP_FLAG FROM FA_BOOK_CONTROLS FBC,FA_MC_BOOK_CONTROLS FMCBC WHERE FBC.BOOK_TYPE_CODE = FMCBC.BOOK_TYPE_CODE AND FBC.SET_OF_BOOKS_ID = FMCBC.PRIMARY_SET_OF_BOOKS_ID AND FMCBC.SET_OF_BOOKS_ID = nVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),45,10)),-1)

View Text - HTML Formatted

SELECT FBC.BOOK_TYPE_CODE
, FBC.BOOK_TYPE_NAME
, FMCBC.SET_OF_BOOKS_ID
, FBC.INITIAL_DATE
, FMCBC.LAST_DEPRN_RUN_DATE
, FBC.AMORTIZE_FLAG
, FBC.FULLY_RESERVED_FLAG
, FBC.DEPRN_CALENDAR
, FBC.BOOK_CLASS
, FBC.GL_POSTING_ALLOWED_FLAG
, FMCBC.CURRENT_FISCAL_YEAR
, FBC.ALLOW_MASS_CHANGES
, FBC.ALLOW_DEPRN_ADJUSTMENTS
, FBC.ACCOUNTING_FLEX_STRUCTURE
, FMCBC.LAST_UPDATE_DATE
, FMCBC.LAST_UPDATED_BY
, FBC.PRORATE_CALENDAR
, FBC.DATE_INEFFECTIVE
, FBC.JE_RETIREMENT_CATEGORY
, FBC.JE_DEPRECIATION_CATEGORY
, FBC.JE_RECLASS_CATEGORY
, FBC.GL_JE_SOURCE
, FBC.JE_ADDITION_CATEGORY
, FBC.JE_ADJUSTMENT_CATEGORY
, FBC.DISTRIBUTION_SOURCE_BOOK
, FBC.JE_TRANSFER_CATEGORY
, FBC.COPY_RETIREMENTS_FLAG
, FBC.COPY_ADJUSTMENTS_FLAG
, FMCBC.DEPRN_REQUEST_ID
, FBC.ALLOW_COST_CEILING
, FBC.ALLOW_DEPRN_EXP_CEILING
, FBC.CALCULATE_NBV
, FBC.RUN_YEAR_END_PROGRAM
, FBC.JE_DEFERRED_DEPRN_CATEGORY
, FBC.ITC_ALLOWED_FLAG
, FBC.CREATED_BY
, FBC.CREATION_DATE
, FMCBC.LAST_UPDATE_LOGIN
, FBC.ALLOW_MASS_COPY
, FBC.ALLOW_PURGE_FLAG
, FBC.ALLOW_REVAL_FLAG
, FBC.AMORTIZE_REVAL_RESERVE_FLAG
, FBC.AP_INTERCOMPANY_ACCT
, FBC.AR_INTERCOMPANY_ACCT
, FBC.ATTRIBUTE1
, FBC.ATTRIBUTE2
, FBC.ATTRIBUTE3
, FBC.ATTRIBUTE4
, FBC.ATTRIBUTE5
, FBC.ATTRIBUTE6
, FBC.ATTRIBUTE7
, FBC.ATTRIBUTE8
, FBC.ATTRIBUTE9
, FBC.ATTRIBUTE10
, FBC.ATTRIBUTE11
, FBC.ATTRIBUTE12
, FBC.ATTRIBUTE13
, FBC.ATTRIBUTE14
, FBC.ATTRIBUTE15
, FBC.ATTRIBUTE_CATEGORY_CODE
, FBC.CAPITAL_GAIN_THRESHOLD
, FBC.COPY_SALVAGE_VALUE_FLAG
, FBC.COST_OF_REMOVAL_CLEARING_ACCT
, FBC.COST_OF_REMOVAL_GAIN_ACCT
, FBC.COST_OF_REMOVAL_LOSS_ACCT
, FBC.DEFAULT_LIFE_EXTENSION_CEILING
, FBC.DEFAULT_LIFE_EXTENSION_FACTOR
, FBC.DEFAULT_MAX_FULLY_RSVD_REVALS
, FBC.DEFAULT_REVAL_FULLY_RSVD_FLAG
, FBC.DEFERRED_DEPRN_EXPENSE_ACCT
, FBC.DEFERRED_DEPRN_RESERVE_ACCT
, FBC.DEPRN_ALLOCATION_CODE
, FMCBC.DEPRN_STATUS
, FBC.FISCAL_YEAR_NAME
, FBC.INITIAL_PERIOD_COUNTER
, FBC.JE_CIP_ADJUSTMENT_CATEGORY
, FBC.JE_CIP_ADDITION_CATEGORY
, FBC.JE_CIP_RECLASS_CATEGORY
, FBC.JE_CIP_RETIREMENT_CATEGORY
, FBC.JE_CIP_REVAL_CATEGORY
, FBC.JE_CIP_TRANSFER_CATEGORY
, FBC.JE_REVAL_CATEGORY
, FBC.LAST_MASS_COPY_PERIOD_COUNTER
, FMCBC.LAST_PERIOD_COUNTER
, FBC.LAST_PURGE_PERIOD_COUNTER
, FBC.MASS_COPY_SOURCE_BOOK
, FMCBC.MASS_REQUEST_ID
, FMCBC.NBV_AMOUNT_THRESHOLD
, FBC.NBV_FRACTION_THRESHOLD
, FBC.NBV_RETIRED_GAIN_ACCT
, FBC.NBV_RETIRED_LOSS_ACCT
, FBC.PROCEEDS_OF_SALE_CLEARING_ACCT
, FBC.PROCEEDS_OF_SALE_GAIN_ACCT
, FBC.PROCEEDS_OF_SALE_LOSS_ACCT
, FBC.REVALUE_ON_RETIREMENT_FLAG
, FBC.REVAL_DEPRN_RESERVE_FLAG
, FBC.REVAL_RSV_RETIRED_GAIN_ACCT
, FBC.REVAL_RSV_RETIRED_LOSS_ACCT
, FBC.DEPRN_ADJUSTMENT_ACCT
, FBC.IMMEDIATE_COPY_FLAG
, FBC.JE_DEPRN_ADJUSTMENT_CATEGORY
, FBC.DEPR_FIRST_YEAR_RET_FLAG
, FBC.FLEXBUILDER_DEFAULTS_CCID
, FBC.RETIRE_REVAL_RESERVE_FLAG
, FBC.USE_CURRENT_NBV_FOR_DEPRN
, FBC.COPY_ADDITIONS_FLAG
, FBC.USE_PERCENT_SALVAGE_VALUE_FLAG
, FBC.REVAL_POSTING_FLAG
, FBC.MC_SOURCE_FLAG
, FBC.REVAL_YTD_DEPRN_FLAG
, FBC.GLOBAL_ATTRIBUTE1
, FBC.GLOBAL_ATTRIBUTE2
, FBC.GLOBAL_ATTRIBUTE3
, FBC.GLOBAL_ATTRIBUTE4
, FBC.GLOBAL_ATTRIBUTE5
, FBC.GLOBAL_ATTRIBUTE6
, FBC.GLOBAL_ATTRIBUTE7
, FBC.GLOBAL_ATTRIBUTE8
, FBC.GLOBAL_ATTRIBUTE9
, FBC.GLOBAL_ATTRIBUTE10
, FBC.GLOBAL_ATTRIBUTE11
, FBC.GLOBAL_ATTRIBUTE12
, FBC.GLOBAL_ATTRIBUTE13
, FBC.GLOBAL_ATTRIBUTE14
, FBC.GLOBAL_ATTRIBUTE15
, FBC.GLOBAL_ATTRIBUTE16
, FBC.GLOBAL_ATTRIBUTE17
, FBC.GLOBAL_ATTRIBUTE18
, FBC.GLOBAL_ATTRIBUTE19
, FBC.GLOBAL_ATTRIBUTE20
, FBC.GLOBAL_ATTRIBUTE_CATEGORY
, FBC.ALLOW_CIP_ASSETS_FLAG
, FBC.ORG_ID
, FBC.ALLOW_GROUP_DEPRN_FLAG
, FBC.ALLOW_CIP_DEP_GROUP_FLAG
, FBC.ALLOW_INTERCO_GROUP_FLAG
, FBC.COPY_GROUP_ASSIGNMENT_FLAG
, FBC.COPY_GROUP_ADDITION_FLAG
, FBC.ALLOW_CIP_MEMBER_FLAG
, FBC.ALLOW_MEMBER_TRACKING_FLAG
, FBC.INTERCOMPANY_POSTING_FLAG
, FBC.ALLOW_BACKDATED_TRANSFERS_FLAG
, FBC.ALLOW_COST_SIGN_CHANGE_FLAG
, FBC.CREATE_ACCOUNTING_REQUEST_ID
, FBC.ALLOW_IMPAIRMENT_FLAG
, FBC.COPY_AMORT_ADAJ_EXP_FLAG
FROM FA_BOOK_CONTROLS FBC
, FA_MC_BOOK_CONTROLS FMCBC
WHERE FBC.BOOK_TYPE_CODE = FMCBC.BOOK_TYPE_CODE
AND FBC.SET_OF_BOOKS_ID = FMCBC.PRIMARY_SET_OF_BOOKS_ID
AND FMCBC.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -1)