Results for “fa_trans_hist_books_web_v”

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

Overview

The APPS.FA_TRANS_HIST_BOOKS_WEB_V view is a reporting construct in the Oracle E-Business Suite (OFA – Assets) that exposes the transaction history of an asset within a given depreciation book. It is a UNION-based view that consolidates book-level transaction lines into a single result set, providing both the inbound and outbound transaction header identifiers for each line so that a transaction can be reconstructed regardless of whether the asset was the source or the destination of a transfer, reclassification, or other book adjustment. The view is commonly consumed by Asset Inquiry and web-based (OA Framework) pages that render an asset's transaction history for a selected book, shielding the presentation layer from the underlying complexity of the FA_BOOKS and FA_TRANSACTION_HEADERS join logic.

Because it relies on FND_CURRENCY.SAFE_GET_FORMAT_MASK and FND_NUMBER.CANONICAL_TO_NUMBER to pre-format numeric output, the view returns cost, salvage, and recoverable value columns as formatted character strings rather than native numeric types. This makes it well suited to read-only presentation and integration use, but unsuitable as a source for further numeric aggregation without explicit casting.

Underlying Base Objects

The view is defined over the following synonym and package references:

• FA_BOOKS (synonym) – the core table holding per-asset, per-book financial attributes and the TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT linkage that drives the two branches of the UNION.
• FA_BOOK_CONTROLS – joined to FA_TRANSACTION_HEADERS on BOOK_TYPE_CODE to resolve the book definition.
• FA_LOOKUPS – joined twice: as LO (LOOKUP_TYPE = 'FAXOLTRX') to derive the transaction type meaning, and as LU (LOOKUP_TYPE = 'YESNO') to derive the depreciate flag meaning.
• FA_TRANSACTION_HEADERS – supplies the transaction name (COMMENTS) and the transaction type code.
• GL_SETS_OF_BOOKS (view) – provides SET_OF_BOOKS_ID and CURRENCY_CODE for currency format mask derivation.
• FND_CURRENCY (package) – SAFE_GET_FORMAT_MASK returns a currency-specific format mask used for TO_CHAR.
• FND_NUMBER (package) – CANONICAL_TO_NUMBER converts a concatenated life string into a canonical number.

Key Columns

• TRANSACTION_HEADER_ID_IN / TRANSACTION_HEADER_ID_OUT – inbound and outbound header identifiers for the asset line; the UNION ensures both are populated.
• KEY – aliases TRANSACTION_HEADER_ID_IN in the first branch and TRANSACTION_HEADER_ID_OUT in the second, providing a single effective transaction identifier.
• ASSET_ID, BOOK_TYPE_CODE – the asset and book context.
• TRANSACTION_TYPE – the lookup meaning derived from FAXOLTRX.
• CURRENT_COST, ORIGINAL_COST, SALVAGE_VALUE, RECOVERABLE_COST, ADJUSTED_RECOVERABLE_COST – formatted currency strings.
• DEPRN_METHOD_CODE, LIFE, ADJUSTED_RATE, PRODUCTION_CAPACITY, UNIT_OF_MEASURE, PRORATE_CONVENTION_CODE, PRORATE_DATE, DATE_PLACED_IN_SERVICE – depreciation parameters and conventions.
• DEPRECIATE_FLAG – YESNO lookup meaning.
• BONUS_RULE – the bonus depreciation rule applicable to the asset in the book.
• CEILING_NAME, REVALUATION_CEILING – revaluation ceiling attributes.
• COMMENTS – the transaction name from FA_TRANSACTION_HEADERS.

Common Use Cases and Queries

Typical scenarios include asset transaction history inquiry by asset and book, bonus-rule analysis, and extract-style reporting.

• Filter by a single asset across all books.
• Report only transactions where a non-default BONUS_RULE was applied.
• Cross-book transfer reconciliation using the IN / OUT header identifiers.

SELECT asset_id, book_type_code, transaction_type, comments, bonus_rule
FROM   apps.fa_trans_hist_books_web_v
WHERE  asset_id = :p_asset_id
ORDER  BY book_type_code, transaction_type;

SELECT asset_id, book_type_code, transaction_type, bonus_rule
FROM   apps.fa_trans_hist_books_web_v
WHERE  bonus_rule IS NOT NULL;