Results for “qp_list_headers_b”

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

Overview

QP_LIST_HEADERS_B is the base table in the Oracle Advanced Pricing (QP) schema that stores header-level information for every list defined in the application. Lists encompass Price Lists, Discount Lists, Promotions, Agreements, and other pricing constructs used throughout Oracle E-Business Suite. Each row represents a single list, identified by the surrogate primary key LIST_HEADER_ID through the unique index QP_LIST_HEADERS_B_PK.

The table functions as a central pricing reference used by Order Management, Advanced Pricing, Service, and industry-specific modules. Pricing lists are attached to orders, agreements, offers, contracts, and vendor sites, making QP_LIST_HEADERS_B a heavily referenced parent. In Data Vault terms, the metadata indicates a hub-leaning classification: LIST_HEADER_ID behaves as a durable business key that anchors pricing lists, while descriptive and lifecycle attributes (active dates, currency, comments) support satellite-style modeling around that hub.

Key Information Stored

The most significant columns include:

• LIST_HEADER_ID – Surrogate primary key, uniquely identifying each list.
• LIST_TYPE_CODE – Distinguishes price lists, discount lists, promotions, and other list categories.
• CURRENCY_CODE – Currency for the list; foreign key to FND_CURRENCIES.
• TERMS_ID – Payment terms associated with the list; foreign key to RA_TERMS_B.
• PARENT_LIST_HEADER_ID – Self-referencing parent, enabling hierarchical list structures (e.g., agreements with sub-lists).
• CURRENCY_HEADER_ID – Links to QP_CURRENCY_LISTS_B for currency-specific pricing.
• START_DATE_ACTIVE / END_DATE_ACTIVE – Primary validity window.
• START_DATE_ACTIVE_FIRST / SECOND and related type columns – Support secondary activation windows used by qualification logic.
• ACTIVE_FLAG, AUTOMATIC_FLAG, ASK_FOR_FLAG – Control list behavior and automation in pricing engine processing.
• GSA_INDICATOR, PRORATE_FLAG, DISCOUNT_LINES_FLAG – Compliance and pricing behavior flags.
• SOLD_TO_ORG_ID – Customer-specific list association.
• LIST_SOURCE_CODE, ORIG_SYSTEM_HEADER_REF, ORIG_ORG_ID, SOURCE_SYSTEM_CODE – Origin tracing for imported or interfaced lists.
• GLOBAL_FLAG, SHAREABLE_FLAG, MOBILE_DOWNLOAD – Distribution and sharing controls.
• CONTEXT and ATTRIBUTE1–ATTRIBUTE15 – Descriptive flexfield storage.
• COMMENTS – Free-text description.

Common Use Cases and Queries

Typical queries retrieve active price lists for a given currency or date, or trace lists attached to orders and agreements. For example:

• Find currently active price lists: SELECT list_header_id, list_type_code FROM qp_list_headers_b WHERE active_flag = 'Y' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE+1);
• List all children of a parent list: SELECT list_header_id FROM qp_list_headers_b WHERE parent_list_header_id = :p_id;
• Join to translations for name/description: SELECT h.list_header_id, t.name FROM qp_list_headers_b h, qp_list_headers_tl t WHERE h.list_header_id = t.list_header_id AND t.language = USERENV('LANG');

Reporting use cases include pricing list inventory, activation window audits, currency coverage analysis, and tracing order-level pricing back to source lists through OE_ORDER_HEADERS_ALL.PRICE_LIST_ID.

Related Objects

• QP_LIST_HEADERS_TL – Translations keyed by LIST_HEADER_ID.
• QP_LIST_LINES – Detail lines belonging to each list.
• QP_QUALIFIERS – Qualification rules referencing LIST_HEADER_ID.
• OE_ORDER_HEADERS_ALL / OE_ORDER_LINES_ALL – Orders carry PRICE_LIST_ID referencing this table.
• OE_PRICE_ADJUSTMENTS – Adjustments tied via LIST_HEADER_ID.
• AMS_OFFERS / AMS_ACT_OFFERS – Promotion offers referencing QP_LIST_HEADER_ID.
• QP_CURRENCY_LISTS_B – Currency list header referenced by CURRENCY_HEADER_ID.
• FND_CURRENCIES and RA_TERMS_B – Currency and payment term lookups.
• FTE_LANE_RATE_CHARTS and FTE_LOAD_CHARGES – Transportation pricing references.
• JTF_MSITE_CURRENCIES – iStore price list assignments.