Search Results qp_list_headers_tl




Overview
Explore in AI Chat

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.

  • Table: QP_LIST_HEADERS_TL 12.1.1

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

  • Table: QP_LIST_HEADERS_TL 12.2.2

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

  • View: QPBV_SECONDARY_PRICE_LISTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • View: QPBV_SECONDARY_PRICE_LISTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_SECONDARY_PRICE_LISTS,  object_name:QPBV_SECONDARY_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Primary Price list and its Secondary Price list. ,  implementation_dba_data: APPS.QPBV_SECONDARY_PRICE_LISTS , 

  • View: QP_LIST_HEADERS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_HEADERS_VL,  object_name:QP_LIST_HEADERS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. ,  implementation_dba_data: APPS.QP_LIST_HEADERS_VL , 

  • View: QP_LIST_HEADERS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_HEADERS_VL,  object_name:QP_LIST_HEADERS_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language. ,  implementation_dba_data: APPS.QP_LIST_HEADERS_VL , 

  • View: QP_PRICE_FACTORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V , 

  • View: QP_PRICE_FACTORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_V , 

  • View: QPBV_MODIFIER_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_MODIFIER_HEADERS,  object_name:QPBV_MODIFIER_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers. ,  implementation_dba_data: APPS.QPBV_MODIFIER_HEADERS , 

  • View: QPBV_PRICE_LISTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRICE_LISTS,  object_name:QPBV_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Standard and Agreement Price list headers. ,  implementation_dba_data: APPS.QPBV_PRICE_LISTS , 

  • View: QPBV_PRICE_LISTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRICE_LISTS,  object_name:QPBV_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Standard and Agreement Price list headers. ,  implementation_dba_data: APPS.QPBV_PRICE_LISTS , 

  • View: QPBV_MODIFIER_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_MODIFIER_HEADERS,  object_name:QPBV_MODIFIER_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers. ,  implementation_dba_data: APPS.QPBV_MODIFIER_HEADERS , 

  • View: QPFV_PROMOTION_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PROMOTION_HEADERS,  object_name:QPFV_PROMOTION_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Deal and Promotion type of Modifier headers. ,  implementation_dba_data: APPS.QPFV_PROMOTION_HEADERS , 

  • View: QPFV_PROMOTION_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PROMOTION_HEADERS,  object_name:QPFV_PROMOTION_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Deal and Promotion type of Modifier headers. ,  implementation_dba_data: APPS.QPFV_PROMOTION_HEADERS , 

  • View: QPBV_PROMOTION_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PROMOTION_HEADERS,  object_name:QPBV_PROMOTION_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Deal and Promotion type of Modifier headers. ,  implementation_dba_data: APPS.QPBV_PROMOTION_HEADERS , 

  • View: QPBV_PROMOTION_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PROMOTION_HEADERS,  object_name:QPBV_PROMOTION_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Deal and Promotion type of Modifier headers. ,  implementation_dba_data: APPS.QPBV_PROMOTION_HEADERS , 

  • View: QPFV_PRICE_LISTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRICE_LISTS,  object_name:QPFV_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Standard and Agreement Price list headers. ,  implementation_dba_data: APPS.QPFV_PRICE_LISTS , 

  • View: QPFV_PRICE_LISTS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRICE_LISTS,  object_name:QPFV_PRICE_LISTS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Standard and Agreement Price list headers. ,  implementation_dba_data: APPS.QPFV_PRICE_LISTS , 

  • View: QPFV_MODIFIER_HEADERS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_MODIFIER_HEADERS,  object_name:QPFV_MODIFIER_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers. ,  implementation_dba_data: APPS.QPFV_MODIFIER_HEADERS , 

  • View: QPFV_MODIFIER_HEADERS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_MODIFIER_HEADERS,  object_name:QPFV_MODIFIER_HEADERS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers. ,  implementation_dba_data: APPS.QPFV_MODIFIER_HEADERS , 

  • View: QP_LIST_HEADERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_HEADERS_V,  object_name:QP_LIST_HEADERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives details of all standard price lists setup in pricing. ,  implementation_dba_data: APPS.QP_LIST_HEADERS_V , 

  • View: QP_LIST_HEADERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_HEADERS_V,  object_name:QP_LIST_HEADERS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives details of all standard price lists setup in pricing. ,  implementation_dba_data: APPS.QP_LIST_HEADERS_V , 

  • View: OE_DISCOUNTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V , 

  • View: QP_LIST_SUMMARY_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_SUMMARY_VL,  object_name:QP_LIST_SUMMARY_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LIST_SUMMARY_VL , 

  • View: QP_LIST_SUMMARY_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LIST_SUMMARY_VL,  object_name:QP_LIST_SUMMARY_VL,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LIST_SUMMARY_VL , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • View: QP_SECONDARY_PRICE_LISTS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_SECONDARY_PRICE_LISTS_V,  object_name:QP_SECONDARY_PRICE_LISTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form. ,  implementation_dba_data: APPS.QP_SECONDARY_PRICE_LISTS_V , 

  • Table: QP_LIST_HEADERS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • Table: QP_LIST_HEADERS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_HEADERS_B,  object_name:QP_LIST_HEADERS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_HEADERS_B stores the header information for all lists. List types can be, for example, Price Lists, Discount Lists or Promotions. ,  implementation_dba_data: QP.QP_LIST_HEADERS_B , 

  • View: OE_DISCOUNTS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.OE_DISCOUNTS_V,  object_name:OE_DISCOUNTS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: Obsolete ,  implementation_dba_data: APPS.OE_DISCOUNTS_V , 

  • View: QP_LINES_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINES_SUMMARY_V,  object_name:QP_LINES_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LINES_SUMMARY_V , 

  • View: QP_LINES_SUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_LINES_SUMMARY_V,  object_name:QP_LINES_SUMMARY_V,  status:VALID,  product: QP - Advanced Pricing ,  description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. ,  implementation_dba_data: APPS.QP_LINES_SUMMARY_V ,