Search Results okx_quote_headers_v




Overview
Explore in AI Chat

Overview

The OKX_QUOTE_HEADERS_V view is a reporting and integration object owned by the APPS schema within the OKX – Contracts Integration product in Oracle E-Business Suite. It exposes quote header information sourced from Oracle Advanced Pricing / Oracle Quoting quote entities, presenting a flattened, denormalized projection intended for external consumption by contracts integration flows, interfaces, and downstream reporting. The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and carries the standard ETRM classification of Oracle Proprietary, Confidential Information.

Because the view joins quote header data to quote status definitions, it delivers a business-ready representation of a quote—including its current effective status, financial totals, currency, pricing context, and the applicable exchange rate details—without requiring the consumer to reconcile the underlying transactional tables themselves. For users searching on exchange_rate_date, this view is the principal OKX exposure of that attribute in the quote header context.

Underlying Base Objects

The view is defined over two documented base objects, both referenced through synonyms in the APPS schema:

The two objects are joined on the status identifier:

WHERE QS.QUOTE_STATUS_ID = HDR.QUOTE_STATUS_ID

The view also synthesizes two literal/derived columns: ID1 is set to HDR.QUOTE_HEADER_ID and ID2 is a literal '#'. A derived STATUS column is produced via DECODE(QS.STATUS_CODE, 'ACCEPTED', 'A', 'I'), mapping documented status codes to a single-character active/inactive flag. The status effective dates are exposed as START_DATE_ACTIVE and END_DATE_ACTIVE from QS.EFFECTIVE_START_DATE and QS.EFFECTIVE_END_DATE respectively.

Key Columns

Common Use Cases and Queries

Typical uses include extracting quote headers for contract creation, validating exchange rate application on quotes, and reporting accepted versus inactive quotes. A representative query retrieving quotes with their exchange rate date is:

  • SELECT quote_number, currency_code, exchange_rate, exchange_rate_date, exchange_type_code, total_quote_price FROM okx_quote_headers_v WHERE org_id = :p_org_id AND status = 'A';
  • Filter by exchange_rate_date BETWEEN :start_date AND :end_date to reconcile currency conversion periods.
  • Join ID1 to contract or order interfaces to propagate quote pricing into downstream documents.