Results for “qp_list_lines”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

QP_LIST_LINES is the core transactional table of Oracle Advanced Pricing (QP) in E-Business Suite 12.1.1 and 12.2.2. It stores every individual line belonging to a pricing list — price lists, discount lists, surcharge lists, promotion lists, coupon lists, and benefit lists — whose headers are held in QP_LIST_HEADERS_B. Each row represents one list line: a price break, a modifier rule, a promotional qualification, or a benefit award, together with the qualifiers, formulas, dates, and pricing attributes that govern how the line is applied during pricing and order capture.

The table resides in the QP schema with 111 documented columns. Under a heuristic Data Vault classification it behaves as a hub: LIST_LINE_ID is the durable business key around which many dependent satellites and links (attributes, qualifiers, limits, related modifiers, debug and interface tables) attach. This classification is a modeling suggestion only; in native EBS terms the table is a master-detail child of QP_LIST_HEADERS_B and a parent to a large family of supporting tables.

Key Information Stored

The surrogate primary key is LIST_LINE_ID, enforced by the QP_LIST_LINES_PK unique index. A second unique index, QP_LIST_LINES_U1 on (LIST_HEADER_ID, LIST_LINE_NO), is the true business-key candidate: within a single list header, LIST_LINE_NO uniquely identifies the line. The principal columns include:

• LIST_HEADER_ID — foreign key to QP_LIST_HEADERS_B, tying the line to its parent price list, modifier list, or promotion.
• LIST_LINE_TYPE_CODE — distinguishes line types such as price, discount, surcharge, coupon, promotion, and benefit.
• START_DATE_ACTIVE and END_DATE_ACTIVE — the active date range governing when the line participates in pricing.
• INVENTORY_ITEM_ID, ORGANIZATION_ID, RELATED_ITEM_ID, and RELATIONSHIP_TYPE_ID — product and item-relationship context that determines which items the line affects.
• LIST_PRICE, LIST_PRICE_UOM_CODE, and PRIMARY_UOM_FLAG — the price amount and unit of measure for price-list lines.
• PRICE_BY_FORMULA_ID and GENERATE_USING_FORMULA_ID — foreign keys to QP_PRICE_FORMULAS_B controlling calculated prices and generated lines.
• PERCENT_PRICE, ARITHMETIC_OPERATOR, and OPERAND — the percentage or fixed adjustment and the operator used for modifier lines.
• MODIFIER_LEVEL_CODE and PRICING_PHASE_ID — the level at which the modifier applies and the pricing phase sequence in which it executes.
• QUALIFICATION_IND and LIMIT_EXISTS_FLAG — indicators that qualifiers (held in QP_QUALIFIERS) and limits (QP_LIMITS) exist for the line.
• BENEFIT_PRICE_LIST_LINE_ID — a self-referencing foreign key linking a benefit line back to the price list line that grants it.
• CONTEXT plus ATTRIBUTE1 through ATTRIBUTE15, and the ACCUM_* columns — descriptive flexfield and accumulation attributes used for extensibility and accrual tracking.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and the PROGRAM_*/REQUEST_ID columns — standard EBS audit and concurrent-request lineage.

Common Use Cases and Queries

QP_LIST_LINES is central to pricing diagnostics, list maintenance reporting, and integration. Typical queries join the line to its header to resolve the list name, and to QP_QUALIFIERS or QP_LIMITS to explain why a modifier did or did not fire.

• List contents report — join QP_LIST_LINES to QP_LIST_HEADERS_B on LIST_HEADER_ID to list all lines for a named price list, filtered by START_DATE_ACTIVE and END_DATE_ACTIVE for current validity.
• Active price lookup — filter by INVENTORY_ITEM_ID, ORGANIZATION_ID, and a SYSDATE check against the active date range to return effective list prices or PRICE_BY_FORMULA_ID references.
• Modifier troubleshooting — join to QP_QUALIFIERS on LIST_LINE_ID (where QUALIFICATION_IND indicates qualifiers exist) and to QP_LIMITS on LIST_LINE_ID (where LIMIT_EXISTS_FLAG is set) to trace qualification and limit logic.
• Formula dependency analysis — query PRICE_BY_FORMULA_ID and GENERATE_USING_FORMULA_ID against QP_PRICE_FORMULAS_B to identify which lines depend on a given pricing formula.
• Benefit and promotion reporting — follow BENEFIT_PRICE_LIST_LINE_ID or join to QP_COUPONS on ISSUED_BY_MODIFIER_ID for coupon-issued promotions.
• Interface validation — compare rows in QP_INTERFACE_LIST_LINES against QP_LIST_LINES on LIST_LINE_ID to confirm that pricing interface loads succeeded.

Related Objects

The table sits within a dense foreign-key network. The most significant relationships are:

• QP_LIST_HEADERS_B — parent list header, joined on QP_LIST_LINES.LIST_HEADER_ID = QP_LIST_HEADERS_B.LIST_HEADER_ID.
• QP_QUALIFIERS — child qualifier rows, joined on QP_QUALIFIERS.LIST_LINE_ID = QP_LIST_LINES.LIST_LINE_ID.
• QP_LIMITS (and QP_LIMIT_TRANSACTIONS) — child limit definitions, joined on LIST_LINE_ID.
• QP_PRICING_ATTRIBUTES — pricing attribute rows for the line, joined on LIST_LINE_ID.
• QP_PRICE_FORMULAS_B — referenced twice via PRICE_BY_FORMULA_ID and GENERATE_USING_FORMULA_ID.
• QP_PRICING_PHASES — phase definition referenced by PRICING_PHASE_ID, controlling execution sequence.
• QP_RLTD_MODIFIERS — related-modifier links via FROM_RLTD_MODIFIER_ID and TO_RLTD_MODIFIER_ID.
• OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJS_HISTORY — order-level pricing adjustments that consume modifier lines via LIST_LINE_ID.
• QP_INTERFACE_LIST_LINES — the pricing interface table used for bulk load and update of list lines.
• QP_COUPONS — coupon records referencing the issuing modifier through ISSUED_BY_MODIFIER_ID.

Because of this dependency breadth, any purge, archive, or data-fix operation on QP_LIST_LINES must account for the many child and interface tables that reference LIST_LINE_ID.