Results for “pon_price_elements_n1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PON.PON_PRICE_ELEMENTS is a Sourcing (PON) module table that stores the price element details associated with an auction or an RFQ. In Oracle E-Business Suite sourcing, a buyer can decompose the total cost of a line item into discrete price elements — for example material cost, freight, handling, tooling, or any user-defined component of a supplier's quotation. PON_PRICE_ELEMENTS records which price element types apply to a given auction header and line, the pricing basis used to evaluate them, the value or target, and the display/sequence attributes that drive how they appear to suppliers and to the negotiation team. It therefore acts as the configuration and value bridge between auction line items and the reusable price element definitions maintained by the sourcing administrator.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link table. Its identity is composed from the auction header, line, price element type, and list identifiers, which connect the auction item pricing context to the price element type and price element list entities.

Key Information Stored

The table is documented in 12.2.2 with 19 columns. The most significant are:

• AUCTION_HEADER_ID — identifies the auction (or RFQ) header to which the price element applies; part of the composite primary key.
• LINE_NUMBER — the auction line item against which the price element is defined; part of the primary key.
• PRICE_ELEMENT_TYPE_ID — references the price element type definition; identifies what the element represents (freight, material, and so on); part of the primary key.
• LIST_ID — references the price element list (or auction template) that groups the elements; part of the primary key.
• PRICING_BASIS — the basis on which the element is priced (for example fixed amount or percentage of a reference value).
• VALUE — the stored value of the price element as defined on the auction or template.
• DISPLAY_TARGET_FLAG — indicates whether a target value is displayed.
• DISPLAY_TO_SUPPLIERS_FLAG — controls whether suppliers can see the element during bidding.
• NEGATIVE_COST_FACTOR_FLAG — flags whether the element functions as a negative cost factor in scoring or cost analysis.
• PF_TYPE — the price factor type classifier used for the element.
• SEQUENCE_NUMBER — ordering of the element within the line or list presentation.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard who-columns for audit.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program context columns populated when rows are created or updated through batch processes.

The surrogate/primary key is the unique index PON_PRICE_ELEMENTS_U1 defined over AUCTION_HEADER_ID, LINE_NUMBER, PRICE_ELEMENT_TYPE_ID, LIST_ID; these four columns together constitute the business-key candidate for the row.

Common Use Cases and Queries

Typical reporting scenarios include extracting all price elements configured for an auction so that the negotiation team can review cost composition, auditing which elements were exposed to suppliers, and reconciling price element values against awarded supplier responses.

A representative query joining elements to their type definitions:

• SELECT pe.AUCTION_HEADER_ID, pe.LINE_NUMBER, pet.PRICE_ELEMENT_TYPE_NAME, pe.PRICING_BASIS, pe.VALUE FROM PON.PON_PRICE_ELEMENTS pe, PON.PON_PRICE_ELEMENT_TYPES pet WHERE pe.PRICE_ELEMENT_TYPE_ID = pet.PRICE_ELEMENT_TYPE_ID AND pe.AUCTION_HEADER_ID = :auction_header_id ORDER BY pe.LINE_NUMBER, pe.SEQUENCE_NUMBER;

A second common pattern filters on DISPLAY_TO_SUPPLIERS_FLAG = 'Y' to produce the supplier-facing cost breakdown for a published auction. BI Publisher reports and custom OTBI extracts over sourcing events frequently drive off this table to render element-level quotations.

Related Objects

• PON_PRICE_ELEMENT_TYPES — joined on PRICE_ELEMENT_TYPE_ID; provides the descriptive definition of each element.
• PON_PRICE_ELEMENT_LISTS — joined on LIST_ID; the reusable list grouping the elements.
• PON_AUCTION_TEMPLATES — also joins on LIST_ID; templates that seed price element rows for new auctions.
• PON_AUCTION_ITEM_PRICES_ALL — joined on LINE_NUMBER and AUCTION_HEADER_ID; carries the line-level pricing that the elements decompose.
• PON_AUCTION_HEADERS_ALL — parent auction header supplying AUCTION_HEADER_ID context.