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

TABLE: PON.PON_AUCTION_SUMMARY

Object Details
Object Name: PON_AUCTION_SUMMARY
Object Type: TABLE
Owner: PON
FND Design Data: TablePON.PON_AUCTION_SUMMARY
Subobject Name:
Status: VALID


PON_AUCTION_SUMMARY stores temporary data to be displayed in the summary page before a negotiation is created.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUCTION_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnAUCTION_ID
ColumnLINE_NUMBER
ColumnBID_NUMBER
Columns
Name Datatype Length Mandatory Comments
AUCTION_ID NUMBER
Yes System-generated unique Identifier of Auction
LINE_NUMBER NUMBER
Yes Auction Line Item
TRADING_PARTNER_ID NUMBER

Unique Identifier for trading partner of awarded bid
AUCTION_PRICE NUMBER

Target price of auction
AWARD_QUANTITY NUMBER

Quantity awarded
BATCH_ID NUMBER
Yes Batch ID
BID_PRICE NUMBER

Price of awarded bid
TRADING_PARTNER_NAME VARCHAR2 (255)
Trading partner name of awarded bid
TRADING_PARTNER_CONTACT_ID NUMBER

Unique Identifier of trading partner contact for the awarded response
RESPONSE_QUANTITY NUMBER

Response Quantity
RANK NUMBER

Rank of the response
BID_NUMBER NUMBER
Yes Bid Number of the response
AWARD_SHIPMENT_NUMBER NUMBER

Reference to bid shipment number in case award is based on Qty tiers
Query Text

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


SELECT AUCTION_ID
,      LINE_NUMBER
,      TRADING_PARTNER_ID
,      AUCTION_PRICE
,      AWARD_QUANTITY
,      BATCH_ID
,      BID_PRICE
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_CONTACT_ID
,      RESPONSE_QUANTITY
,      RANK
,      BID_NUMBER
,      AWARD_SHIPMENT_NUMBER
FROM PON.PON_AUCTION_SUMMARY;

Dependencies

[top of page]

PON.PON_AUCTION_SUMMARY does not reference any database object

PON.PON_AUCTION_SUMMARY is referenced by following:

SchemaPON
ViewPON_AUCTION_SUMMARY#