Oracle Fusion · Data dictionary
PON_BID_ITEM_PRICES
ProcurementUsed in 11 subject areas30 reporting columns
Sourcing / Negotiations (PON).
Primary key: not yet catalogued for PON_BID_ITEM_PRICES, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALTERNATE_LINE_DESCRIPTION | ● | Description of the alternate line. | |
| ALTERNATE_LINE_FLAG | ● | Indicator (Y/N) for the alternate line. | |
| AUCTION_LINE_NUMBER | ● | Auction line number. | |
| AWARD_PRICE | ● | Award price. | |
| AWARD_QUANTITY | ● | Award quantity. | |
| AWARD_STATUS | ● | Status of the award. | |
| BID_CURRENCY_PRICE | ● | Bid currency price. | |
| BID_CURRENCY_UNIT_PRICE | ● | Bid currency unit price. | |
| BID_NUMBER | ● | Bid number. | |
| BID_START_PRICE | ● | Bid start price. | |
| DOCUMENT_DISP_LINE_NUMBER | ● | Document disp line number. | |
| HAS_BID_FLAG | ● | Indicator (Y/N) for the has bid. | |
| LINE_NUMBER | ● | Line number. | |
| NOTE_TO_AUCTION_OWNER | ● | Note to auction owner. | |
| PER_UNIT_PRICE_COMPONENT | ● | Per unit price component. | |
| PO_BID_MIN_REL_AMOUNT | ● | Purchase order bid min rel amount. | |
| PO_MIN_REL_AMOUNT | ● | Purchase order min rel amount. | |
| PRICE | ● | Price. | |
| PROMISED_DATE | ● | Promised date. | |
| PROMISED_DELIVERY_DATE | ● | Promised delivery date. | |
| PROMISED_SHIP_DATE | ● | Promised shipment date. | |
| PROXY_BID_FLAG | ● | Indicator (Y/N) for the proxy bid. | |
| PROXY_BID_LIMIT_PRICE | ● | Proxy bid limit price. | |
| PURCHASING_ITEM_DESC | ● | Description of the purchasing item. | |
| QUANTITY | ● | Quantity. | |
| RANK | ● | Rank. | |
| TOTAL_WEIGHTED_SCORE | ● | Total weighted score. | |
| UNIT_PRICE | ● | Unit price. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| UOM_CONVERSION_FACTOR | ● | Unit of measure conversion factor. |
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. You can't join across them in OTBI, the owned conformed model joins them on shared 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_BID_ITEM_PRICES?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table