Oracle Fusion · Data dictionary
PON_AUCTION_ITEM_PRICES_ALL
ProcurementUsed in 11 subject areas34 reporting columns
Sourcing / Negotiations (PON), transaction table (rows scoped across all operating units).
Primary key: not yet catalogued for PON_AUCTION_ITEM_PRICES_ALL, reference Oracle Tables & Views guide.
Joins (inferred from key columns): AUCTION_HEADER_ID → PON_AUCTION_HEADERS_ALL
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOW_ALTERNATE_LINES | ● | Allow alternate lines. | |
| AUCTION_HEADER_ID | ● | Identifier for the auction header. | |
| AWARD_STATUS | ● | Status of the award. | |
| BEST_BID_BID_PRICE | ● | Best bid bid price. | |
| BEST_BID_CURRENCY_CODE | ● | Currency code for the best bid. | |
| BEST_BID_CURRENCY_PRICE | ● | Best bid currency price. | |
| BEST_BID_FIRST_BID_PRICE | ● | Best bid first bid price. | |
| BEST_BID_NUMBER | ● | Best bid number. | |
| BEST_BID_PRICE | ● | Best bid price. | |
| BEST_BID_QUANTITY | ● | Best bid quantity. | |
| BEST_BID_SCORE | ● | Best bid score. | |
| BID_START_PRICE | ● | Bid start price. | |
| CURRENT_PRICE | ● | Current price. | |
| DISPLAY_TARGET_PRICE_FLAG | ● | Indicator (Y/N) for the display target price. | |
| DOCUMENT_DISP_LINE_NUMBER | ● | Document disp line number. | |
| GROUP_TYPE | ● | Type of group. | |
| ITEM_DESCRIPTION | ● | Description of the item. | |
| ITEM_ID | ● | Identifier for the item. | |
| ITEM_REVISION | ● | Item revision. | |
| LINE_NUMBER | ● | Line number. | |
| NEED_BY_DATE | ● | Need by date. | |
| NOTE_TO_BIDDERS | ● | Note to bidders. | |
| ORDER_TYPE_LOOKUP_CODE | ● | Lookup code for the order type. | |
| PO_AGREED_AMOUNT | ● | Purchase order agreed amount. | |
| PO_MIN_REL_AMOUNT | ● | Purchase order min rel amount. | |
| QUANTITY | ● | Quantity. | |
| REQUESTED_DELIVERY_DATE | ● | Requested delivery date. | |
| REQUESTED_SHIP_DATE | ● | Requested shipment date. | |
| REQUISITION_NUMBER | ● | Requisition number. | |
| SOURCE_DOC_NUMBER | ● | Source doc number. | |
| SOURCE_LINE_NUMBER | ● | Source line number. | |
| TARGET_PRICE | ● | Target price. | |
| UNIT_TARGET_PRICE | ● | Unit target price. | |
| UOM_CODE | ● | Code identifying the unit of measure. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. In OTBI they combine only through shared dimensions or set operators such as union, inside one application; the owned conformed model joins this table across modules and systems on conformed keys.
- Maintenance Management - Purchased Item Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Procurement - Pending Change Orders Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Agreements Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Procurement - Spend Real Time
- Sourcing - Supplier Awards Real Time
- Sourcing - Supplier Negotiations Real Time
- Sourcing - Supplier Responses Real Time
Need the extract + dbt staging for PON_AUCTION_ITEM_PRICES_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table