Results for “recoverable_cost”

50+ results




Overview
Explore in AI Chat

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

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;