Results for “need_by_start_date”

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

Overview

PON_AUCTION_ITEM_PRICES_ALL is the core negotiation line table within the Oracle E-Business Suite Sourcing (PON) module. It stores the negotiation item details including price, capturing one row for every line of every sourcing negotiation (auction). In Oracle EBS 12.1.1 and 12.2.2 this table serves as the transactional backbone for buyer-side auction definitions and for the accumulated results of supplier bidding activity. Each row is uniquely identified by the combination of AUCTION_HEADER_ID and LINE_NUMBER, making the table a hub-leaning object in Data Vault terms: it anchors negotiation lines and is referenced by many downstream satellites and dependent entities. The documented physical schema for 12.2.2 shows the table owned by the PON schema with 157 columns, which reflects the breadth of sourcing functionality it supports — pricing, quantities, bidding summaries, award control, commitments, projects, and contract terms.

Key Information Stored

The surrogate primary key is PON_AUCTION_ITEM_PRICES_ALL_PK, defined on (AUCTION_HEADER_ID, LINE_NUMBER). A unique index, PON_AUCTION_ITEM_PRICES_ALL_U1, is documented as a business-key candidate on the same columns, confirming that a negotiation line is the natural business identifier.

Among the 157 documented columns, the most operationally significant include:

• AUCTION_HEADER_ID – foreign key to PON_AUCTION_HEADERS_ALL; identifies the parent negotiation.
• LINE_NUMBER – the negotiation line within that header.
• ITEM_DESCRIPTION, ITEM_ID, ITEM_NUMBER, ITEM_REVISION – define the item being sourced.
• CATEGORY_ID / CATEGORY_NAME – purchase category linkage (CATEGORY_ID references MTL_CATEGORIES_B).
• QUANTITY, UOM_CODE, NEED_BY_DATE, NEED_BY_START_DATE – demand details for the line.
• PRICE, TARGET_PRICE, THRESHOLD_PRICE, BID_START_PRICE, RESERVE_PRICE, CURRENT_PRICE – pricing control and negotiated values.
• BEST_BID_PRICE, BEST_BID_QUANTITY, BEST_BID_PROMISED_DATE, BEST_BID_NUMBER – rolling best-bid summary maintained during the auction.
• LOWEST_BID_PRICE, LOWEST_BID_QUANTITY, LOWEST_BID_PROMISED_DATE, LOWEST_BID_NUMBER – lowest-bid statistics.
• AWARD_STATUS, AWARDED_QUANTITY, AWARD_MODE – award processing state.
• LINE_TYPE_ID, ORDER_TYPE_LOOKUP_CODE, LINE_ORIGINATION_CODE – line classification and source (LINE_TYPE_ID references PO_LINE_TYPES_B).
• ORG_ID – operating unit context for multi-org security.
• PROJECT_ID, PROJECT_TASK_ID, PROJECT_EXPENDITURE_TYPE, PROJECT_EXP_ORGANIZATION_ID – project accounting integration (references PA_PROJECTS_ALL, PA_TASKS, PA_EXPENDITURE_TYPES, HR_ALL_ORGANIZATION_UNITS).
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY – standard audit columns.

Common Use Cases and Queries

The table supports negotiation line reporting, bid monitoring, and award analysis. Typical queries join it to PON_AUCTION_HEADERS_ALL for header context and to PON_BID_ITEM_PRICES for supplier bid detail.

• Listing all lines for a negotiation:
  SELECT LINE_NUMBER, ITEM_DESCRIPTION, QUANTITY, BEST_BID_PRICE, AWARD_STATUS FROM PON.PON_AUCTION_ITEM_PRICES_ALL WHERE AUCTION_HEADER_ID = :p_auction_id ORDER BY LINE_NUMBER;
• Identifying awarded lines:
  SELECT AUCTION_HEADER_ID, LINE_NUMBER, AWARDED_QUANTITY, PRICE FROM PON.PON_AUCTION_ITEM_PRICES_ALL WHERE AWARD_STATUS = 'AWARDED';
• Project-related sourcing lines:
  SELECT AUCTION_HEADER_ID, LINE_NUMBER, PROJECT_ID, PROJECT_TASK_ID FROM PON.PON_AUCTION_ITEM_PRICES_ALL WHERE PROJECT_ID IS NOT NULL;
• Comparing target versus best bid:
  SELECT LINE_NUMBER, TARGET_PRICE, BEST_BID_PRICE FROM PON.PON_AUCTION_ITEM_PRICES_ALL WHERE AUCTION_HEADER_ID = :p_auction_id;

Reporting scenarios include spend analysis by category, bid competitiveness tracking, and exception reports for lines with price disabled flags or pending residual quantities.

Related Objects

• PON_AUCTION_HEADERS_ALL – joined on AUCTION_HEADER_ID; the negotiation header.
• PON_BID_ITEM_PRICES – joined on AUCTION_HEADER_ID and LINE_NUMBER; supplier bid detail for each line.
• PON_AUCTION_ATTRIBUTES – joined on AUCTION_HEADER_ID and LINE_NUMBER; line-level attribute values.
• PON_AUCTION_SUMMARY – joined on AUCTION_ID and LINE_NUMBER; aggregated bid summary.
• PON_ACCEPTANCES – joined on AUCTION_HEADER_ID and AUCTION_LINE_NUMBER; award acceptances.
• PON_BACKING_REQUISITIONS – joined on AUCTION_HEADER_ID and LINE_NUMBER; originating requisition links.
• PON_BID_PAYMENTS_SHIPMENTS / PON_AUC_PAYMENTS_SHIPMENTS – joined on AUCTION_HEADER_ID and line number; payment and shipment terms.
• PON_PRICE_ELEMENTS / PON_PRICE_DIFFERENTIALS – joined on LINE_NUMBER; structured pricing components.
• PO_LINE_TYPES_B, MTL_CATEGORIES_B, PA_PROJECTS_ALL, PA_TASKS – referenced lookup and master entities.