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_PAYMENTS_SHIPMENTS

Object Details

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

PON_BID_PAYMENTS_SHIPMENTS contains the details of the payments that are defined on a response with complex services. This corresponds to the PON_AUC_PAYMENTS_SHIPMENTS table which defines payments on a negotiation.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BID_PAYMENTS_SHIPMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BID_PAYMENT_ID
PON_BID_PAYMENTS_SHIPMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID BID_NUMBER BID_LINE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
BID_PAYMENT_ID	NUMBER		Yes	Unique identifier of this payment
BID_NUMBER	NUMBER		Yes	Unique identifier of the response to which this payment belongs
BID_LINE_NUMBER	NUMBER		Yes	Unique identifier of the response line to which this payment belongs
AUCTION_HEADER_ID	NUMBER		Yes	Unique identifier of the negotiation to which this payment belongs
AUCTION_LINE_NUMBER	NUMBER		Yes	Unique identifier of the negotiation line to which this payment belongs
PAYMENT_DISPLAY_NUMBER	NUMBER			User-entered number for this payment. This has to be unique within a line
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PAYMENT_DESCRIPTION	VARCHAR2	(240)		User entered description of the payment
AUCTION_PAYMENT_ID	NUMBER			Unique identifier of the negotiation payment from which this bid payment was created/defaulted. This link is maintained and this column populated only if the supplier cannot modify payments.
PAYMENT_TYPE_CODE	VARCHAR2	(30)		Indicates the type of payment line. This can be one of 'MILESTONE', 'RATE' or 'LUMPSUM'.
QUANTITY	NUMBER			Quantity to which the price on this payment applies. This is applicable for payments of type 'RATE' or if the parent line had a quantity. If the line has a quantity then this is same as the line quantity
UOM_CODE	VARCHAR2	(3)		Unit of measure for payments pertaining to a quantity
PRICE	NUMBER			Unit price for the payment in auction currency
BID_CURRENCY_PRICE	NUMBER			Unit price for the payment in response currency as given by the Supplier
PROMISED_DATE	DATE			Date by which the work will be completed or the goods will be delivered.
OLD_PAYMENT_DISPLAY_NUMBER	NUMBER			Value from column PAYMENT_DISPLAY_NUMBER of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_PAYMENT_TYPE_CODE	VARCHAR2	(30)		Value from column PAYMENT_TYPE_CODE of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_PAYMENT_DESCRIPTION	VARCHAR2	(240)		Value from column PAYMENT_DESCRIPTION of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_QUANTITY	NUMBER			Value from column QUANTITY of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_UOM_CODE	VARCHAR2	(3)		Value from column UOM_CODE of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_BID_CURRENCY_PRICE	NUMBER			Value from column BID_CURRENCY_PRICE of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid
OLD_PROMISED_DATE	DATE			Value from column PROMISED_DATE of the prior bid. This is only populated when the supplier's bid is defaulted from an earlier bid

Query Text

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


SELECT BID_PAYMENT_ID
,      BID_NUMBER
,      BID_LINE_NUMBER
,      AUCTION_HEADER_ID
,      AUCTION_LINE_NUMBER
,      PAYMENT_DISPLAY_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PAYMENT_DESCRIPTION
,      AUCTION_PAYMENT_ID
,      PAYMENT_TYPE_CODE
,      QUANTITY
,      UOM_CODE
,      PRICE
,      BID_CURRENCY_PRICE
,      PROMISED_DATE
,      OLD_PAYMENT_DISPLAY_NUMBER
,      OLD_PAYMENT_TYPE_CODE
,      OLD_PAYMENT_DESCRIPTION
,      OLD_QUANTITY
,      OLD_UOM_CODE
,      OLD_BID_CURRENCY_PRICE
,      OLD_PROMISED_DATE
FROM PON.PON_BID_PAYMENTS_SHIPMENTS;

Dependencies

[top of page]

PON.PON_BID_PAYMENTS_SHIPMENTS does not reference any database object

PON.PON_BID_PAYMENTS_SHIPMENTS is referenced by following:

PON: PON_BID_PAYMENTS_SHIPMENTS#