Results for “xtr_quick_input_deals_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_QUICK_INPUT_DEALS_V is an APPS-owned database view in the Oracle E-Business Suite Treasury (XTR) module. It is a straight projection view defined over the XTR_QUICK_INPUT_DEALS table and exposes the full set of columns used to capture deals entered through the Treasury quick input mechanism. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its ETRM technical description states that the underlying object is "designed to store the tolerance setup for the override feature." In practice, this view supports the rapid capture, review, and validation of foreign exchange, money market, and related Treasury deals before they are promoted to full deal records.
Because the view mirrors its base table one-for-one with no joins or filters, it acts as a stable reporting and integration interface. External applications, custom concurrent programs, and BI Publisher reports can select from XTR_QUICK_INPUT_DEALS_V without needing direct access to the base table, providing a degree of encapsulation for the Treasury quick input staging area.
Underlying Base Objects
The view is defined entirely over a single referenced object, XTR_QUICK_INPUT_DEALS, accessed through a synonym in the APPS schema. The view text is a simple SELECT of all columns from that table, with no WHERE clause, DISTINCT, aggregation, or join. Consequently, every row and every column in XTR_QUICK_INPUT_DEALS is available unchanged through the view, and DML performed against the base table is immediately visible.
This one-to-one relationship means the view inherits the base table's indexing, partitioning, and security characteristics. Any row-level security or grants applied to the base table flow through to the view as defined by the owning schema's policies.
Key Columns
- BASE_AMOUNT — The principal or notional amount of the quick input deal, expressed in the base (first) currency. This is the column most frequently queried by users searching for "base_amount."
- QUOTE_NO / DEAL_NO / TRANSACTION_NUMBER — Identifiers linking the quick input record to Treasury quotations, deals, and transaction references.
- COMPANY_CODE / CPARTY_CODE / CLIENT_CODE — Party and organizational identifiers for the counterparty and dealing entity.
- DEAL_TYPE / DEAL_SUBTYPE / PRODUCT_TYPE — Classification of the instrument (e.g., FX spot, forward, swap, money market).
- CURRENCY1 / CURRENCY2 — The base and quote currencies of the transaction.
- TRANSACTION_RATE / FX_SWAP_RATE — The exchange or swap rate applied to the deal.
- AMOUNT_TYPE — Indicates how BASE_AMOUNT and related amounts are interpreted.
- PREMIUM_AMOUNT / PREPAID_INTEREST — Option premium and prepaid interest components.
- DEAL_DATE / VALUE_DATE / MATURITY_DATE — Core deal timing attributes.
- STATUS_CODE / FULL_INPUT_COMPLETED — Workflow and completion indicators for the quick input lifecycle.
- YEAR_CALC_TYPE / ROUNDING_TYPE / DAY_COUNT_TYPE — Interest calculation conventions.
Common Use Cases and Queries
Typical scenarios include reporting outstanding quick input deals by currency or counterparty, reconciling quick input records against finalized Treasury deals, and extracting data for downstream risk or accounting systems. A representative query retrieving base amounts for a given currency is:
SELECT deal_no, base_amount, currency1, deal_date FROM xtr_quick_input_deals_v WHERE currency1 = 'USD' AND status_code = 'OPEN';SELECT company_code, SUM(base_amount) FROM xtr_quick_input_deals_v GROUP BY company_code;SELECT deal_no, base_amount, premium_amount FROM xtr_quick_input_deals_v WHERE product_type = 'OPTION';
Because the view performs no filtering, callers should apply their own predicates on status and completion flags to avoid returning incomplete or abandoned quick input records. All queries execute directly against XTR_QUICK_INPUT_DEALS with no additional parsing or join overhead.
-
This table is designed to store the tolerance setup for the override feature
APPS.XTR_QUICK_INPUT_DEALS_V·↳ XTR_QUICK_INPUT_DEALS·Explore XTR module →
-
This table is designed to store the tolerance setup for the override feature
APPS.XTR_QUICK_INPUT_DEALS_V·↳ XTR_QUICK_INPUT_DEALS·Explore XTR module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96