Search Results fixed_or_floating_rate




Overview
Explore in AI Chat

Overview

APPS.XTR_R_DEALS_V is a reporting and integration view within the Oracle E-Business Suite Treasury (ETRM) module, exposed under the APPS schema. It presents a denormalized, read-oriented projection of treasury deal data drawn from the underlying deals entity, making it suitable for inquiry screens, concurrent reports, and outbound interfaces that must consume a wide set of deal attributes in a single query. In the 12.1.1 and 12.2.2 releases, ETRM stores treasury transactions — foreign exchange, money market, loans, swaps, options, and related instruments — across consolidated deal tables, and views such as this one flatten those structures so that reporting logic need not join numerous child tables directly.

The view is defined over the ETRM deals data set and spans a broad column list covering instrument identification, counterparty details, currency, pricing, valuation, taxation, and treasury-specific instrument attributes. Because it is owned by APPS and built on a synonym, it is treated as a public reporting object rather than a base transactional entity, and it should be queried read-only.

Underlying Base Objects

The documented base object is XTR_R_DEALS (referenced through a synonym). XTR_R_DEALS is the primary repository for treasury deal records in ETRM, holding one row per deal or deal leg. The view selects from this source without exposing any documented aggregation, which indicates a one-to-one projection: each row of XTR_R_DEALS generates a corresponding row in XTR_R_DEALS_V. The view name uses the XTR_ prefix and the _V suffix consistent with EBS view naming conventions, where R frequently denotes a reporting-oriented construct. Since the base object is a synonym, the physical table may reside in the ETRM application schema while the APPS view provides the supported access point.

Key Columns

Common Use Cases and Queries

Typical uses include counterparty exposure reporting, FX deal listings filtered by currency, tax and valuation extracts, and reconciliation of treasury positions to the general ledger. Because the view carries both original and HCE (home currency equivalent) amounts, it supports dual-currency reporting directly.

Sample query locating deals by the cty_ccy and currency attributes:

  • SELECT deal_no, deal_type, cty_ccy, currency, deal_date, face_value_amount, face_value_hce_amount FROM apps.xtr_r_deals_v WHERE cty_ccy = 'USD' ORDER BY deal_date DESC;
  • SELECT counterparty_code, deal_no, maturity_date, interest_rate FROM apps.xtr_r_deals_v WHERE currency = 'EUR' AND maturity_date BETWEEN :p_from AND :p_to;
  • SELECT deal_type, COUNT(*), SUM(face_value_hce_amount) FROM apps.xtr_r_deals_v WHERE deal_date >= :p_start GROUP BY deal_type;

All queries should be issued as read-only against APPS, with appropriate ETRM security and business group context enforced by the calling application or report.