eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PON.PON_BID_ITEM_PRICES_INTERFACE

Object Details

Object Name:	PON_BID_ITEM_PRICES_INTERFACE
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_BID_ITEM_PRICES_INTERFACE
Subobject Name:
Status:	VALID

PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information that it is uploaded from a spreadsheet. Once the information is uploaded, the interface is processed and the errors are reported in PON_INTERFACE_ERRORS

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BID_ITEM_PRICES_INT_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID LINE_NUMBER
PON_BID_ITEM_PRICES_INT_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_ID INTERFACE_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Unique Batch Identifier
INTERFACE_LINE_ID	NUMBER		Yes	Line number corresponding to the spreadsheet line number
AUCTION_HEADER_ID	NUMBER		Yes	Negotiation Header Identifier
BID_NUMBER	NUMBER		Yes	Bid Number
LINE_NUMBER	NUMBER		Yes	Line Number
QUANTITY	NUMBER			Response Quantity
BID_CURRENCY_PRICE	NUMBER			Bid Price
NOTE_TO_AUCTION_OWNER	VARCHAR2	(4000)		Note to the Buyer
PROMISED_DATE	DATE			Promise Date entered by the supplier
BID_CURRENCY_LIMIT_PRICE	NUMBER			Proxy Bid Mininum Price
ATTACHMENT_DESC	VARCHAR2	(255)		Attachment Description
ATTACHMENT_URL	VARCHAR2	(255)		Attachment URL
PO_BID_MIN_REL_AMOUNT	NUMBER			Minimum release amount
BID_CURR_ADVANCE_AMOUNT	NUMBER			Amount that will be paid to the supplier as an advance in response currency
RECOUPMENT_RATE_PERCENT	NUMBER			Percentage of each invoice 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 completion of a milestone
RETAINAGE_RATE_PERCENT	NUMBER			Percentage of each invoice that will be retained until the work is completed and accepted
BID_CURR_MAX_RETAINAGE_AMT	NUMBER			Maximum amount that can be retained across all invoices for this line in response currency
DOCUMENT_DISP_LINE_NUMBER	VARCHAR2	(25)		Line Number
WORKSHEET_NAME	VARCHAR2	(80)		Worksheet Name
WORKSHEET_SEQUENCE_NUMBER	NUMBER			Worksheet Sequence Number
PROMISE_POP_START_DATE	DATE			Date items are promised at receivers address
PROMISE_POP_END_DATE	DATE			Date items are promised at receivers address
CLM_PROMISE_PERIOD	NUMBER			Period after the delivery event when the shipment is promised
CLM_PROMISE_PERIOD_UOM	VARCHAR2	(80)		UoM Lookup Meaning for CLM_PROMISE_PERIOD
CLM_PROMISE_PERIOD_UOM_CODE	VARCHAR2	(25)		UoM Lookup Code for CLM_PROMISE_PERIOD
CLM_PROMISE_POP_DURATION	NUMBER			Promised Duration of the period of performance
CLM_PROMISE_POP_DURATION_UOM	VARCHAR2	(80)		UoM Lookup Meaning for CLM_PROMISE_POP_DURATION
CLM_PROMISE_POP_DUR_UOM_CODE	VARCHAR2	(25)		UoM Lookup Code for CLM_PROMISE_POP_DURATION

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_ID
,      INTERFACE_LINE_ID
,      AUCTION_HEADER_ID
,      BID_NUMBER
,      LINE_NUMBER
,      QUANTITY
,      BID_CURRENCY_PRICE
,      NOTE_TO_AUCTION_OWNER
,      PROMISED_DATE
,      BID_CURRENCY_LIMIT_PRICE
,      ATTACHMENT_DESC
,      ATTACHMENT_URL
,      PO_BID_MIN_REL_AMOUNT
,      BID_CURR_ADVANCE_AMOUNT
,      RECOUPMENT_RATE_PERCENT
,      PROGRESS_PYMT_RATE_PERCENT
,      RETAINAGE_RATE_PERCENT
,      BID_CURR_MAX_RETAINAGE_AMT
,      DOCUMENT_DISP_LINE_NUMBER
,      WORKSHEET_NAME
,      WORKSHEET_SEQUENCE_NUMBER
,      PROMISE_POP_START_DATE
,      PROMISE_POP_END_DATE
,      CLM_PROMISE_PERIOD
,      CLM_PROMISE_PERIOD_UOM
,      CLM_PROMISE_PERIOD_UOM_CODE
,      CLM_PROMISE_POP_DURATION
,      CLM_PROMISE_POP_DURATION_UOM
,      CLM_PROMISE_POP_DUR_UOM_CODE
FROM PON.PON_BID_ITEM_PRICES_INTERFACE;

Dependencies

[top of page]

PON.PON_BID_ITEM_PRICES_INTERFACE does not reference any database object

PON.PON_BID_ITEM_PRICES_INTERFACE is referenced by following:

PON: PON_BID_ITEM_PRICES_INTERFACE#