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
- CURRENCY_A — The primary (base) currency for the quoted price or rate. For foreign exchange entries this is typically the base currency of the currency pair.
- CURRENCY_B — The secondary (term or quote) currency for the price entry. Together with CURRENCY_A it identifies the currency pair. This column is the most frequently searched descriptor for user queries involving market rates.
- REF_NUMBER — The unique reference identifier for the market price record.
- SOURCE — Identifies the provider or origin of the market data.
- RIC_CODE — The Reuters Instrument Code associated with the quote, used when the price is sourced from an external feed.
- PRICE_DESCRIPTION — A free-text description of the price or rate.
- TERM_TYPE, TERM_LENGTH, TERM_YEAR — Define the tenor of the quote, supporting spot, forward, and rate instruments.
- BID_PRICE and ASK_PRICE — The two sides of the quoted market, with the spread derivable from their difference.
- SPREAD_BASIS — Indicates how the spread is expressed or applied.
- DAY_COUNT_BASIS — The day-count convention used for interest calculations on rate entries.
- Frequency and audit columns — FREQ_DOWNLOAD, DOWNLOAD_FREQ_TYPE, LAST_DOWNLOAD_TIME, FREQ_ARCHIVE, ARCHIVE_FREQ_TYPE, LAST_ARCHIVE_TIME, ORAFIN_ARCHIVE_FREQ_TYPE, and ORAFIN_LAST_ARCHIVE_TIME govern how the price is periodically downloaded and archived.
- PARTY_CODE, DDE_CONVERSATION_CODE, MOVEMENT_INDICATOR, NOS_OF_DAYS, UPDATE_RATE_YN — Supporting attributes for counterparty linkage, dynamic data exchange, rate movement configuration, and manual refresh control.
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.
-
View: XTR_MARKET_PRICES_V 12.1.1
APPS.XTR_MARKET_PRICES_V·↳ XTR_MARKET_PRICES·Explore XTR module →
-
Current rates for foreign exchange and money market deals
-
View: XTR_MARKET_PRICES_V 12.2.2
APPS.XTR_MARKET_PRICES_V·↳ XTR_MARKET_PRICES·Explore XTR module →
-
Current rates for foreign exchange and money market deals
-
View: XTR_DEALS_INTERFACE_V 12.2.2
This view is created in association with the base table Xtr_Deals_Interface. The table is designed to hold as much common deal information as possible.
APPS.XTR_DEALS_INTERFACE_V·↳ XTR_DEALS_INTERFACE·↳ XTR_PARTIES_V·↳ XTR_PARTY_INFO·Explore XTR module →
-
The XTR_DEALS_INTERFACE table contains deal information that will be imported into Oracle Treasury
-
View: XTR_DEALS_INTERFACE_V 12.1.1
This view is created in association with the base table Xtr_Deals_Interface. The table is designed to hold as much common deal information as possible.
APPS.XTR_DEALS_INTERFACE_V·↳ XTR_DEALS_INTERFACE·↳ XTR_PARTIES_V·↳ XTR_PARTY_INFO·Explore XTR module →
-
The XTR_DEALS_INTERFACE table contains deal information that will be imported into Oracle Treasury
-
VIEW: XTR.XTR_MARKET_PRICES# 12.2.2
-
VIEW: XTR.XTR_MARKET_PRICES# 12.2.2
-
Treasury Open API Search Criteria
-
PACKAGE: APPS.XTR_FPS2_P 12.2.2
-
Treasury Open API Search Criteria
-
PACKAGE: APPS.XTR_FPS2_P 12.1.1
-
TABLE: XTR.XTR_MARKET_PRICES 12.1.1
-
TABLE: XTR.XTR_MARKET_PRICES 12.2.2