Search Results qp_list_lines

Overview

The QP_LIST_LINES table is a core data repository within the Oracle E-Business Suite Advanced Pricing (QP) module. It serves as the detailed line-level storage for all pricing modifiers and list price entries defined in the system. Each record in this table represents a specific pricing rule or price point that is attached to a parent pricing list, qualifier, or modifier header stored in QP_LIST_HEADERS_B. The table is fundamental to the pricing engine's operation, enabling the complex calculation of prices, discounts, surcharges, and promotions applied to transactions across Oracle EBS, including Order Management, Receivables, and Procurement.

Key Information Stored

The table's primary key is LIST_LINE_ID, which uniquely identifies each pricing line. Its most critical foreign key is LIST_HEADER_ID, linking the line to its parent definition in QP_LIST_HEADERS_B. Other significant columns define the pricing logic and application. The PRICING_PHASE_ID indicates when the modifier is applied (e.g., line, order, or shipment level). Key attribute columns, such as INVENTORY_ITEM_ID, ORGANIZATION_ID, and RELATED_ITEM_ID, store the product, inventory organization, and product relationship criteria that qualify a transaction for the pricing line. The PRICE_BY_FORMULA_ID and GENERATE_USING_FORMULA_ID columns reference QP_PRICE_FORMULAS_B to enable formula-based pricing. The BENEFIT_PRICE_LIST_LINE_ID supports benefit (giveaway) modifiers by linking to another line within the same table.

Common Use Cases and Queries

Primary use cases involve troubleshooting pricing calculations, auditing price list configurations, and generating custom pricing reports. A common query retrieves all modifiers for a specific product to understand its pricing structure. For example:

• Identifying active list prices for an item: SELECT list_line_id, list_price, start_date_active, end_date_active FROM qp_list_lines qll, qp_list_headers_b qlh WHERE qll.list_header_id = qlh.list_header_id AND qlh.list_type_code = 'PRL' AND qll.inventory_item_id = <item_id> AND SYSDATE BETWEEN nvl(qll.start_date_active, SYSDATE) AND nvl(qll.end_date_active, SYSDATE);
• Analyzing all modifiers on a specific price list header: SELECT list_line_id, modifier_level_code, arithmetic_operator, operand FROM qp_list_lines WHERE list_header_id = <header_id> ORDER BY list_line_number;
• Debugging a transaction price by joining to QP_DEBUG_REQ_LINE_ATTRS using the LIST_LINE_ID.

Related Objects

QP_LIST_LINES maintains extensive relationships with numerous EBS objects, underscoring its central role. Its primary parent is QP_LIST_HEADERS_B. Key transactional child tables include OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJS_IFACE_ALL, which store applied modifiers from sales orders. For debugging and formula execution, it links to QP_DEBUG_REQ_LINE_ATTRS, QP_DEBUG_REQ_RLTD_LINES, and QP_DEBUG_FORMULA_STEP_VALUES. It is referenced by other modules for specialized pricing: AMS_EVENT_OFFERS_ALL_B (Marketing), OKC_K_LINES_B (Contracts), OZF_RELATED_DEAL_LINES (Trade Management), and FTE_LOAD_CHARGES (Transportation). The table also has a recursive relationship with itself via BENEFIT_PRICE_LIST_LINE_ID to model benefit modifiers.