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.