Product: | OFA - Assets |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.FA_BOOK_CONTROLS_MRC_V |
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)