Results for “qp_currency_lists_tl”

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

Overview

QP_CURRENCY_LISTS_TL is the translation table for multi-currency lists in the Oracle Advanced Pricing (QP) module. In Oracle E-Business Suite 12.1.1 and 12.2.2, Advanced Pricing allows pricing administrators to define currency lists that group a set of currencies used for price list and modifier qualification. Each currency list has a header record stored in QP_CURRENCY_LISTS_B, and that header carries a user-visible name and description. Because these two attributes are language-dependent, they are not stored on the base table. Instead, QP_CURRENCY_LISTS_TL holds one row per translation language, enabling the multi-currency list title and description to display in the session language of each user.

From a dimensional modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. It does not own the business identity of the currency list; it is a dependent, descriptive extension of the base entity. The heuristic suggests modeling QP_CURRENCY_LISTS_TL as a satellite attached to the hub represented by QP_CURRENCY_LISTS_B rather than as an independent hub or a link table. This reflects its role as a language-specific descriptive store keyed to the parent header.

Key Information Stored

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

• CURRENCY_HEADER_ID — The foreign key to QP_CURRENCY_LISTS_B. This is the surrogate reference that links each translated row back to its owning currency list header. It is not unique within this table because one header may have multiple language rows.
• LANGUAGE — The language code for the translation row. Together with NAME it forms the documented unique index, so the language discriminates translations of the same logical list.
• NAME — The translated display name of the multi-currency list. This is a business-key column and the primary user-facing label.
• DESCRIPTION — The translated long description of the currency list, providing administrative context for the defined currency grouping.
• SOURCE_LANG — Identifies the source language from which the translation was derived, supporting Oracle's translation and language-derivation logic.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO-column audit attributes recording insert and update provenance for each translated row.

The documented unique index QP_CURRENCY_LISTS_TL_PK is defined on (NAME, LANGUAGE), which serves as the business-key candidate. The true relational linkage to the parent entity is CURRENCY_HEADER_ID, which is the surrogate foreign key to QP_CURRENCY_LISTS_B.

Common Use Cases and Queries

Typical scenarios include reporting currency list names in the reporting language, verifying that all required translations exist, and joining pricing setup data to obtain localized labels.

• Retrieve the translated name and description of a currency list for a given language:
  SELECT t.name, t.description FROM qp_currency_lists_tl t WHERE t.currency_header_id = :header_id AND t.language = USERENV('LANG');
• Detect currency lists missing a translation in a target language:
  SELECT b.currency_header_id FROM qp_currency_lists_b b WHERE NOT EXISTS (SELECT 1 FROM qp_currency_lists_tl t WHERE t.currency_header_id = b.currency_header_id AND t.language = 'US');
• Audit translated rows by last update for change-tracking and reconciliation of pricing setup.

Related Objects

• QP_CURRENCY_LISTS_B — The base table holding the non-translatable definition of each multi-currency list. Join on QP_CURRENCY_LISTS_TL.CURRENCY_HEADER_ID = QP_CURRENCY_LISTS_B.CURRENCY_HEADER_ID.
• QP_CURRENCY_LISTS_VL / _V — The translated views exposing base and TL columns together for application use.
• FND_LANGUAGES — Supplies the installed and active language codes referenced by the LANGUAGE column.
• QP_PRICE_LISTS / QP_LIST_HEADERS — Pricing entities that qualify on currency lists defined by the parent header.
• FND_TERRITORIES / FND_CURRENCIES — Reference data supporting the currencies associated with the list definition.