Search Results list_source_code

Overview

QP_LIST_HEADERS_V is a standard Oracle E-Business Suite view owned by the APPS schema in the Advanced Pricing (QP) product family. It presents the header-level definition of every standard price list configured in the pricing engine. Because pricing structures in EBS are stored in a combination of a base table and a translation table, this view performs the join and language filtering required to deliver a single, readable row per price list. The view is marked with a status of VALID and includes the derived flags VIEW_FLAG and UPDATE_FLAG, both hard-coded to 'Y', which signal to the Oracle Forms-based Pricing Administrator UI that the row is presentation-ready and may be queried and maintained through the view rather than the underlying tables directly.

In the context of reporting and integration, QP_LIST_HEADERS_V is the conventional entry point for extracting price list metadata, for example to drive downstream interfaces, build custom concurrent program extracts, or populate discovery reports. The search term "orig_org_id" corresponds to the ORIG_ORG_ID column exposed by this view, which records the originating organization identifier for a price list. This column is relevant for multi-org and global pricing scenarios, where a price list may be created in one operating unit and referenced or merged into another.

Underlying Base Objects

As documented in the ETRM metadata for 12.2.2, the view is defined over two synonyms: QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. QP_LIST_HEADERS_B is the base (non-translated) table holding the operational attributes of the price list, including the primary key LIST_HEADER_ID, currency, dates, type code, and the Orig_Org_Id value. QP_LIST_HEADERS_TL is the translation table holding the language-dependent NAME and DESCRIPTION, keyed by LIST_HEADER_ID and LANGUAGE. The view joins these two tables on LIST_HEADER_ID and restricts the translation side with the predicate T.LANGUAGE = USERENV('LANG'), ensuring the user sees the description in their session language. A further predicate, B.LIST_TYPE_CODE = 'PRL', restricts the result set to standard price lists; other list types such as agreements and promotions are excluded. The view also incorporates DFF context and attribute columns (CONTEXT, ATTRIBUTE1 through ATTRIBUTE15) from the base table and computes ROW_ID from B.ROWID.

Key Columns

• LIST_HEADER_ID — Primary identifier of the price list; the join key to the base and translation tables.
• NAME / DESCRIPTION / VERSION_NO — Translated name, description, and version from QP_LIST_HEADERS_TL.
• CURRENCY_CODE / CURRENCY_HEADER_ID — Currency in which list prices are expressed.
• START_DATE_ACTIVE / END_DATE_ACTIVE / ACTIVE_FLAG — Effective dating and active status controlling list availability.
• LIST_TYPE_CODE / LIST_SOURCE_CODE / GLOBAL_FLAG — Classification and sourcing attributes; LIST_TYPE_CODE is always 'PRL' in this view.
• ORIG_ORG_ID — Originating organization ID, used when price lists are shared or propagated across operating units.
• ORIG_SYSTEM_HEADER_REF / SOURCE_SYSTEM_CODE / PTE_CODE — References to external or source systems for imported lists.
• ROUNDING_FACTOR / PRORATE_FLAG / DISCOUNT_LINES_FLAG — Pricing behavior controls.
• CONTEXT, ATTRIBUTE1–15 — Descriptive flexfield segments.
• VIEW_FLAG / UPDATE_FLAG — Constant 'Y' indicators that the row is maintained through this view.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard audit columns.

Common Use Cases and Queries

Typical usages include reporting all active price lists for a given currency or organization, extracting translation-ready names for a data warehouse, and auditing price lists by originating organization. The following example returns price lists active on the current date, filtering on the ORIG_ORG_ID that prompted the search.

SELECT lh.list_header_id, lh.name, lh.currency_code, lh.orig_org_id, lh.start_date_active, lh.end_date_active FROM apps.qp_list_headers_v lh WHERE lh.active_flag = 'Y' AND lh.orig_org_id = :p_org_id AND SYSDATE BETWEEN lh.start_date_active AND NVL(lh.end_date_active, SYSDATE + 1);

A second common query joins the view to pricing lines for price list inventory reporting, while a third extracts translation-ready metadata joined to FND_CURRENCIES for currency descriptions. Because the view enforces USERENV('LANG'), multi-language environments should restrict or run such extracts per session language to avoid duplicate rows for the same price list.