Search Results qp_list_headers_tl




The QP_LIST_HEADERS_TL table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Pricing module (Order Management and Advanced Pricing). It stores translated descriptions and names of price lists, modifiers, and qualifiers in multiple languages, supporting the global operations of Oracle Applications. This table is part of the Oracle Pricing Engine, which manages complex pricing rules, discounts, and promotions.

Table Structure and Key Columns

The QP_LIST_HEADERS_TL table is a translation table linked to the base table QP_LIST_HEADERS_B via the LIST_HEADER_ID foreign key. Key columns include:
  • LIST_HEADER_ID: Primary key, references QP_LIST_HEADERS_B.
  • LANGUAGE: Stores the language code (e.g., 'US' for English, 'DE' for German).
  • SOURCE_LANG: Indicates the source language of the translation.
  • NAME: Translated name of the price list or modifier.
  • DESCRIPTION: Translated description of the pricing entity.

Functional Role in Pricing

This table enables multilingual support for pricing components, ensuring that price lists, promotions, and discounts display correctly in the user's preferred language. For example:
  • Price lists can be presented in localized languages for customers or sales teams.
  • Modifiers (discounts/surcharges) show contextually relevant descriptions.

Integration with Other Modules

QP_LIST_HEADERS_TL integrates with:
  • Order Management (OM): Displays translated pricing during order entry.
  • Advanced Pricing: Supports multilingual rule definitions.
  • Globalization: Aligns with Oracle’s NLS (National Language Support) standards.

Technical Considerations

  • Indexing: Typically indexed on LIST_HEADER_ID and LANGUAGE for performance.
  • Seed Data: Pre-loaded with Oracle-seeded pricing entities in multiple languages.
  • API Usage Updates should use Oracle Pricing APIs to maintain data integrity.

Customization and Extensions

While direct DML operations are discouraged, customizations can leverage:
  • OAF/ADF Pages: To display translations in custom interfaces.
  • Reports: Joined with QP_LIST_HEADERS_B for localized pricing reports.

Example Use Case

A multinational company configures a price list "Q1 Promo" in English (LANGUAGE='US') and German (LANGUAGE='DE'). The QP_LIST_HEADERS_TL table stores both versions, ensuring correct display in Order Management based on the user’s session language.

Conclusion

The QP_LIST_HEADERS_TL table is essential for global deployments of Oracle EBS Pricing, enabling multilingual descriptions while maintaining referential integrity with base pricing data. Proper utilization ensures compliance with Oracle’s architectural standards and seamless user experiences across languages.

  • 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: 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: 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.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: 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: 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_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 ,