Results for “fa_books_bk_cntrl_web_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FA_BOOKS_BK_CNTRL_WEB_V is an Oracle E-Business Suite view owned by the APPS schema within the Oracle Assets (OFA) module. Its documented purpose is to expose asset financial information for a given depreciation book. The view consolidates data from four Asset base objects (FA_BOOKS, FA_BOOK_CONTROLS, FA_ADDITIONS_B, and FA_CATEGORY_BOOK_DEFAULTS) together with the GL_SETS_OF_BOOKS view and the FND_CURRENCY package, producing a flattened, web-oriented result set that pairs each asset's book balances and depreciation attributes with category-level book defaults and the ledger currency code.

The "WEB" naming convention indicates the view was built for online/self-service style inquiries where a single query must return both the book record and its controlling category-level defaults, without requiring the caller to join the underlying tables manually. Because it returns only rows where DATE_INEFFECTIVE IS NULL, the view presents currently effective book records, which is the appropriate scope for most asset inquiry and reporting screens.

Underlying Base Objects

Per the documented metadata, the view is defined over the following referenced base objects:

• FA_BOOKS (synonym) — the primary source of asset book balances and depreciation attributes, aliased BK.
• FA_BOOK_CONTROLS (synonym) — the book definition, supplying BOOK_CLASS and the association to the ledger via SET_OF_BOOKS_ID, aliased BC.
• FA_ADDITIONS_B (synonym) — the asset master row, supplying ASSET_NUMBER and the ASSET_CATEGORY_ID used for the category join, aliased AD.
• FA_CATEGORY_BOOK_DEFAULTS (synonym) — the category/book default setup, supplying DEPRN_METHOD and ITC_ELIGIBLE_FLAG, aliased CB. This object is joined on BOOK_TYPE_CODE, CATEGORY_ID, and the DATE_PLACED_IN_SERVICE falling between START_DPIS and NVL(END_DPIS, DATE_PLACED_IN_SERVICE), so the effective date-ranged default row is selected.
• GL_SETS_OF_BOOKS (view) — the accounting ledger, supplying CURRENCY_CODE, aliased GB.
• FND_CURRENCY (package) — invoked through FND_CURRENCY.SAFE_GET_FORMAT_MASK to render numeric book amounts using the ledger currency's format mask.

The joins are therefore driven from FA_BOOKS to FA_BOOK_CONTROLS on BOOK_TYPE_CODE, to FA_ADDITIONS_B on ASSET_ID, to FA_CATEGORY_BOOK_DEFAULTS on BOOK_TYPE_CODE and CATEGORY_ID with the DPIS range condition, and to GL_SETS_OF_BOOKS on SET_OF_BOOKS_ID.

Key Columns

The view exposes book-level financial and depreciation attributes alongside selected asset and setup values. Notable columns include:

• BOOK_TYPE_CODE, BOOK_CLASS — identify the depreciation book and its control class.
• ASSET_ID, ASSET_NUMBER — link the row to the asset.
• COST, ORIGINAL_COST, SALVAGE_VALUE, REVAL_CEILING, RECOVERABLE_COST, ITC_BASIS — monetary values formatted via the ledger currency mask; these are returned as character strings, not numbers.
• ITC_AMOUNT_ID — reference to the investment tax credit amount record.
• CEILING_NAME — the revaluation ceiling identifier.
• DATE_PLACED_IN_SERVICE, PRORATE_DATE, PRORATE_CONVENTION_CODE, DEPRN_METHOD_CODE, LIFE_IN_MONTHS, BASIC_RATE, ADJUSTED_RATE, BONUS_RULE, DEPRECIATE_FLAG, UNIT_OF_MEASURE, PRODUCTION_CAPACITY — depreciation and proration attributes from the book.
• CB.DEPRN_METHOD and CB.ITC_ELIGIBLE_FLAG — the category-level default depreciation method and the investment tax credit eligibility indicator, which is the column referenced in the user's search.
• CURRENCY_CODE — the ledger currency code used for formatting the monetary columns.

Common Use Cases and Queries

Because ITC_ELIGIBLE_FLAG originates in FA_CATEGORY_BOOK_DEFAULTS and is surfaced only through this view's join path, users searching for that column typically intend to confirm whether an asset's category/book combination is flagged as ITC eligible. A representative query follows:

• SELECT asset_number, book_type_code, itc_eligible_flag, deprn_method, cost, currency_code FROM fa_books_bk_cntrl_web_v WHERE book_type_code = 'CORP' AND itc_eligible_flag = 'Y';
• SELECT asset_number, book_type_code, date_placed_in_service, life_in_months, basic_rate, recoverable_cost FROM fa_books_bk_cntrl_web_v WHERE asset_id = :asset_id;
• SELECT book_type_code, book_class, currency_code, COUNT(*) FROM fa_books_bk_cntrl_web_v GROUP BY book_type_code, book_class, currency_code;

Typical scenarios include asset inquiry screens, ITC eligibility audits, and reconciliation extracts where both the asset's book balances and the governing category defaults must be reported together. Because the monetary columns are pre-formatted through FND_CURRENCY, consumers expecting numeric values should apply TO_NUMBER or query FA_BOOKS directly instead.