Search Results auction_status




Overview
Explore in AI Chat

Overview

APPS.PON_AUCTION_HEADERS_ALL_V is a reporting and integration view within the Oracle E-Business Suite Advanced Procurement / Sourcing module (PON schema). It projects the header-level attributes of sourcing auctions — the negotiation documents used to solicit supplier bids — into a denormalized, human-readable form. Because it exposes status, timing, currency, and trading-partner data in a single row per auction, it is the canonical starting point for buyer-facing dashboards, supplier portal queries, workflow notifications, and third-party integrations that need to enumerate or filter auctions. The view is defined over the multi-org-enabled base table PON_AUCTION_HEADERS_ALL, so it participates in the standard MO/Org security model. It is available in both EBS 12.1.1 and 12.2.2; the 12.2.2 ETRM metadata confirms the owner as APPS and lists the referenced objects noted below.

Underlying Base Objects

The 12.2.2 metadata documents the following referenced base objects:

Foreign keys to location tables (ship-to, bill-to) are stored as IDs on the base table; the view exposes those IDs but relies on separate location views for descriptive resolution.

Key Columns

The most frequently referenced columns include:

Common Use Cases and Queries

Typical scenarios include listing open auctions for a buyer dashboard, monitoring auctions nearing close, and integration extracts for supplier portals.

  • List active auctions by status: 
    SELECT auction_header_id, auction_title, auction_status_name,
       trading_partner_name, close_bidding_date
FROM   apps.pon_auction_headers_all_v
WHERE  auction_status IN ('ACTIVE','OPEN')
ORDER  BY close_bidding_date;
  • Auctions closing within the next seven days: 
    SELECT auction_header_id, auction_title, auction_status_name,
       close_bidding_date
FROM   apps.pon_auction_headers_all_v
WHERE  close_bidding_date BETWEEN SYSDATE AND SYSDATE + 7
AND    auction_status = 'ACTIVE';
  • Sealed auctions with unlocked status: filter on SEALED_AUCTION_STATUS and SEALED_ACTUAL_UNLOCK_DATE.

Because the view inherits multi-org security from PON_AUCTION_HEADERS_ALL, queries should be executed under an appropriate operating unit or via the MO SQL profile to return the caller's authorized auctions.