[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_ITEM_PRICES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PON |
| FND Design Data: |  PON.PON_AUCTION_ITEM_PRICES_ALL
|
| Subobject Name: | |
| Status: | VALID |
PON_AUCTION_ITEM_PRICES stores negotiations item information. For every auction, RFQ, and RFI line there is a record in this table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PON_AUCTION_ITEM_PRICES_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 AUCTION_HEADER_ID
LINE_NUMBER
|
| PON_AUCTION_ITEM_PRICES_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_ID
|
| PON_AUCTION_ITEM_PRICES_ALL_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
|
| PON_AUCTION_ITEM_PRICES_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUCTION_HEADER_ID
DOCUMENT_DISP_LINE_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | 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 | Unique Identifier for category | ||
| CATEGORY_NAME | VARCHAR2 | (250) | Category name | |
| 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 | Location Identifier to which auction items will be shipped | ||
| NUMBER_OF_BIDS | NUMBER | Number of bids received for this item | ||
| LOWEST_BID_PRICE | NUMBER | Lowest bid price received | ||
| LOWEST_BID_QUANTITY | NUMBER | Quantity in lowest bid | ||
| LOWEST_BID_PROMISED_DATE | DATE | Promised date in lowest bid | ||
| LOWEST_BID_NUMBER | NUMBER | Bid Number for bid of lowest price | ||
| CLOSEST_PROMISED_DATE | DATE | Promised date of closest bid to target price | ||
| CLOSEST_BID_PRICE | NUMBER | Price of closest bid to target price | ||
| CLOSEST_BID_QUANTITY | NUMBER | Quantity of closest bid to target price | ||
| CLOSEST_BID_NUMBER | NUMBER | Bid Number of bid containing closest price | ||
| TARGET_PRICE | NUMBER | Target price for item | ||
| THRESHOLD_PRICE | NUMBER | Reserve price of item | ||
| BID_START_PRICE | NUMBER | Price that bids can start from | ||
| NOTE_TO_BIDDERS | VARCHAR2 | (4000) | Note to bidders | |
| ATTACHMENT_FLAG | VARCHAR2 | (1) | Y or N flag to indicate attachments for this item | |
| LANGUAGE_CODE | VARCHAR2 | (4) | No longer used | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| AUCTION_CREATION_DATE | DATE | Date of auction creation | ||
| CLOSE_BIDDING_DATE | DATE | Date bidding is closed for this item. | ||
| NUMBER_OF_EXTENSIONS | NUMBER | Number of auto extensions recieved on this line item | ||
| RESERVE_PRICE | NUMBER | Reserve price for 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 | ||
| BEST_BID_PROMISED_DATE | DATE | Promised date in best bid | ||
| BEST_BID_NUMBER | NUMBER | Bid Number of bid containing best price | ||
| TYPE | VARCHAR2 | (10) | Not currently used | |
| LOT_LINE_NUMBER | NUMBER | Not currently used | ||
| MIN_BID_INCREMENT | NUMBER | Minimum allowable increment in bid price if muliple bids are allowed | ||
| MIN_BID_DECREMENT | NUMBER | Minimum allowable decrement in bid price if multiple bids are allowed | ||
| 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 | ||
| UNIT_OF_MEASURE | VARCHAR2 | (25) | Not currently used | |
| HAS_ATTRIBUTES_FLAG | VARCHAR2 | (1) | Y or N flag to indicate item attibutes | |
| TRANSPORTATION_ORIGIN | VARCHAR2 | (240) | Transportation origin | |
| TRANSPORTATION_DEST | VARCHAR2 | (240) | Transportation destination | |
| AUCTION_HEADER_ID_ORIG_ROUND | NUMBER | Auction Header Identifier for the original round | ||
| AUCTION_HEADER_ID_PREV_ROUND | NUMBER | Auction Header Identifier for the previous round | ||
| LINE_NUMBER_ORIGINAL_ROUND | NUMBER | Auction line item of original auction round | ||
| LINE_NUMBER_PREV_ROUND | NUMBER | Auction line number of previous round | ||
| MULTIPLE_PRICES_FLAG | VARCHAR2 | (1) | Y or N flag to indicate bid consists of multiple prices | |
| RESIDUAL_QUANTITY | NUMBER | Residual quantity | ||
| PENDING_QUANTITY | NUMBER | Pending quantity | ||
| CANCEL_QUANTITY | NUMBER | Quantity cancelled | ||
| NUMBER_OF_COMMITMENTS | NUMBER | Number of commitments received | ||
| NUMBER_OF_PENDING_COMMITMENTS | NUMBER | Number of pending commitments | ||
| TBD_PRICING_FLAG | VARCHAR2 | (1) | Y or N flag to indicate pricing to be determined | |
| NEED_BY_START_DATE | DATE | Date which items are needed by | ||
| PRICE | NUMBER | Final price of item | ||
| FREIGHT_TERMS_CODE | VARCHAR2 | (25) | Code for freight terms | |
| 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 | 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 | |
| ORG_ID | NUMBER | org_id for multi-org | ||
| HAS_PRICE_ELEMENTS_FLAG | VARCHAR2 | (240) | Flag to indicate if price element exists for the line | |
| LINE_TYPE_ID | NUMBER | 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 | (20) | Requisition Number | |
| ITEM_REVISION | VARCHAR2 | (3) | Item Revision | |
| ITEM_ID | NUMBER | Item Id | ||
| ITEM_NUMBER | VARCHAR2 | (820) | Displayed Item Number | |
| 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 | (20) | Source Document Number for display | |
| SOURCE_LINE_NUMBER | VARCHAR2 | (20) | Source Document Line Number for Display | |
| SOURCE_DOC_ID | NUMBER | 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) | Is a response price required? | |
| QUANTITY_DISABLED_FLAG | VARCHAR2 | (1) | Is a response quantity required? | |
| JOB_ID | NUMBER | Job unique identifier | ||
| ADDITIONAL_JOB_DETAILS | VARCHAR2 | (2000) | Additional job details | |
| PO_AGREED_AMOUNT | NUMBER | Budgeted purchase order amount | ||
| HAS_PRICE_DIFFERENTIALS_FLAG | VARCHAR2 | (1) | Flag indicating if the item has price differentials | |
| DIFFERENTIAL_RESPONSE_TYPE | VARCHAR2 | (20) | Negotiation item's price differential response type | |
| PURCHASE_BASIS | VARCHAR2 | (25) | Line type purchase basis | |
| IS_QUANTITY_SCORED | VARCHAR2 | (1) | Flag that indicates if the quantity is included in scoring model for this line. | |
| IS_NEED_BY_DATE_SCORED | VARCHAR2 | (1) | Flag that indicates if the Need By Date is included in scoring model for this line. | |
| DISP_LINE_NUMBER | NUMBER | Displayed line number | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| LAST_AMENDMENT_UPDATE | NUMBER | Amendment number for which this line was last modified. | ||
| MODIFIED_DATE | DATE | Last modified date. | ||
| PRICE_DIFF_SHIPMENT_NUMBER | NUMBER | 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) | Indicates whether this line has payments defined under it. | |
| ADVANCE_AMOUNT | NUMBER | Amount that may be paid in advance for this line | ||
| RECOUPMENT_RATE_PERCENT | NUMBER | 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 | 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 | 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 | 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 | 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 | 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) | Expenditure type in Oracle Projects associated with this line | |
| PROJECT_EXP_ORGANIZATION_ID | NUMBER | Unique identifier of the expenditure organization associated with this line for Oracle Projects | ||
| PROJECT_EXPENDITURE_ITEM_DATE | DATE | Date used for accounting the transaction for this line in Oracle Projects | ||
| REQUEST_ID | NUMBER | Identifier of the concurrent program that last processed the row. | ||
| PROGRAM_APPLICATION_ID | NUMBER | Identifier of the owning application for the concurrent program that last updated this row. | ||
| PROGRAM_ID | NUMBER | Identifer of the concurrent program that last updated this row | ||
| PROGRAM_UPDATE_DATE | DATE | Date when this row was last updated by a concurrent program | ||
| BATCH_ID | NUMBER | In spreadsheet upload case, use it to only validate lines in the spreadsheet. | ||
| INTERFACE_LINE_ID | NUMBER | In spreadsheet upload case, use it to store the line number in spreadsheet file. | ||
| IP_CATEGORY_ID | NUMBER | iP category id. | ||
| HAS_QUANTITY_TIERS | VARCHAR2 | (1) | Indicates whether there are quantity tiers or not |
Cut, paste (and edit) the following text to query this object:
SELECT AUCTION_HEADER_ID
, AWARD_STATUS
, LINE_NUMBER
, ITEM_DESCRIPTION
, CATEGORY_ID
, CATEGORY_NAME
, UOM_CODE
, QUANTITY
, NEED_BY_DATE
, SHIP_TO_LOCATION_ID
, NUMBER_OF_BIDS
, LOWEST_BID_PRICE
, LOWEST_BID_QUANTITY
, LOWEST_BID_PROMISED_DATE
, LOWEST_BID_NUMBER
, CLOSEST_PROMISED_DATE
, CLOSEST_BID_PRICE
, CLOSEST_BID_QUANTITY
, CLOSEST_BID_NUMBER
, TARGET_PRICE
, THRESHOLD_PRICE
, BID_START_PRICE
, NOTE_TO_BIDDERS
, ATTACHMENT_FLAG
, LANGUAGE_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, AUCTION_CREATION_DATE
, CLOSE_BIDDING_DATE
, NUMBER_OF_EXTENSIONS
, RESERVE_PRICE
, DISPLAY_TARGET_PRICE_FLAG
, CURRENT_PRICE
, BEST_BID_PRICE
, BEST_BID_QUANTITY
, BEST_BID_PROMISED_DATE
, BEST_BID_NUMBER
, TYPE
, LOT_LINE_NUMBER
, MIN_BID_INCREMENT
, MIN_BID_DECREMENT
, BEST_BID_PROXY_LIMIT_PRICE
, BEST_BID_CURRENCY_PRICE
, BEST_BID_CURRENCY_CODE
, PO_MIN_REL_AMOUNT
, BEST_BID_FIRST_BID_PRICE
, UNIT_OF_MEASURE
, HAS_ATTRIBUTES_FLAG
, TRANSPORTATION_ORIGIN
, TRANSPORTATION_DEST
, AUCTION_HEADER_ID_ORIG_ROUND
, AUCTION_HEADER_ID_PREV_ROUND
, LINE_NUMBER_ORIGINAL_ROUND
, LINE_NUMBER_PREV_ROUND
, MULTIPLE_PRICES_FLAG
, RESIDUAL_QUANTITY
, PENDING_QUANTITY
, CANCEL_QUANTITY
, NUMBER_OF_COMMITMENTS
, NUMBER_OF_PENDING_COMMITMENTS
, TBD_PRICING_FLAG
, NEED_BY_START_DATE
, PRICE
, FREIGHT_TERMS_CODE
, AWARDED_QUANTITY
, MODIFIED_FLAG
, BEST_BID_BID_PRICE
, BEST_BID_SCORE
, BEST_BID_BID_NUMBER
, BEST_BID_BID_CURRENCY_PRICE
, BEST_BID_BID_CURRENCY_CODE
, ORG_ID
, HAS_PRICE_ELEMENTS_FLAG
, LINE_TYPE_ID
, ORDER_TYPE_LOOKUP_CODE
, LINE_ORIGINATION_CODE
, REQUISITION_NUMBER
, ITEM_REVISION
, ITEM_ID
, ITEM_NUMBER
, PRICE_BREAK_TYPE
, PRICE_BREAK_NEG_FLAG
, HAS_SHIPMENTS_FLAG
, SOURCE_DOC_NUMBER
, SOURCE_LINE_NUMBER
, SOURCE_DOC_ID
, SOURCE_LINE_ID
, ALLOCATION_STATUS
, PRICE_DISABLED_FLAG
, QUANTITY_DISABLED_FLAG
, JOB_ID
, ADDITIONAL_JOB_DETAILS
, PO_AGREED_AMOUNT
, HAS_PRICE_DIFFERENTIALS_FLAG
, DIFFERENTIAL_RESPONSE_TYPE
, PURCHASE_BASIS
, IS_QUANTITY_SCORED
, IS_NEED_BY_DATE_SCORED
, DISP_LINE_NUMBER
, LAST_UPDATE_LOGIN
, LAST_AMENDMENT_UPDATE
, MODIFIED_DATE
, PRICE_DIFF_SHIPMENT_NUMBER
, HAS_BUYER_PFS_FLAG
, UNIT_TARGET_PRICE
, UNIT_DISPLAY_TARGET_FLAG
, GROUP_TYPE
, PARENT_LINE_NUMBER
, DOCUMENT_DISP_LINE_NUMBER
, MAX_SUB_LINE_SEQUENCE_NUMBER
, SUB_LINE_SEQUENCE_NUMBER
, AWARD_MODE
, HAS_PAYMENTS_FLAG
, ADVANCE_AMOUNT
, RECOUPMENT_RATE_PERCENT
, PROGRESS_PYMT_RATE_PERCENT
, RETAINAGE_RATE_PERCENT
, MAX_RETAINAGE_AMOUNT
, WORK_APPROVER_USER_ID
, PROJECT_ID
, PROJECT_TASK_ID
, PROJECT_AWARD_ID
, PROJECT_EXPENDITURE_TYPE
, PROJECT_EXP_ORGANIZATION_ID
, PROJECT_EXPENDITURE_ITEM_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, BATCH_ID
, INTERFACE_LINE_ID
, IP_CATEGORY_ID
, HAS_QUANTITY_TIERS
FROM PON.PON_AUCTION_ITEM_PRICES_ALL;
PON.PON_AUCTION_ITEM_PRICES_ALL does not reference any database object
PON.PON_AUCTION_ITEM_PRICES_ALL is referenced by following:
APPS
PON_AUCTION_ITEM_PRICES
PON_AUCTION_ITEM_PRICES_ALL
|
|
|
|