Search Results qp_list_headers_tl

Overview

The QP_LIST_HEADERS_TL table is a core object within the Oracle E-Business Suite Advanced Pricing (QP) module, specifically designed to support multilingual implementations. It functions as a translation table, storing the language-specific textual content for price lists. Its primary role is to separate the translatable attributes of a price list from its base transactional data, enabling a single price list definition to be presented in multiple languages throughout the application interface. This table is integral to the global deployment of Oracle EBS, ensuring that pricing information is accessible and clear to users across different regions.

Key Information Stored

The table holds the translated name and description for each price list header. Its structure is defined by a composite primary key consisting of LIST_HEADER_ID and LANGUAGE. The LIST_HEADER_ID is a foreign key that links each row back to the base price list definition in the QP_LIST_HEADERS_B table. The LANGUAGE column stores the language code (e.g., 'US' for American English, 'KO' for Korean) for which the translation applies. The two key translatable columns are typically NAME and DESCRIPTION, which contain the localized text for the price list's title and explanatory notes, respectively. Additional standard columns like CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN are also present for auditing.

Common Use Cases and Queries

The primary use case is retrieving a price list's display information in a user's session language for forms, reports, and order management workflows. A common reporting need is to verify or audit translations for all price lists. Sample SQL patterns include joining to the base table to get a complete view:

• Fetching a specific list in a session language: SELECT tl.name, tl.description FROM qp_list_headers_tl tl, qp_list_headers_b b WHERE b.list_header_id = tl.list_header_id AND b.list_header_code = 'LIST_CODE' AND tl.language = USERENV('LANG');
• Identifying lists missing a translation: SELECT b.list_header_id, b.list_header_code FROM qp_list_headers_b b WHERE NOT EXISTS (SELECT 1 FROM qp_list_headers_tl tl WHERE tl.list_header_id = b.list_header_id AND tl.language = 'KO');

Related Objects

The most critical related object is the base table QP_LIST_HEADERS_B, with which QP_LIST_HEADERS_TL shares a foreign key relationship on the LIST_HEADER_ID column. This enforces referential integrity, ensuring every translation corresponds to a valid price list. The table is also referenced by various Advanced Pricing forms, reports, and APIs that present price list information. For programmatic access, developers typically use the standard Oracle API for price lists (QP_PRICE_LIST_PUB), which internally manages operations on both the base and translation tables, rather than writing direct DML against this table.