Search Results pon_price_element_lists




Overview
Explore in AI Chat

Overview

The PON_PRICE_ELEMENT_LISTS table is a core data repository within the Oracle E-Business Suite Sourcing (PON) module. It functions as a master definition table for grouping related price elements. In the context of strategic sourcing and negotiation processes, price elements represent the individual cost components that make up a total price, such as material, labor, freight, or tax. This table provides the foundational structure for creating and managing reusable lists of these elements, enabling consistent and standardized pricing breakdowns across sourcing documents like RFQs, auctions, and purchase orders in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The primary data stored in this table centers on the identification and control of price element lists. The key column is LIST_ID, which serves as the unique primary key identifier for each distinct list. While the provided ETRM metadata does not enumerate all columns, typical supporting columns in such a definition table would include fields for the list name (e.g., LIST_NAME), a description, an effective date range (START_DATE, END_DATE), and control attributes like ENABLED_FLAG. The table essentially acts as a header, with its detailed line items—the specific price elements—stored in the related child table, PON_PRICE_ELEMENTS.

Common Use Cases and Queries

The primary use case is the administration and application of standardized pricing structures. Sourcing administrators create and maintain price element lists which are then assigned to negotiation or purchasing documents. This ensures all cost breakdowns follow a controlled format. Common reporting and validation queries involve joining this table to its child details. For instance, to retrieve all active price element lists and their constituent items, a query would utilize the documented foreign key relationship:

  • SELECT list.list_id, list.list_name, elem.price_element_name
    FROM pon_price_element_lists list, pon_price_elements elem
    WHERE list.list_id = elem.list_id
    AND list.enabled_flag = 'Y'
    AND SYSDATE BETWEEN list.start_date AND NVL(list.end_date, SYSDATE);

Another critical use case is data integrity validation, ensuring no price element exists without a valid parent list header.

Related Objects

The PON_PRICE_ELEMENT_LISTS table has a direct and essential relationship with the PON_PRICE_ELEMENTS table, as documented in the provided ETRM metadata. The relationship is defined by a foreign key constraint where the LIST_ID column in the PON_PRICE_ELEMENTS table references the primary key (LIST_ID) of the PON_PRICE_ELEMENT_LISTS table. This establishes a classic header-detail (one-to-many) relationship. No other foreign key relationships referencing this table are documented in the provided excerpt. In a broader EBS context, these price element lists are likely referenced by sourcing document tables (e.g., PON_AUCTION_HEADERS) via a LIST_ID column to define the pricing structure for a specific negotiation.