Search Results QP_CURRENCY_LISTS_B




Overview
Explore in AI Chat

Overview

The QP_CURRENCY_LISTS_B table is a core data object within the Oracle E-Business Suite Advanced Pricing (QP) module. It serves as the header table for storing master information about Multi-Currency lists. These lists are a critical component when the Advanced Pricing and Multi-Currency features are installed and enabled, allowing a single price list to be associated with multiple currency conversions. The table's primary role is to define the unique entity of a Multi-Currency list, which can then be linked to standard and agreement price lists that share the same functional currency, thereby facilitating complex, multi-national pricing strategies within a single global instance.

Key Information Stored

The table's structure is centered on a unique header identifier and descriptive attributes for the currency list. The primary key column, CURRENCY_HEADER_ID, uniquely identifies each Multi-Currency list in the system. While the provided metadata does not list all columns, standard practice and foreign key relationships suggest the table typically stores creation dates, last update dates, and the user IDs responsible for these actions (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE). It also likely includes a NAME or CODE column for the list's identifier and a DESCRIPTION field. The existence of a Translation table (QP_CURRENCY_LISTS_TL) indicates that certain descriptive columns support multiple languages.

Common Use Cases and Queries

This table is primarily accessed for setup, maintenance, and reporting on Multi-Currency pricing configurations. A common operational query involves joining the header to its detail lines to review all currencies and conversion rates within a specific list. For instance, to retrieve a basic list of all currency headers and their associated price lists, one might execute a query joining QP_CURRENCY_LISTS_B to QP_LIST_HEADERS_B. Troubleshooting or auditing pricing discrepancies often requires tracing from a price list back to its governing Multi-Currency list via the CURRENCY_HEADER_ID foreign key in QP_LIST_HEADERS_B. Reporting use cases include generating summaries of all configured Multi-Currency lists and their usage across the pricing catalog.

Related Objects

QP_CURRENCY_LISTS_B is the central node in a hierarchy of related pricing objects. Its primary key is referenced by three key tables: QP_CURRENCY_DETAILS, which stores the individual currencies and their associated rates or attributes for each list; QP_CURRENCY_LISTS_TL, which provides translated descriptions for the lists; and QP_LIST_HEADERS_B, the core price list table, where the CURRENCY_HEADER_ID foreign key establishes the link between a price list and its Multi-Currency definition. This relationship structure confirms that QP_CURRENCY_LISTS_B acts as a master definition, with QP_CURRENCY_DETAILs holding the child lines and QP_LIST_HEADERS_B representing the price lists that utilize the master definition.