Results for “xtr_quick_input_quotes_v”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_QUICK_INPUT_QUOTES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product family. Its purpose is to expose the contents of the quick-input quotes data used by Treasury front-office functionality, presenting counterparty quotes and their associated transaction rates in a flattened, read-only form suitable for reporting, integration, and inquiry. In EBS 12.1.1 and 12.2.2 the view is shipped as a simple projection over a single synonym, meaning it carries no business logic of its own; it exists to provide a stable, named access point for the quote data rather than to transform or aggregate it. Because the object is a view and not a table, it is populated dynamically from its base object at query time and reflects only the rows currently retained in that base store. In the metadata provided by the ETRM documentation set, the view is listed with status VALID and a column set of four fields, reflecting its narrow, purpose-specific scope. The column name matching the user's search term, TRANSACTION_RATE, is the rate value recorded against each quick-input quote.
Underlying Base Objects
The documented view text is a direct select over a single object:
- XTR_QUICK_INPUT_QUOTES — documented in the ETRM 12.2.2 metadata as a SYNONYM referenced by the view. In a standard APPS configuration such synonyms resolve to the corresponding XTR base table owned beneath the product schema.
No joins, functions, filters, or aggregations appear in the documented view definition, so the view is a one-to-one projection: each row in XTR_QUICK_INPUT_QUOTES yields exactly one row in XTR_QUICK_INPUT_QUOTES_V, and the view exposes only a subset of the base object's columns. Because the view has no WHERE clause, all rows held in the base object are visible to any query against the view, subject to the caller's privileges.
Key Columns
The documented column list comprises four fields:
- QUOTE_NO — the quote identifier. This is the primary reference for a quick-input quote and is typically the key by which a quote is retrieved or correlated with other Treasury records.
- CPARTY_CODE — the counterparty code, identifying the institution or trading partner that supplied the quote.
- TRANSACTION_RATE — the rate associated with the quote. This is the field relevant to the user's search for "transaction_rate"; it stores the quoted rate value for the quick-input quote record and is the principal numeric measure exposed by the view.
- STATUS_CODE — the status of the quote, used to distinguish quotes by processing state (for example, entered versus applied).
Because the projection is explicit, columns present in the underlying base object but not listed above are not available through this view.
Common Use Cases and Queries
Typical uses center on retrieving counterparty quote rates for a given quote or reviewing all quotes by status.
- Retrieve a specific quote and its rate:
SELECT quote_no, cparty_code, transaction_rate, status_code FROM apps.xtr_quick_input_quotes_v WHERE quote_no = :p_quote_no; - List rates for a counterparty:
SELECT quote_no, transaction_rate, status_code FROM apps.xtr_quick_input_quotes_v WHERE cparty_code = :p_cparty; - Filter by status to isolate active quotes:
SELECT * FROM apps.xtr_quick_input_quotes_v WHERE status_code = :p_status; - Join the view to other Treasury quote or deal objects on QUOTE_NO to enrich reporting.
Note that filters on TRANSACTION_RATE are supported directly, since the column is projected from the base object.
-
APPS.XTR_QUICK_INPUT_QUOTES_V·↳ XTR_QUICK_INPUT_QUOTES·Explore XTR module →
-
APPS.XTR_QUICK_INPUT_QUOTES_V·↳ XTR_QUICK_INPUT_QUOTES·Explore XTR module →
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design 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
-
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