eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: FA_BOOK_CONTROLS

Product:	OFA - Assets
Description:	Control information that affects all assets in a depreciation book
Implementation/DBA Data:	FA.FA_BOOK_CONTROLS

Primary Key: FA_BOOK_CONTROLS_PK

BOOK_TYPE_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
FA_BOOK_CONTROLS	FA_CALENDAR_TYPES	FA_BOOK_CONTROLS.DEPRN_CALENDAR
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_RETIREMENT_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_DEPRECIATION_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_RECLASS_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_ADDITION_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_TRANSFER_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_DEFERRED_DEPRN_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_ADDITION_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_RECLASS_CATEGORY
FA_BOOK_CONTROLS	GL_SETS_OF_BOOKS_11I	FA_BOOK_CONTROLS.SET_OF_BOOKS_ID
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_RETIREMENT_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_REVAL_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_CIP_TRANSFER_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_REVAL_CATEGORY
FA_BOOK_CONTROLS	GL_JE_CATEGORIES_TL	FA_BOOK_CONTROLS.JE_DEPRN_ADJUSTMENT_CATEGORY
FA_BOOK_CONTROLS	FA_BOOK_CONTROLS	FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK
FA_BOOK_CONTROLS	FND_CONCURRENT_REQUESTS	FA_BOOK_CONTROLS.MASS_REQUEST_ID
FA_BOOK_CONTROLS	GL_CODE_COMBINATIONS	FA_BOOK_CONTROLS.FLEXBUILDER_DEFAULTS_CCID
FA_BOOK_CONTROLS	FA_BOOK_CONTROLS	FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_PURGE_PERIOD_COUNTER
FA_BOOK_CONTROLS	FND_CONCURRENT_REQUESTS	FA_BOOK_CONTROLS.CREATE_ACCOUNTING_REQUEST_ID
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.INITIAL_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_DEPRN_PERIODS	FA_BOOK_CONTROLS.BOOK_TYPE_CODE FA_BOOK_CONTROLS.LAST_MASS_COPY_PERIOD_COUNTER
FA_BOOK_CONTROLS	FA_CALENDAR_TYPES	FA_BOOK_CONTROLS.PRORATE_CALENDAR
FA_BOOK_CONTROLS	FND_CONCURRENT_REQUESTS	FA_BOOK_CONTROLS.DEPRN_REQUEST_ID
FA_BOOK_CONTROLS	FA_FISCAL_YEAR	FA_BOOK_CONTROLS.CURRENT_FISCAL_YEAR FA_BOOK_CONTROLS.FISCAL_YEAR_NAME
CSI_I_ASSETS	FA_BOOK_CONTROLS	CSI_I_ASSETS.FA_BOOK_TYPE_CODE
FA_ADJUSTMENTS	FA_BOOK_CONTROLS	FA_ADJUSTMENTS.BOOK_TYPE_CODE
FA_ARCHIVE_HISTORY	FA_BOOK_CONTROLS	FA_ARCHIVE_HISTORY.BOOK_TYPE_CODE
FA_BOOKS	FA_BOOK_CONTROLS	FA_BOOKS.BOOK_TYPE_CODE
FA_BOOKS_SUMMARY	FA_BOOK_CONTROLS	FA_BOOKS_SUMMARY.BOOK_TYPE_CODE
FA_BOOK_CONTROLS	FA_BOOK_CONTROLS	FA_BOOK_CONTROLS.MASS_COPY_SOURCE_BOOK
FA_BOOK_CONTROLS	FA_BOOK_CONTROLS	FA_BOOK_CONTROLS.DISTRIBUTION_SOURCE_BOOK
FA_BUDGET_DISTRIBUTION	FA_BOOK_CONTROLS	FA_BUDGET_DISTRIBUTION.BOOK_TYPE_CODE
%	FA_BOOK_CONTROLS
FA_CATEGORY_BOOKS	FA_BOOK_CONTROLS	FA_CATEGORY_BOOKS.BOOK_TYPE_CODE
FA_CATEGORY_BOOK_DEFAULTS	FA_BOOK_CONTROLS	FA_CATEGORY_BOOK_DEFAULTS.BOOK_TYPE_CODE
FA_DEFERRED_DEPRN	FA_BOOK_CONTROLS	FA_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_DEFERRED_DEPRN	FA_BOOK_CONTROLS	FA_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_DELETED_MASS_ADDITIONS	FA_BOOK_CONTROLS	FA_DELETED_MASS_ADDITIONS.BOOK_TYPE_CODE
FA_DEPRN_DETAIL	FA_BOOK_CONTROLS	FA_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_DEPRN_OVERRIDE	FA_BOOK_CONTROLS	FA_DEPRN_OVERRIDE.BOOK_TYPE_CODE
FA_DEPRN_PERIODS	FA_BOOK_CONTROLS	FA_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_DEPRN_SUMMARY	FA_BOOK_CONTROLS	FA_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_DISTRIBUTION_ACCOUNTS	FA_BOOK_CONTROLS	FA_DISTRIBUTION_ACCOUNTS.BOOK_TYPE_CODE
FA_DISTRIBUTION_HISTORY	FA_BOOK_CONTROLS	FA_DISTRIBUTION_HISTORY.BOOK_TYPE_CODE
FA_DISTRIBUTION_SETS	FA_BOOK_CONTROLS	FA_DISTRIBUTION_SETS.BOOK_TYPE_CODE
FA_INS_POLICIES	FA_BOOK_CONTROLS	FA_INS_POLICIES.BOOK_TYPE_CODE
FA_INVOICE_TRANSACTIONS	FA_BOOK_CONTROLS	FA_INVOICE_TRANSACTIONS.BOOK_TYPE_CODE
FA_MAINT_EVENTS	FA_BOOK_CONTROLS	FA_MAINT_EVENTS.BOOK_TYPE_CODE
FA_MAINT_SCHEDULE_HDR	FA_BOOK_CONTROLS	FA_MAINT_SCHEDULE_HDR.BOOK_TYPE_CODE
%	FA_BOOK_CONTROLS
FA_MASS_ADDITIONS	FA_BOOK_CONTROLS	FA_MASS_ADDITIONS.BOOK_TYPE_CODE
FA_MASS_CHANGES	FA_BOOK_CONTROLS	FA_MASS_CHANGES.BOOK_TYPE_CODE
FA_MASS_CHANGES_ITF	FA_BOOK_CONTROLS	FA_MASS_CHANGES_ITF.BOOK
FA_MASS_RECLASS	FA_BOOK_CONTROLS	FA_MASS_RECLASS.BOOK_TYPE_CODE
FA_MASS_RECLASS_ITF	FA_BOOK_CONTROLS	FA_MASS_RECLASS_ITF.BOOK
FA_MASS_RETIREMENTS	FA_BOOK_CONTROLS	FA_MASS_RETIREMENTS.BOOK_TYPE_CODE
FA_MASS_REVALUATIONS	FA_BOOK_CONTROLS	FA_MASS_REVALUATIONS.BOOK_TYPE_CODE
FA_MASS_REVAL_REP_ITF	FA_BOOK_CONTROLS	FA_MASS_REVAL_REP_ITF.BOOK_TYPE_CODE
FA_MASS_TAX_ADJUSTMENTS	FA_BOOK_CONTROLS	FA_MASS_TAX_ADJUSTMENTS.ADJUSTED_BOOK_TYPE_CODE
FA_MASS_TAX_ADJUSTMENTS	FA_BOOK_CONTROLS	FA_MASS_TAX_ADJUSTMENTS.CONTROL_BOOK_TYPE_CODE
FA_MASS_TRANSFERS	FA_BOOK_CONTROLS	FA_MASS_TRANSFERS.BOOK_TYPE_CODE
FA_MC_ADJUSTMENTS	FA_BOOK_CONTROLS	FA_MC_ADJUSTMENTS.BOOK_TYPE_CODE
FA_MC_BOOKS_RATES	FA_BOOK_CONTROLS	FA_MC_BOOKS_RATES.BOOK_TYPE_CODE
FA_MC_BOOK_CONTROLS	FA_BOOK_CONTROLS	FA_MC_BOOK_CONTROLS.BOOK_TYPE_CODE
FA_MC_CONVERSION_HISTORY	FA_BOOK_CONTROLS	FA_MC_CONVERSION_HISTORY.BOOK_TYPE_CODE
FA_MC_CONVERSION_RATES	FA_BOOK_CONTROLS	FA_MC_CONVERSION_RATES.BOOK_TYPE_CODE
FA_MC_DEFERRED_DEPRN	FA_BOOK_CONTROLS	FA_MC_DEFERRED_DEPRN.CORP_BOOK_TYPE_CODE
FA_MC_DEFERRED_DEPRN	FA_BOOK_CONTROLS	FA_MC_DEFERRED_DEPRN.TAX_BOOK_TYPE_CODE
FA_MC_DEPRN_DETAIL	FA_BOOK_CONTROLS	FA_MC_DEPRN_DETAIL.BOOK_TYPE_CODE
FA_MC_DEPRN_PERIODS	FA_BOOK_CONTROLS	FA_MC_DEPRN_PERIODS.BOOK_TYPE_CODE
FA_MC_DEPRN_SUMMARY	FA_BOOK_CONTROLS	FA_MC_DEPRN_SUMMARY.BOOK_TYPE_CODE
FA_PARALLEL_WORKERS	FA_BOOK_CONTROLS	FA_PARALLEL_WORKERS.BOOK_TYPE_CODE
FA_PERIODIC_PRODUCTION	FA_BOOK_CONTROLS	FA_PERIODIC_PRODUCTION.BOOK_TYPE_CODE
FA_RETIREMENTS	FA_BOOK_CONTROLS	FA_RETIREMENTS.BOOK_TYPE_CODE
FA_SHORT_TAX_RESERVES	FA_BOOK_CONTROLS	FA_SHORT_TAX_RESERVES.TAX_BOOK
FA_TAX_INTERFACE	FA_BOOK_CONTROLS	FA_TAX_INTERFACE.BOOK_TYPE_CODE
FA_TRANSACTION_HEADERS	FA_BOOK_CONTROLS	FA_TRANSACTION_HEADERS.BOOK_TYPE_CODE
FA_TRANSACTION_INTERFACE	FA_BOOK_CONTROLS	FA_TRANSACTION_INTERFACE.BOOK_TYPE_CODE
FA_TRX_REFERENCES	FA_BOOK_CONTROLS	FA_TRX_REFERENCES.BOOK_TYPE_CODE
IA_REQUEST_DETAILS	FA_BOOK_CONTROLS	IA_REQUEST_DETAILS.BOOK_TYPE_CODE
IA_REQUEST_HEADERS	FA_BOOK_CONTROLS	IA_REQUEST_HEADERS.BOOK_TYPE_CODE
JA_AU_BAL_CHG_APPLIED	FA_BOOK_CONTROLS	JA_AU_BAL_CHG_APPLIED.BOOK_TYPE_CODE
JA_AU_BAL_CHG_INTERFACE	FA_BOOK_CONTROLS	JA_AU_BAL_CHG_INTERFACE.BOOK_TYPE_CODE
JA_AU_BAL_CHG_SOURCE	FA_BOOK_CONTROLS	JA_AU_BAL_CHG_SOURCE.BOOK_TYPE_CODE
JA_AU_CAPITAL_VALUE	FA_BOOK_CONTROLS	JA_AU_CAPITAL_VALUE.BOOK_TYPE_CODE
JA_AU_FA_BOOK_CONTROLS	FA_BOOK_CONTROLS	JA_AU_FA_BOOK_CONTROLS.BOOK_TYPE_CODE
JL_CO_FA_ADJUSTMENTS	FA_BOOK_CONTROLS	JL_CO_FA_ADJUSTMENTS.BOOK_TYPE_CODE
JL_CO_FA_APPRAISAL_BOOKS	FA_BOOK_CONTROLS	JL_CO_FA_APPRAISAL_BOOKS.BOOK_TYPE_CODE
JL_CO_FA_PURGE	FA_BOOK_CONTROLS	JL_CO_FA_PURGE.BOOK_TYPE_CODE
PA_IMPLEMENTATIONS_ALL	FA_BOOK_CONTROLS	PA_IMPLEMENTATIONS_ALL.BOOK_TYPE_CODE
PA_STANDARD_UNIT_COSTS	FA_BOOK_CONTROLS	PA_STANDARD_UNIT_COSTS.BOOK_TYPE_CODE