PON_AUCTION_ITEM_PRICES_ALL
PON_AUCTION_ITEM_PRICES stores negotiations item information. For every auction, RFQ, and RFI line there is a record in this table.
Details
-
Schema: FUSION
-
Object owner: PON
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PON_AUCTION_ITEM_PRICES_ALL_PK |
AUCTION_HEADER_ID, LINE_NUMBER |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | 18 | Yes | Auction Header Identifier | |
| AWARD_STATUS | VARCHAR2 | 25 | Award status for this item | ||
| LINE_NUMBER | NUMBER | Yes | Internal Line Number | ||
| ITEM_DESCRIPTION | VARCHAR2 | 2500 | Item description | ||
| CATEGORY_ID | NUMBER | 18 | Unique Identifier for category | ||
| UOM_CODE | VARCHAR2 | 3 | Code for unit of measure | ||
| QUANTITY | NUMBER | Quantity | |||
| NEED_BY_DATE | DATE | Date item needed at shipping location | |||
| SHIP_TO_LOCATION_ID | NUMBER | 18 | Location Identifier to which auction items will be shipped | ||
| NUMBER_OF_BIDS | NUMBER | Number of bids received for this item | |||
| TARGET_PRICE | NUMBER | Target price for item | |||
| BID_START_PRICE | NUMBER | Price that bids can start from | |||
| NOTE_TO_BIDDERS | VARCHAR2 | 4000 | Note to bidders | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CLOSE_BIDDING_DATE | DATE | Date bidding is closed for this item. | |||
| NUMBER_OF_EXTENSIONS | NUMBER | Number of auto extensions recieved on this line item | |||
| DISPLAY_TARGET_PRICE_FLAG | VARCHAR2 | 1 | Y or N flag to indicate display target price to bidders | ||
| CURRENT_PRICE | NUMBER | Current price of item being paid outside auction | |||
| BEST_BID_PRICE | NUMBER | Price in best bid | |||
| BEST_BID_QUANTITY | NUMBER | Quantity in best bid for both best price and best price/score ratio | |||
| BEST_BID_PROMISED_DATE | DATE | Promised date in best bid | |||
| BEST_BID_NUMBER | NUMBER | 18 | Bid Number of bid containing best price | ||
| BEST_BID_PROXY_LIMIT_PRICE | NUMBER | Proxy Bid price for the best bid | |||
| BEST_BID_CURRENCY_PRICE | NUMBER | Best bid price in the best bid currency | |||
| BEST_BID_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of best bid | ||
| PO_MIN_REL_AMOUNT | NUMBER | Purhcase Order minimum release amount | |||
| BEST_BID_FIRST_BID_PRICE | NUMBER | First Bid price received | |||
| HAS_ATTRIBUTES_FLAG | VARCHAR2 | 1 | Y or N flag to indicate item attibutes | ||
| AWARDED_QUANTITY | NUMBER | total quantity awarded for auction | |||
| MODIFIED_FLAG | VARCHAR2 | 1 | Y or N flag. Used to mark if the item is modified in the current round compared to the previous round. | ||
| BEST_BID_BID_PRICE | NUMBER | Price for bid with the best price / score ratio | |||
| BEST_BID_SCORE | NUMBER | Score for bid with the best price / score ratio | |||
| BEST_BID_BID_NUMBER | NUMBER | 18 | Bid number for bid with the best price / score ratio | ||
| BEST_BID_BID_CURRENCY_PRICE | NUMBER | price in bid currency for bid with the best price/score | |||
| BEST_BID_BID_CURRENCY_CODE | VARCHAR2 | 15 | bid currency code for bid with the best price/score | ||
| PRC_BU_ID | NUMBER | 18 | Yes | Procurement Business Unit Id | |
| HAS_PRICE_ELEMENTS_FLAG | VARCHAR2 | 1 | Flag to indicate if any supplier cost factors exists for the line | ||
| LINE_TYPE_ID | NUMBER | 18 | Line Type Id | ||
| ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | 25 | Line Type Basis Lookup code | ||
| LINE_ORIGINATION_CODE | VARCHAR2 | 50 | Line Origination Code | ||
| REQUISITION_NUMBER | VARCHAR2 | 64 | Requisition Number | ||
| ITEM_REVISION | VARCHAR2 | 18 | Item Revision | ||
| ITEM_ID | NUMBER | 18 | Item Id | ||
| PRICE_BREAK_TYPE | VARCHAR2 | 25 | Type of Price Break | ||
| PRICE_BREAK_NEG_FLAG | VARCHAR2 | 1 | Are Price Breaks Negotiable? | ||
| HAS_SHIPMENTS_FLAG | VARCHAR2 | 1 | Does this line have shipments? | ||
| SOURCE_DOC_NUMBER | VARCHAR2 | 30 | Source Document Number for display | ||
| SOURCE_LINE_NUMBER | VARCHAR2 | 20 | Source Document Line Number for Display | ||
| SOURCE_DOC_ID | NUMBER | 18 | Source Document Id | ||
| SOURCE_LINE_ID | NUMBER | Source Document Line Id | |||
| ALLOCATION_STATUS | VARCHAR2 | 30 | Indicated the allocation status of the Item | ||
| PRICE_DISABLED_FLAG | VARCHAR2 | 1 | Used in RFIs, indicates if price is disabled for the line. | ||
| QUANTITY_DISABLED_FLAG | VARCHAR2 | 1 | Used in RFIs, indicates if quantity is disabled for the line. | ||
| JOB_ID | NUMBER | Not currently used. Job unique identifier | |||
| ADDITIONAL_JOB_DETAILS | VARCHAR2 | 2000 | Not currently used. Additional job details | ||
| PO_AGREED_AMOUNT | NUMBER | Budgeted purchase order amount | |||
| HAS_PRICE_DIFFERENTIALS_FLAG | VARCHAR2 | 1 | Not currently used. Flag indicating if the item has price differentials | ||
| DIFFERENTIAL_RESPONSE_TYPE | VARCHAR2 | 20 | Not currently used. Negotiation item's price differential response type | ||
| PURCHASE_BASIS | VARCHAR2 | 30 | Line type purchase basis | ||
| DISP_LINE_NUMBER | NUMBER | internal number used for ordering lines | |||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_AMENDMENT_UPDATE | NUMBER | Amendment number for which this line was last modified. | |||
| MODIFIED_DATE | DATE | Last modified date. | |||
| PRICE_DIFF_SHIPMENT_NUMBER | NUMBER | Not currently used. Price differential shipment number (used for OA Framework VL) | |||
| HAS_BUYER_PFS_FLAG | VARCHAR2 | 1 | Indicates whether this line has any buyer price factors or not. | ||
| UNIT_TARGET_PRICE | NUMBER | The target price for auction item unit price. | |||
| UNIT_DISPLAY_TARGET_FLAG | VARCHAR2 | 1 | Indicates whether display target price of unit price to suppliers or not. | ||
| GROUP_TYPE | VARCHAR2 | 25 | Type of Line | ||
| PARENT_LINE_NUMBER | NUMBER | Line Number of Parent Lot/Group | |||
| DOCUMENT_DISP_LINE_NUMBER | VARCHAR2 | 25 | Document line number to display (e.g. 2.1) | ||
| MAX_SUB_LINE_SEQUENCE_NUMBER | NUMBER | Max sub-line sequence number for a lot/group. | |||
| SUB_LINE_SEQUENCE_NUMBER | NUMBER | Lot/Group line's sequence within the lot/group | |||
| AWARD_MODE | VARCHAR2 | 30 | Award mode | ||
| HAS_PAYMENTS_FLAG | VARCHAR2 | 1 | Not currently used. Indicates whether this line has payments defined under it. | ||
| ADVANCE_AMOUNT | NUMBER | Not currently used. Amount that may be paid in advance for this line | |||
| RECOUPMENT_RATE_PERCENT | NUMBER | Not currently used. Percentage of the amount of each invoice for this line that can be recouped when financing or advances are provided to the supplier. | |||
| PROGRESS_PYMT_RATE_PERCENT | NUMBER | Not currently used. Percentage of the amount that will be due to the Supplier upon fulfillment of a pay item for each invoice for this line | |||
| RETAINAGE_RATE_PERCENT | NUMBER | Percentage of the invoice line amount that will be retained until the work is completed and accepted. | |||
| MAX_RETAINAGE_AMOUNT | NUMBER | Maximum amount that can be retained across all invoices for this line | |||
| WORK_APPROVER_USER_ID | NUMBER | Not currently used. Identifier of the user who is responsible for confirming that the supplier has performed work as agreed. This is used as for defaulting to the pay item | |||
| PROJECT_ID | NUMBER | Not currently used. Unique identifier of the project in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing | |||
| PROJECT_TASK_ID | NUMBER | Not currently used. Unique identifier of the task in Oracle Projects to which the cost of this line will be charged when executed in Oracle Purchasing | |||
| PROJECT_AWARD_ID | NUMBER | Not currently used. Unique identifier of the Award which is association with this line. This may be populated only if integration with Oracle Grants is enabled | |||
| PROJECT_EXPENDITURE_TYPE | VARCHAR2 | 30 | Not currently used. Expenditure type in Oracle Projects associated with this line | ||
| PROJECT_EXP_ORGANIZATION_ID | NUMBER | Not currently used. Unique identifier of the expenditure organization associated with this line for Oracle Projects | |||
| PROJECT_EXPENDITURE_ITEM_DATE | DATE | Not currently used. Date used for accounting the transaction for this line in Oracle Projects | |||
| HAS_QUANTITY_TIERS | VARCHAR2 | 1 | Indicates whether there are quantity tiers or not | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| REQ_BU_ID | NUMBER | 18 | Identifies the Requisitioning Business Unit for this item | ||
| NO_AWARD | VARCHAR2 | 1 | Flag to identify if the negotiation line has been marked as 'No Award' | ||
| INV_ORG_ID | NUMBER | 18 | Inventory organization id. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP6 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP7 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP8 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP9 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_TIMESTAMP10 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ALLOW_ALTERNATE_LINES | VARCHAR2 | 30 | Value of allow alternate lines. Possible values are YES and NO. | ||
| CARRIER_ID | NUMBER | 18 | The carrier id of shipping method. | ||
| MODE_OF_TRANSPORT | VARCHAR2 | 30 | Type of transportation used to ship the product, such as truck, air or boat. | ||
| SERVICE_LEVEL | VARCHAR2 | 30 | Priority of transportation that affects how quickly goods are transported. | ||
| RECOMMENDED_AWARD_AMOUNT | NUMBER | Recommended Award Amount for a line | |||
| REQUESTED_SHIP_DATE | DATE | The date when the buyer company wants the supplier to ship out the designated product that the buyer company intends to buy. | |||
| REQUESTED_DELIVERY_DATE | DATE | The date when the designated product that the procurement organization intends to buy is needed. | |||
| BEST_BID_TRANS_PRICE | NUMBER | Price of the Bid with the best transformed price. | |||
| BEST_BID_TRANS_NUMBER | NUMBER | Bid number of the Bid with the best transformed price. | |||
| BEST_BID_BID_TRANS_PRICE | NUMBER | Price of the Bid with the best transformed price / score ratio. | |||
| BEST_BID_BID_TRANS_NUMBER | NUMBER | Bid number of the Bid with the best transformed price / score ratio. | |||
| BEST_BID_TRANS_SCORE | NUMBER | Score of the bid with the best transformed price / score ratio. | |||
| BEST_BID_TRANS_QUANTITY | NUMBER | Quantity in best bid for both best transformed price and best transformed price/score ratio | |||
| MIN_BID_LINE_DECREMENT | NUMBER | Minimum allowable bid line decrement in a bidders bid line if multiple bids are allowed. | |||
| ALLOCATION_TOTAL | NUMBER | Total allocated quantity or amount. This column is populated only for Large Negotiations on creating purchasing documents. | |||
| REQUISITION_TOTAL | NUMBER | Total requisition quantity or amount. This column is populated only for Large Negotiations on creating purchasing documents. | |||
| AWARD_TOTAL | NUMBER | Total award quantity or amount. This column is populated only for Large Negotiations on creating purchasing documents. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PON_AUCTION_ITEM_PRICES_ALL | pon_auction_headers_all | AUCTION_HEADER_ID |
| PON_AUCTION_ITEM_PRICES_ALL | egp_categories_b | CATEGORY_ID |
| PON_AUCTION_ITEM_PRICES_ALL | pon_bid_headers | BEST_BID_NUMBER |
| PON_AUCTION_ITEM_PRICES_ALL | pon_bid_headers | BEST_BID_BID_NUMBER |
| PON_AUCTION_ITEM_PRICES_ALL | po_line_types_b | LINE_TYPE_ID |
| PON_AUCTION_ITEM_PRICES_ALL | pon_auction_item_prices_all | AUCTION_HEADER_ID, PARENT_LINE_NUMBER |
| pon_bid_item_prices | pon_auction_item_prices_all | AUCTION_HEADER_ID, AUCTION_LINE_NUMBER |
| pon_party_line_exclusions | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
| pon_bid_po_lines | pon_auction_item_prices_all | AUCTION_HEADER_ID, AUCTION_LINE_NUMBER |
| pon_price_elements | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
| pon_bid_shipments | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
| pon_backing_req_history | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
| pon_auction_shipments_all | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
| pon_bid_po_lines_history | pon_auction_item_prices_all | AUCTION_HEADER_ID, AUCTION_LINE_NUMBER |
| pon_auction_item_prices_all | pon_auction_item_prices_all | AUCTION_HEADER_ID, PARENT_LINE_NUMBER |
| pon_backing_requisitions | pon_auction_item_prices_all | AUCTION_HEADER_ID, LINE_NUMBER |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PON_AUC_ITEM_PRICES_ALL_N1 | Non Unique | Default | AUCTION_HEADER_ID, DOCUMENT_DISP_LINE_NUMBER |
| PON_AUC_ITEM_PRICES_ALL_N2 | Non Unique | Default | AUCTION_HEADER_ID, PARENT_LINE_NUMBER, DISP_LINE_NUMBER |
| PON_AUC_ITEM_PRICES_ALL_N3 | Non Unique | Default | LAST_UPDATE_DATE |
| PON_AUC_ITEM_PRICES_ALL_U1 | Unique | Default | AUCTION_HEADER_ID, LINE_NUMBER |