Search Results AS_PRICE_LISTS




Overview
Explore in AI Chat

Overview

The AS_PRICE_LISTS table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation (AS) module. It functions as the primary repository for storing price list definitions. In the context of Oracle EBS 12.1.1 and 12.2.2, price lists are fundamental to the pricing engine, enabling the assignment of specific prices to products and services for defined customers, sales channels, or market segments. This table acts as a critical bridge between the Sales Foundation module and the more comprehensive pricing functionality managed by the Quoting (QP) module, establishing the foundational price list entities upon which detailed pricing rules and modifiers are built.

Key Information Stored

The table's structure is designed to uniquely identify and categorize price lists. The metadata indicates two primary key columns: PRICE_LIST_ID and GROUP_ID. The PRICE_LIST_ID serves as the unique system identifier for a specific price list. This column is the foreign key link to the QP_LIST_HEADERS_B table in the Quoting module, which holds the extensive header-level attributes for the price list, such as its name, currency, and effective dates. The GROUP_ID column associates the price list with a logical grouping or classification, maintained in the AS_PRICE_LIST_GROUPS table. This grouping mechanism allows for the organized management and application of multiple related price lists.

Common Use Cases and Queries

This table is central to operations involving the setup, inquiry, and reporting of sales price lists. Common use cases include validating the existence of a price list before applying it to a sales order, generating lists of all price lists within a specific group, or troubleshooting integration between Sales Foundation and Quoting. A typical query would join AS_PRICE_LISTS to QP_LIST_HEADERS_B to retrieve a comprehensive view of price list details.

  • Sample Query: To retrieve basic price list information with its Quoting module details:
    SELECT apl.PRICE_LIST_ID, apl.GROUP_ID, qlh.NAME, qlh.CURRENCY_CODE
    FROM OSM.AS_PRICE_LISTS apl, QP_LIST_HEADERS_B qlh
    WHERE apl.PRICE_LIST_ID = qlh.LIST_HEADER_ID
    AND apl.GROUP_ID = :p_group_id;
  • Reporting often focuses on the relationship between price lists and their assigned groups, or auditing which price list IDs are actively configured within the Sales Foundation layer.

Related Objects

As per the provided metadata, AS_PRICE_LISTS has defined relationships with two key tables, forming the nexus of price list management. The primary foreign key relationship is with QP_LIST_HEADERS_B (Quoting module), where PRICE_LIST_ID references LIST_HEADER_ID. This is the principal link to the full pricing engine. Secondly, a foreign key relationship exists with AS_PRICE_LIST_GROUPS, where GROUP_ID references the corresponding column in that table, enabling price list categorization. While not listed in the excerpt, it is common for other Sales Foundation objects, such as those related to sales accounts or territory assignments, to reference the PRICE_LIST_ID to determine applicable pricing.