Search Results qp_currency_lists_tl




Overview
Explore in AI Chat

Overview

The QP_CURRENCY_LISTS_TL table is a core data object within the Oracle E-Business Suite (EBS) Advanced Pricing (QP) module. It functions as a translation table, storing the language-specific text for multi-currency list names and descriptions. A multi-currency list is a pricing construct that defines a set of currencies applicable for a transaction, price list, or modifier. This table enables the Advanced Pricing module to support a global, multilingual deployment by maintaining user-facing text in each language installed in the database. Its primary role is to provide translated content that is referenced by the base transactional table, QP_CURRENCY_LISTS_B, ensuring that currency list names and descriptions are displayed correctly in the user interface based on the session language.

Key Information Stored

The table holds the translatable attributes for a currency list header. While the full column list is not detailed in the provided metadata, the structure of translation tables in Oracle EBS follows a consistent pattern. The critical columns typically include:

  • CURRENCY_HEADER_ID: The primary key column that links each row to its corresponding base record in QP_CURRENCY_LISTS_B.
  • LANGUAGE and SOURCE_LANG: Standard columns that identify the language code (e.g., 'US', 'DE') for the translated text and the original language of the source data, respectively.
  • NAME: The translated, user-friendly name of the multi-currency list (e.g., "EMEA Currencies" or "APAC Transaction Currencies").
  • DESCRIPTION: The translated, detailed description of the currency list's purpose or usage.

For any given CURRENCY_HEADER_ID, multiple rows exist—one for each installed language into which the data has been translated.

Common Use Cases and Queries

The primary use case is retrieving the appropriate currency list name for reporting, data extracts, or integrated applications based on the user's language context. A common reporting query joins the translation table with its base table to present a comprehensive view. For example, to list all currency lists with their English names and creation dates:

  • SELECT b.CURRENCY_HEADER_ID, tl.NAME, b.CREATION_DATE FROM QP.QP_CURRENCY_LISTS_B b, QP.QP_CURRENCY_LISTS_TL tl WHERE b.CURRENCY_HEADER_ID = tl.CURRENCY_HEADER_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical scenario involves data migration or initialization scripts, where seed data for multi-currency lists must be populated in both the base (B) and translation (TL) tables to ensure proper functionality across all supported languages. Developers and functional consultants query this table to verify that all necessary translations exist for a given set of currency lists.

Related Objects

QP_CURRENCY_LISTS_TL has a direct, dependent relationship with the QP_CURRENCY_LISTS_B table, which stores the non-translatable, transactional data for a currency list. As documented in the provided metadata:

  • Foreign Key Relationship: QP_CURRENCY_LISTS_TL references QP_CURRENCY_LISTS_B.
  • Join Column: QP_CURRENCY_LISTS_TL.CURRENCY_HEADER_ID = QP_CURRENCY_LISTS_B.CURRENCY_HEADER_ID.

This relationship is fundamental; every record in the TL table must have a corresponding parent record in the B table. The currency lists defined in these tables are ultimately referenced by pricing entities within the QP module, such as price lists and modifiers, to determine valid transaction currencies.

  • Table: QP_CURRENCY_LISTS_TL 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_LISTS_TL,  object_name:QP_CURRENCY_LISTS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_LISTS_TL stores the translatable columns, name and description of themulti-currency list, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_CURRENCY_LISTS_TL , 

  • Table: QP_CURRENCY_LISTS_TL 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_LISTS_TL,  object_name:QP_CURRENCY_LISTS_TL,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_LISTS_TL stores the translatable columns, name and description of themulti-currency list, in each of the available languages in the database. ,  implementation_dba_data: QP.QP_CURRENCY_LISTS_TL , 

  • View: QP_CURRENCY_LISTS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_CURRENCY_LISTS_VL,  object_name:QP_CURRENCY_LISTS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is based on QP_CURRENCY_LISTS_B, QP_CURRENCY_LISTS_TL and QP_CURRENCY_DETAILS tables. The block, Multi-Currency Conversion List, of Multi-Currency Conversion Setup form is based on this view. ,  implementation_dba_data: APPS.QP_CURRENCY_LISTS_VL , 

  • View: QP_CURRENCY_LISTS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_CURRENCY_LISTS_VL,  object_name:QP_CURRENCY_LISTS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is based on QP_CURRENCY_LISTS_B, QP_CURRENCY_LISTS_TL and QP_CURRENCY_DETAILS tables. The block, Multi-Currency Conversion List, of Multi-Currency Conversion Setup form is based on this view. ,  implementation_dba_data: APPS.QP_CURRENCY_LISTS_VL , 

  • Table: QP_CURRENCY_LISTS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_LISTS_B,  object_name:QP_CURRENCY_LISTS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_LISTS_B stores the header information for all Multi-Currency lists. A Multi-Currency list is associated with standard and agreement price lists of same currency, if the advance pricing is used and multi-currency is installed. On ,  implementation_dba_data: QP.QP_CURRENCY_LISTS_B , 

  • Table: QP_CURRENCY_LISTS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_LISTS_B,  object_name:QP_CURRENCY_LISTS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_LISTS_B stores the header information for all Multi-Currency lists. A Multi-Currency list is associated with standard and agreement price lists of same currency, if the advance pricing is used and multi-currency is installed. On ,  implementation_dba_data: QP.QP_CURRENCY_LISTS_B ,