DBA Data[Home] [Help] [Dependency Information]

TABLE: PON.PON_AUCTION_ITEM_PRICES_ALL

Object Details
Object Name: PON_AUCTION_ITEM_PRICES_ALL
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUCTION_ITEM_PRICES_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnLINE_NUMBER
PON_AUCTION_ITEM_PRICES_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
PON_AUCTION_ITEM_PRICES_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
PON_AUCTION_ITEM_PRICES_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnDOCUMENT_DISP_LINE_NUMBER
PON_AUCTION_ITEM_PRICES_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUDA_TEMPLATE_ID
PON_AUCTION_ITEM_PRICES_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
ColumnEXHIBIT_NUMBER
Columns
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
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
CLM_BASE_LINE_NUM NUMBER

Stores CLM base line number for option lines
CLM_FUNDED_FLAG VARCHAR2 (1)
Indicates if line is funded
CLM_INFO_FLAG VARCHAR2 (1)
Indicates if line is priced or informational
CLM_OPTION_FROM_DATE DATE

Option from date
CLM_OPTION_INDICATOR VARCHAR2 (1)
Indicates if line is base or option line
CLM_OPTION_NUM NUMBER

Indicates option number
CLM_OPTION_TO_DATE DATE

Option to date
GROUP_LINE_ID NUMBER

Line number of the clin to which a slin belongs
LINE_NUM_DISPLAY VARCHAR2 (100)
CLM Line number display
UDA_TEMPLATE_ID NUMBER

Uda Template Id
CLM_UNIT_PRICE NUMBER

CLM unit price
CLM_CONTRACT_TYPE VARCHAR2 (100)
CLM Contract type for complex pricing
CLM_COST_CONSTRAINT VARCHAR2 (100)
CLM cost constraint for complex pricing
CLM_IDC_TYPE VARCHAR2 (100)
DLM IDC type for complex pricing
CLM_AMOUNT NUMBER

Clm Amount
CLM_NEED_BY_DATE DATE

Date item needed at shipping location
FREIGHT_TERMS_CODE#1 VARCHAR2 (30)
Freight Terms Code
EXHIBIT_NUMBER VARCHAR2 (2)
Exhibit Number
CLM_DELIVERY_EVENT_CODE VARCHAR2 (30)
Clm Delivery Event Code
CLM_DELIVERY_PERIOD NUMBER

Period after the delivery event when the shipment is needed
CLM_DELIVERY_PERIOD_UOM VARCHAR2 (25)
UoM for CLM_DELIVERY_PERIOD
CLM_POP_DURATION NUMBER

Duration of the period of performance
CLM_POP_DURATION_UOM VARCHAR2 (25)
UoM for CLM_POP_DURATION
Query Text

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
,      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
,      CLM_BASE_LINE_NUM
,      CLM_FUNDED_FLAG
,      CLM_INFO_FLAG
,      CLM_OPTION_FROM_DATE
,      CLM_OPTION_INDICATOR
,      CLM_OPTION_NUM
,      CLM_OPTION_TO_DATE
,      GROUP_LINE_ID
,      LINE_NUM_DISPLAY
,      UDA_TEMPLATE_ID
,      CLM_UNIT_PRICE
,      CLM_CONTRACT_TYPE
,      CLM_COST_CONSTRAINT
,      CLM_IDC_TYPE
,      CLM_AMOUNT
,      CLM_NEED_BY_DATE
,      FREIGHT_TERMS_CODE#1
,      EXHIBIT_NUMBER
,      CLM_DELIVERY_EVENT_CODE
,      CLM_DELIVERY_PERIOD
,      CLM_DELIVERY_PERIOD_UOM
,      CLM_POP_DURATION
,      CLM_POP_DURATION_UOM
FROM PON.PON_AUCTION_ITEM_PRICES_ALL;

Dependencies

[top of page]

PON.PON_AUCTION_ITEM_PRICES_ALL does not reference any database object

PON.PON_AUCTION_ITEM_PRICES_ALL is referenced by following:

SchemaPON
ViewPON_AUCTION_ITEM_PRICES_ALL#