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

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.