Search Results ozf_offer_products

Overview

The QP_LIST_HEADERS_B table is a core data object within the Oracle E-Business Suite Advanced Pricing (QP) module. It serves as the master repository for the header-level definition of all pricing lists. This table is fundamental to the pricing engine, storing the foundational metadata that defines the purpose, applicability, and basic attributes of a list. As indicated by the documentation, these lists can be of various types, including Price Lists, Discount Lists, and Promotions. Every operational price list, discount schedule, or promotion defined in the system is anchored by a single, unique record in this table, making it the primary point of reference for all list-based pricing constructs in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key, LIST_HEADER_ID, uniquely identifies each list. Beyond this identifier, the table stores critical administrative and control attributes for a list. Key columns, as evidenced by the foreign key relationships in the metadata, include CURRENCY_CODE (linking to FND_CURRENCIES to define the list's transactional currency), TERMS_ID (linking to RA_TERMS_B for payment terms), and PARENT_LIST_HEADER_ID (enabling hierarchical list structures by referencing the same table). Another significant column is CURRENCY_HEADER_ID, which links to QP_CURRENCY_LISTS_B, allowing for currency conversion lists. Collectively, these columns define the list's identity, financial context, and structural relationships.

Common Use Cases and Queries

This table is central to pricing configuration, reporting, and integration. Common use cases include identifying all active price lists for a specific currency, analyzing list hierarchies for pricing cascades, and troubleshooting pricing errors by validating list header setup. A typical reporting query would join QP_LIST_HEADERS_B to its related lines table (QP_LIST_LINES) and product information. For example, to find basic details for all price lists: SELECT list_header_id, name, currency_code, start_date_active, end_date_active FROM qp_list_headers_b WHERE list_type_code = 'PRL' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1); Another common pattern is to trace a list's lineage using the PARENT_LIST_HEADER_ID column with a hierarchical query (CONNECT BY) to understand pricing inheritance.

Related Objects

QP_LIST_HEADERS_B is a highly referenced master table with extensive integration across EBS. Its most direct dependent is the QP_LIST_LINES table, which holds the detailed pricing rules and adjustments for each header. As shown in the metadata, it is referenced by numerous foreign keys from modules beyond Advanced Pricing, demonstrating its enterprise-wide role. Key referencing objects include:

• QP_CURRENCY_LISTS_B: For currency conversion lists.
• AMS (Trade Management) tables: Such as AMS_OFFERS and AMS_OFFER_PRODUCTS, linking promotions and offers to pricing lists.
• AS (Sales) tables: Like AS_PRICE_LISTS for sales catalog integration.
• Service and Logistics modules: Including CSD_REPAIR_TYPES_B, FTE_LANE_RATE_CHARTS, and FTE_LOAD_CHARGES for service and freight pricing.
• Localization tables: Such as JAI_CMN_CUS_ADDRESSES for region-specific tax and price lists.

This wide network of foreign key relationships underscores that QP_LIST_HEADERS_B is a critical shared entity for pricing data throughout the Oracle EBS suite.