Results for “settlement_rate”
22 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:
- XTR_DEALS_V (VIEW) — the principal source, supplying the aliased
Dcolumns (deal number, company, counterparty, amounts, rates, dates). - XTR_DEAL_TYPES (SYNONYM) and XTR_DEAL_SUBTYPES (SYNONYM) — provide the descriptive
USER_DEAL_TYPEandUSER_DEAL_SUBTYPElabels that decode internal type/subtype codes. - XTR_DEAL_STATUSES (SYNONYM) — supplies lifecycle status information for the deal.
- XTR_BANK_ACCOUNTS (SYNONYM) — feeds settlement/account-related attributes.
- XTR_EXPOSURE_TRANSACTIONS_V (VIEW) — the exposure transaction view that is explicitly excluded from the result set by definition.
- XTR_INTERACCT_TRANSFERS (SYNONYM) — supports inter-account transfer relationships.
- XTR_ROLLOVER_TRANSACTIONS_V (VIEW) — provides rollover transaction context; note the constant
ROLLOVER_TRANSACTION_NOof 1 in the projection. - XTR_USER_ACCESS (PACKAGE) — enforces user access / security filtering so callers see only deals they are authorized to review.
Key Columns
- CONTRACT_NO, CONTRACT_TYPE, CONTRACT_SUBTYPE — identifiers and decoded type/subtype of the deal.
- COMPANY, COUNTERPARTY, CLIENT, ACCEPTOR, ENDORSER, DRAWER — party and instrument-role attributes.
- CURRENCY, CURRENCY_SELL — the buy/primary and sell currencies, derived by DECODE across FX/FXO and other types.
- CONTRACT_RATE — the critical rate column. A DECODE maps DEAL_TYPE to the appropriate source:
TRANSACTION_RATEfor FX and FXO,CONTRACT_RATEfor FUT, andINTEREST_RATEfor all remaining types. This is the column most relevant to the search term "contract_rate". - COUPON_RATE, BROKER_RATE, TAX_RATE, SETTLEMENT_RATE — additional rate fields.
- AMOUNT, SELL_AMOUNT, CONSIDERATION_AMOUNT, SETTLEMENT_AMOUNT, PREMIUM_AMOUNT, BROKER_AMOUNT, TAX_AMOUNT — monetary values, with AMOUNT resolved per deal type via DECODE.
- CONTRACT_DEALT_ON, AUTHORISED_ON, COMMENCE_DATE, MATURITY_DATE, SETTLEMENT_DATE, PREMIUM_DATE, OPTION_EXPIRY — key deal dates.
- ENTERED_INTO_SYSTEM_ON, ENTERED_INTO_SYSTEM_BY — audit 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.
-
This view contains full deal information for all instruments with the exception of exposure transactions. Its main purpose is to inquire on deal information across all deal types.
APPS.XTR_REVIEW_ALL_CONTRACTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_DEALS_V·↳ XTR_DEAL_STATUSES·Explore XTR module →
-
View: XTR_A_ALL_CONTRACTS_V 12.2.2
APPS.XTR_A_ALL_CONTRACTS_V·↳ XTR_A_DEALS·↳ XTR_A_ROLLOVER_TRANSACTIONS·↳ XTR_DEALS_V·Explore XTR module →
-
This view contains full deal information for all instruments with the exception of exposure transactions. Its main purpose is to inquire on deal information across all deal types.
APPS.XTR_REVIEW_ALL_CONTRACTS_V·↳ XTR_BANK_ACCOUNTS·↳ XTR_DEALS_V·↳ XTR_DEAL_STATUSES·Explore XTR module →
-
View: XTR_A_ALL_CONTRACTS_V 12.1.1
APPS.XTR_A_ALL_CONTRACTS_V·↳ XTR_A_DEALS·↳ XTR_A_ROLLOVER_TRANSACTIONS·↳ XTR_DEALS_V·Explore XTR module →
-
PACKAGE: APPS.XTR_MM_COVERS 12.1.1
-
PACKAGE: APPS.XTR_MM_COVERS 12.2.2
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96