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:
- 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 →
-
Contract header.
-
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 →
-
Contract header.
-
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 →
-
Header information for blanket purchase orders.
-
Table: FV_IPAC_TRX_ALL 12.1.1
IPAC transactions table
-
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 →
-
Header information for blanket purchase orders.
-
Order Profile Header and Blanket Sales Order Header.
-
Archive table for OPM Common Purchasing interface.
-
Interface table used by OPM Common Purchasing.
-
Archive table for OPM Common Purchasing interface.
-
Order Profile Header and Blanket Sales Order Header.
-
Table: FV_IPAC_TRX_ALL 12.2.2
IPAC transactions table
-
Interface table used by OPM Common Purchasing.
-
View: FV_OPAC_BILLING 12.1.1
Not implemented in this database·Explore FV module →
-
VIEW: GML.OP_CNTR_HDR# 12.2.2
-
View: FV_OPAC_BILLING 12.2.2
Not implemented in this database·Explore FV module →
-
VIEW: GML.PO_BPOS_HDR# 12.2.2
-
VIEW: FV.FV_IPAC_TRX_ALL# 12.2.2
-
VIEW: GML.OP_PRSL_HDR# 12.2.2
-
VIEW: GML.OP_CNTR_HDR# 12.2.2
-
This view is used in the Transaction Validation form.
APPS.XTR_TRANS_VALIDATIONS_V·↳ FND_GLOBAL·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·↳ XTR_COMPANY_AUTHORITIES·Explore XTR module →
-
This view is used in the Transaction Validation form.
APPS.XTR_TRANS_VALIDATIONS_V·↳ FND_GLOBAL·↳ XTR_AUTH_TYPE_SUBTYPE_PROD·↳ XTR_COMPANY_AUTHORITIES·Explore XTR module →
-
VIEW: GML.PO_BPOS_HDR# 12.2.2
-
View: FV_OPAC_BILLDATA_V 12.1.1
FV_OPAC_BILLDATA_V is the main view used by the OPAC process to generate invoices.
Not implemented in this database·Explore FV module →
-
View: FV_OPAC_BILLDATA_V 12.2.2
FV_OPAC_BILLDATA_V is the main view used by the OPAC process to generate invoices.
Not implemented in this database·Explore FV module →
-
VIEW: FV.FV_IPAC_TRX_ALL# 12.2.2
-
TABLE: GML.OP_CNTR_HDR 12.1.1
-
TABLE: GML.OP_CNTR_HDR 12.2.2
-
VIEW: GML.OP_PRSL_HDR# 12.2.2