Search Results automatic_flag




Overview
Explore in AI Chat

Overview

The view OKX_QP_LIST_LINES_V is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite. It belongs to the OKX – Contracts Integration product module, which provides the bridge between Oracle Advanced Pricing and Oracle Contracts. The view exposes pricing list line data in a simplified, integration-oriented format, presenting a curated subset of columns from the underlying pricing list line table. Its principal role is to serve as a stable read interface for contract integration processes and downstream reporting that must reference price list lines without directly querying the base Advanced Pricing tables.

Within the EBS 12.1.1 and 12.2.2 data models, the view functions as a lightweight projection over the QP_LIST_LINES base object. It does not perform joins to additional tables; instead, it isolates the attributes most relevant to contract pricing integration, including price breaks, modifiers, formulas, and percentage-based pricing. This makes it suitable for use in concurrent programs, pl/sql APIs, and business intelligence queries where a narrow, predictable column set is preferable to the full breadth of the base table.

Underlying Base Objects

The documented metadata identifies a single referenced base object: QP_LIST_LINES, accessed through a synonym. The view text confirms this relationship directly, selecting all columns from QP_LIST_LINES with the alias QPL. No additional joins, unions, or aggregations are present in the documented definition.

Because the view is defined entirely over QP_LIST_LINES, it inherits the transactional and referential characteristics of that table. Price list headers are referenced through LIST_HEADER_ID, which links each line to its parent price list in QP_LIST_HEADERS. Price breaks, modifier levels, and pricing phases are represented as attribute columns rather than through joins, keeping the view flat and efficient for direct query use.

Key Columns

Common Use Cases and Queries

A typical integration query retrieves percentage-based pricing lines for a specific price list, filtering on PERCENT_PRICE and the effective date range. For example:

SELECT list_header_id, list_line_no, percent_price, arithmetic_operator, operand FROM okx_qp_list_lines_v WHERE list_header_id = :p_header_id AND percent_price IS NOT NULL AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE + 1);

Other common scenarios include extracting price breaks by PRICE_BREAK_TYPE_CODE, validating modifier configuration by MODIFIER_LEVEL_CODE, and auditing lines governed by formulas through PRICE_BY_FORMULA_ID. Because the view is a direct projection of QP_LIST_LINES, queries perform comparably to the base table while benefiting from a reduced, integration-focused column set.