Search Results qp_list_headers_tl_pk




Overview
Explore in AI Chat

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

Overview

QP_LIST_HEADERS_TL is the translation table for price lists and modifier lists within the Oracle Advanced Pricing (QP) module. In Oracle EBS 12.1.1 and 12.2.2, QP_LIST_HEADERS_B stores the base, language-independent attributes of a list header, while QP_LIST_HEADERS_TL holds the translatable, language-dependent columns — specifically NAME and DESCRIPTION — for each language installed in the database. Every price list, discount list, promotion, surcharge, and coupon that a user defines at the list-header level has one row per translated language here.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as satellite-leaning. QP_LIST_HEADERS_TL is best understood as a descriptive satellite hanging off the QP_LIST_HEADERS_B hub, keyed by LANGUAGE and LIST_HEADER_ID. Because it retains CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE alongside the translated text, it also carries limited audit-style attributes, but its core function is to provide the multilingual descriptive label for the underlying list.

Key Information Stored

The table contains 11 documented columns. The most significant are:

  • LIST_HEADER_ID — Surrogate foreign key identifying the parent list in QP_LIST_HEADERS_B. Combined with LANGUAGE, it forms the primary key QP_LIST_HEADERS_TL_PK.
  • LANGUAGE — The NLS language code (for example, US or JA) in which the NAME and DESCRIPTION are expressed. Part of the primary key.
  • SOURCE_LANG — Indicates the language in which the row was originally entered, supporting translation workflows in the EBS translation framework.
  • NAME — The translated, user-visible name of the price list or modifier list. Part of the unique index QP_LIST_HEADERS_TL_U1.
  • DESCRIPTION — The translated narrative description of the list's purpose and contents.
  • VERSION_NO — A version column present in the unique index QP_LIST_HEADERS_TL_U1 and used to distinguish successive versions of the same-named list.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns capturing audit and concurrency information.

The primary key QP_LIST_HEADERS_TL_PK covers LANGUAGE and LIST_HEADER_ID in the documented column order (LIST_HEADER_ID, LANGUAGE per the physical schema). The unique index QP_LIST_HEADERS_TL_U1 (NAME, VERSION_NO, LANGUAGE) serves as a business-key candidate, enforcing uniqueness of a list name per version per language.

Common Use Cases and Queries

Because QP_LIST_HEADERS_TL is a translation satellite, joins to QP_LIST_HEADERS_B are the norm, with the LANGUAGE column filtered to the reporting user's environment or to a specific locale.

  • Displaying price lists in the user's language: 
    SELECT b.list_header_id, t.name, t.description
FROM   qp_list_headers_b b,
       qp_list_headers_tl t
WHERE  b.list_header_id = t.list_header_id
AND    t.language = USERENV('LANG');
  • Multilingual reporting: join on LANGUAGE to produce side-by-side translations for global pricing catalogs, comparing NAME across languages to validate translation completeness.
  • Duplicate name detection: query QP_LIST_HEADERS_TL_U1 columns (NAME, VERSION_NO, LANGUAGE) to find collisions before creating new lists.
  • Audit and change tracking: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to report on recent translation edits.
  • Missing translation diagnostics: outer join QP_LIST_HEADERS_B to QP_LIST_HEADERS_TL to find lists lacking a row for a target language.

Related Objects

  • QP_LIST_HEADERS_B — The base table holding non-translatable list attributes; joined on LIST_HEADER_ID. This is the FK documented: QP_LIST_HEADERS_TL.LIST_HEADER_ID → QP_LIST_HEADERS_B.
  • QP_LIST_LINES — Line-level pricing and modifier definitions that reference the same list header.
  • QP_PRICE_LIST_HEADERS_V / QP_LIST_HEADERS_V — Reporting views that typically project the translated name and description for user-facing screens.
  • QP_PRICING_ATTRIBUTES / QP_QUALIFIERS — Qualifier and attribute setup attached to the parent list, indirectly linked through the header.
  • FND_LANGUAGES — Reference table for the LANGUAGE and SOURCE_LANG values, useful when validating installed languages.
  • QP_PREQ_GRPS / QP_SECURITY_ORGANIZATIONS — Security and pricing-request groupings that inherit from the list header and rely on NAME for display.

Because QP_LIST_HEADERS_TL is a child of QP_LIST_HEADERS_B and is exposed through the standard Advanced Pricing views and APIs, any extension or report that resolves a list's display name should read from this table rather than from the base table.