Results for “contract_no”

50+ results




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

Overview

XTR_REVIEW_ALL_CONTRACTS_V is an APPS-owned database view in the Oracle E-Business Suite Treasury (XTR) module. In Oracle EBS 12.1.1 and 12.2.2 it exposes consolidated, deal-level detail for every financial instrument captured in Treasury, with the deliberate exception of exposure transactions. Its stated purpose is to support inquiry into deal information across all deal types—foreign exchange (FX), FX options (FXO), forward rate agreements (FRA), futures (FUT), interest rate instruments (IRO/IRS), debt (DEB), swaps (SWPTN), and money market (TMM)—through a single, unified read interface. Because it normalizes heterogeneous deal structures into a common column set, the view serves reporting, ad hoc inquiry, and downstream integration needs without requiring the caller to join the individual deal, subtype, and type tables directly. The view is documented as VALID.

Underlying Base Objects

The view is defined over a mix of Treasury synonyms and helper views:

Key Columns

Common Use Cases and Queries

Typical uses include rate and deal reporting, cross-instrument inquiry, and reconciliation. A sample query filtering on the rate column:

  • SELECT CONTRACT_NO, CONTRACT_TYPE, CURRENCY, CONTRACT_RATE
    FROM APPS.XTR_REVIEW_ALL_CONTRACTS_V
    WHERE DEAL_TYPE = 'FX';
  • Reporting deals maturing in a period:
    SELECT CONTRACT_NO, COUNTERPARTY, MATURITY_DATE, AMOUNT
    FROM APPS.XTR_REVIEW_ALL_CONTRACTS_V
    WHERE MATURITY_DATE BETWEEN :p_from AND :p_to;
  • Extracting interest rate deals by contract rate for analytics:
    SELECT CONTRACT_NO, CURRENCY, CONTRACT_RATE
    FROM APPS.XTR_REVIEW_ALL_CONTRACTS_V
    WHERE CONTRACT_RATE IS NOT NULL;

Because access is governed via XTR_USER_ACCESS, results are automatically restricted to the querying user's authorized deals.