Results for “retirement_pending_flag”

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

Overview

FA_QUICK_BOOKS_V is an APPS-owned view in the Oracle E-Business Suite Assets (OFA) module. It is a denormalized reporting and integration object that joins asset depreciation book records with book-control configuration data, presenting a single flattened row per asset-book combination. The view is documented in ETRM as "Retrofitted," indicating it exists primarily for backward compatibility with earlier releases of Oracle Assets while remaining VALID in Oracle EBS 12.1.1 and 12.2.2. Its role is to expose the full set of FA_BOOKS attributes — cost, depreciation method, life, capacity, prorate conventions, and revaluation controls — alongside the accounting flexfield structure from the book controls, thereby eliminating the need for consumer code to join the two base tables manually. The view is read-only by nature and is consumed by custom reports, interfaces, conversions, and third-party integrations that require asset book information at a granular asset level.

Underlying Base Objects

Per the documented ETRM metadata, FA_QUICK_BOOKS_V is defined over two referenced base objects:

• FA_BOOKS (accessed through a synonym) — the primary transactional table holding depreciation and financial attributes for each asset within a given book. It supplies every column prefixed with the BK alias, including the searched column ADJUSTED_CAPACITY.
• FA_BOOK_CONTROLS (accessed through a synonym) — the book definition/configuration table. It supplies the ACCOUNTING_FLEX_STRUCTURE value exposed as ACCT_FLEX_NUM under the BC alias.

The view text selects from FA_BOOKS BK and joins FA_BOOK_CONTROLS BC, most commonly on BOOK_TYPE_CODE. Because the row identity derives from BK.ROWID (exposed as ROW_ID), the view preserves a key to the underlying FA_BOOKS row, allowing updates or referential lookups where required. No aggregation, filtering, or DISTINCT logic is applied in the SELECT list, so the cardinality mirrors that of FA_BOOKS for each book.

Key Columns

The view exposes the complete FA_BOOKS column set. Notable members include:

• BOOK_TYPE_CODE — the depreciation book identifier (e.g., a corporate or tax book).
• ASSET_ID — the unique asset identifier linking to FA_ASSETS.
• COST, ORIGINAL_COST, ADJUSTED_COST, UNREVALUED_COST — the cost basis variants used in depreciation and revaluation calculations.
• ADJUSTED_CAPACITY and PRODUCTION_CAPACITY — capacity measures supporting units-of-production depreciation; ADJUSTED_CAPACITY reflects the capacity remaining after adjustments and is the column most relevant to capacity-based depreciation reporting.
• DEPRN_METHOD_CODE, LIFE_IN_MONTHS, BASIC_RATE, ADJUSTED_RATE, RATE_ADJUSTMENT_FACTOR — depreciation rule configuration.
• DEPRN_START_DATE, DATE_PLACED_IN_SERVICE, DATE_EFFECTIVE, DATE_INEFFECTIVE — lifecycle and date-effective tracking.
• SALVAGE_VALUE, PERCENT_SALVAGE_VALUE, RECOVERABLE_COST, ADJUSTED_RECOVERABLE_COST, ALLOWED_DEPRN_LIMIT — limits and salvage parameters.
• RETIREMENT_PENDING_FLAG, DEPRECIATE_FLAG, CAPITALIZE_FLAG, IDLED_FLAG — status flags governing processing.
• ACCT_FLEX_NUM — the accounting flexfield structure from FA_BOOK_CONTROLS, useful for identifying the chart of accounts context of the book.

Common Use Cases and Queries

Typical scenarios include capacity-based depreciation analysis, asset book reconciliation, and integration extracts. A representative query retrieving adjusted capacity for a given book follows:

• Adjusted capacity by book: SELECT asset_id, book_type_code, production_capacity, adjusted_capacity FROM apps.fa_quick_books_v WHERE book_type_code = :p_book AND adjusted_capacity > 0;
• Asset-to-flexfield mapping: SELECT asset_id, book_type_code, acct_flex_num, adjusted_cost FROM apps.fa_quick_books_v WHERE asset_id = :p_asset_id;
• Book reconciliation extract: SELECT book_type_code, asset_id, cost, adjusted_cost, recoverable_cost, allowed_deprn_limit FROM apps.fa_quick_books_v WHERE depreciate_flag = 'YES' AND capitalize_flag = 'YES';

Because the view carries no WHERE clause, callers should always constrain by BOOK_TYPE_CODE or ASSET_ID to avoid full-table scans across FA_BOOKS. For high-volume integrations, reading the base tables directly may be preferable, but FA_QUICK_BOOKS_V remains the convenient single-source option for capacity and book-control-enriched reporting.