Results for “currency_a”

50+ results




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

Overview

XTR_MARKET_PRICES_V is a dictionary view owned by the APPS schema within the Oracle E-Business Suite Treasury (XTR) module. It exposes market price and market rate definitions maintained in Oracle Treasury, presenting them in a read-only, report-friendly format. The view is defined as a projection over the XTR_MARKET_PRICES base object, selecting an explicit column list rather than using a wildcard. Because the underlying object is referenced through a synonym, the view functions as a stable interface that shields downstream reports, concurrent programs, and integrations from physical changes to the base table.

The view appears in both EBS 12.1.1 and 12.2.2 environments with the same structure. The primary distinction is that the 12.2.2 metadata explicitly documents the referenced object as the XTR_MARKET_PRICES synonym, whereas earlier documentation referenced the base table directly. This confirms the view remains valid and is not flagged as invalid in a standard installation.

Underlying Base Objects

The documented base object is XTR_MARKET_PRICES, accessed through a synonym of the same name. The view performs a straightforward SELECT of enumerated columns from that source; no joins, aggregations, or filters are applied in the view definition. Consequently, one row in XTR_MARKET_PRICES_V corresponds to exactly one row in the base table, and the view inherits any row-level security or grants that apply to the synonym.

Because the view does not join to currency, term, or party lookup tables, consumers requiring descriptive names for currency codes or term types must perform their own joins to the appropriate Treasury or common lookup views. This design keeps the view lightweight and suitable for bulk extraction into reporting schemas or data warehouses.

Key Columns

Common Use Cases and Queries

Typical consumers use this view to validate market data setup, reconcile downloaded rates, and feed downstream valuation or reporting processes. A common lookup retrieves all quotes for a single currency by searching on the secondary currency code:

SELECT ref_number, source, currency_a, currency_b, term_type, term_length, bid_price, ask_price
FROM apps.xtr_market_prices_v
WHERE currency_b = 'USD';

Analysts frequently pair the two currency columns to isolate a currency pair and inspect bid/ask spreads for a given tenor:

SELECT currency_a, currency_b, term_length, term_year, bid_price, ask_price,
(ask_price - bid_price) spread
FROM apps.xtr_market_prices_v
WHERE currency_a = 'EUR' AND currency_b = 'USD'
ORDER BY term_year, term_length;

Operational monitoring queries examine download and archive timestamps to detect stale market data. Because the view exposes columns from a single base object without transformation, it is also well suited to full extracts into an external reporting platform, where joins to currency and party reference data can be applied separately.