Search Results exchange_rate_one




Overview
Explore in AI Chat

Overview

APPS.XTR_REVALUATION_DETAILS_V is a reporting view within the Oracle E-Business Suite Treasury (ETRM) module. It exposes revaluation detail records and consolidates them into a presentation suitable for fair value, realized and unrealized profit/loss, and period-end revaluation reporting. The view is defined as a UNION ALL of two aggregation branches, each grouping data from the underlying revaluation detail table by batch, account, and realization status. The presence of the FAIR_VALUE column — computed as SUM(FAIR_VALUE) — makes this view directly relevant to searches for "fair_value," as it surfaces the fair value amounts recorded against revaluation transactions alongside the associated realized and unrealized gain/loss figures.

Because the view applies DECODE and aggregate logic, it does not represent raw transactional rows; instead it delivers one summarized row per grouping key, which is well suited to report generation, reconciliation, and downstream integration extracts.

Underlying Base Objects

The view is defined over a single documented base object: XTR_REVALUATION_DETAILS (referenced through an APPS synonym). All columns projected by the view originate from this table, filtered and aggregated:

  • The first branch restricts rows to DEAL_TYPE = 'CA' with REALIZED_FLAG IN ('Y','N') and groups by BATCH_ID, ACCOUNT_NO, and REALIZED_FLAG.
  • The second branch re-projects the same source with per-deal-type DECODE logic (for example, 'ONC' contract handling and 'IG' deal number formatting) and conditional date handling.
  • Constant NULL and to_number(NULL) placeholders align the column lists of both branches for the UNION ALL so that downstream consumers see a single, consistent result set.

No other base tables are documented as referenced by this view, so all reporting attributes are derived from the revaluation details table.

Key Columns

Common Use Cases and Queries

Typical usage includes fair value reporting, realized/unrealized P&L analysis, and batch-level revaluation reconciliation. A basic query retrieving fair value by batch and account:

  • SELECT BATCH_ID, ACCOUNT_NO, REALIZED_FLAG, FAIR_VALUE, UNREALISED_PL, REVAL_CCY FROM APPS.XTR_REVALUATION_DETAILS_V WHERE REALIZED_FLAG = 'N';
  • Filter by batch: SELECT * FROM APPS.XTR_REVALUATION_DETAILS_V WHERE BATCH_ID = :p_batch_id;
  • Fair value by currency: SELECT REVAL_CCY, SUM(FAIR_VALUE) FROM APPS.XTR_REVALUATION_DETAILS_V GROUP BY REVAL_CCY;

Because heavy aggregation is already performed in the view, consumers should apply additional filters rather than re-aggregating where row-level precision is not required.