Search Results qp_currency_details




Overview
Explore in AI Chat

Overview

The QP_CURRENCY_DETAILS table is a core data object within the Oracle E-Business Suite Advanced Pricing (QP) module. It functions as the line-level repository for multi-currency lists, which are defined in the header table QP_CURRENCY_LISTS_B. Its primary role is to store the specific conversion rules, formulas, and target currencies associated with a given currency list. These lists are critical for determining accurate pricing in transactions involving multiple currencies, ensuring that price adjustments, surcharges, and discounts are correctly calculated when the transaction currency differs from the pricing base currency. The table is designed to maintain a single active record per target currency within a list and is mandated to contain at least one record where the target currency is the system's base currency.

Key Information Stored

The table's structure centers on linking a currency list header to its detailed conversion rules. The primary identifier is the CURRENCY_DETAIL_ID. The CURRENCY_HEADER_ID column provides the foreign key link to the parent QP_CURRENCY_LISTS_B table. The essential TO_CURRENCY_CODE column, validated against FND_CURRENCIES, specifies the currency to which a price or adjustment is being converted. The table also stores references to pricing formulas via the PRICE_FORMULA_ID and MARKUP_FORMULA_ID columns, which link to the QP_PRICE_FORMULAS_B table. These formulas define the arithmetic used for currency conversion or markup application. Additional columns typically manage effective dating (START_DATE, END_DATE) to control record activity and a context-sensitive ATTRIBUTE column for flexfield data.

Common Use Cases and Queries

This table is central to pricing engine processes that require currency conversion. A common operational query retrieves the active conversion rule for a specific currency list and target currency to apply during order entry or invoice generation. For reporting and audit purposes, administrators often run queries to list all configured currency details for a given list header. Troubleshooting pricing discrepancies frequently involves examining the effective dates and formula assignments in this table to verify the correct active rule is being applied.

  • Retrieve active details for a currency list: SELECT * FROM qp_currency_details WHERE currency_header_id = :header_id AND sysdate BETWEEN start_date AND nvl(end_date, sysdate+1);
  • List all target currencies and formulas for a list: SELECT d.to_currency_code, f.formula_name FROM qp_currency_details d, qp_price_formulas_b f WHERE d.currency_header_id = :header_id AND d.price_formula_id = f.price_formula_id(+);

Related Objects

QP_CURRENCY_DETAILS maintains integral relationships with several key tables in the Advanced Pricing and application foundation schemas, as documented by its foreign key constraints.

  • QP_CURRENCY_LISTS_B: The parent header table. Joined via QP_CURRENCY_DETAILS.CURRENCY_HEADER_ID = QP_CURRENCY_LISTS_B.CURRENCY_HEADER_ID.
  • QP_PRICE_FORMULAS_B: Referenced twice for different formula types. Joined via QP_CURRENCY_DETAILS.PRICE_FORMULA_ID = QP_PRICE_FORMULAS_B.PRICE_FORMULA_ID and QP_CURRENCY_DETAILS.MARKUP_FORMULA_ID = QP_PRICE_FORMULAS_B.PRICE_FORMULA_ID.
  • FND_CURRENCIES: Validates the target currency code. Joined via QP_CURRENCY_DETAILS.TO_CURRENCY_CODE = FND_CURRENCIES.CURRENCY_CODE.
  • Table: QP_CURRENCY_DETAILS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_DETAILS,  object_name:QP_CURRENCY_DETAILS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.At any point of time there can be only one active record for a given to_currency_code. Thistable has atleast one record of to_currency_code = base_ ,  implementation_dba_data: QP.QP_CURRENCY_DETAILS , 

  • Table: QP_CURRENCY_DETAILS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_CURRENCY_DETAILS,  object_name:QP_CURRENCY_DETAILS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.At any point of time there can be only one active record for a given to_currency_code. Thistable has atleast one record of to_currency_code = base_ ,  implementation_dba_data: QP.QP_CURRENCY_DETAILS , 

  • Table: QP_PRICE_FORMULAS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • Table: QP_PRICE_FORMULAS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • 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 ,