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_BIDDING_PARTIES

Object Details

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

PON_BIDDING_PARTIES stores the trading partners that are either part of a trading partner list or were invited to participate in a negotiation.
If AUCTION_HEADER_ID is populated, then the trading partner was invited to a participate in a negotiation. Otherwise, if LIST_ID is populated, then the trading partner is a member of a trading partners list. Only one of these two columns is populated for any single record.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BIDDING_PARTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID
PON_BIDDING_PARTIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRADING_PARTNER_ID
PON_BIDDING_PARTIES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LIST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER			Auction Header Identifier
LIST_ID	NUMBER			Unique Identifier of bidders list
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
SEQUENCE	NUMBER			Order indication for displaying the parties
TRADING_PARTNER_NAME	VARCHAR2	(240)		Bidder trading partner name
TRADING_PARTNER_ID	NUMBER			Identifier for Bidder trading partner
TRADING_PARTNER_CONTACT_NAME	VARCHAR2	(240)		Contact person for bidder trading partner
TRADING_PARTNER_CONTACT_ID	NUMBER			Identifier for contact person of bidder trading partner
NEW_SUPPLIER_NAME	VARCHAR2	(240)		New supplier name that is being invited to bid but not yet registered
NEW_SUPPLIER_CONTACT_FNAME	VARCHAR2	(240)		First name for contact person if new supplier
NEW_SUPPLIER_CONTACT_LNAME	VARCHAR2	(240)		Last name for contact person if new supplier
NEW_SUPPLIER_EMAIL	VARCHAR2	(240)		New supplier email
NOTE_TO_NEW_SUPPLIER	VARCHAR2	(240)		Note to new supplier
WF_USER_NAME	VARCHAR2	(30)		Workflow user name
INVITATION_ID	NUMBER			Identifier for invitation
CREATION_DATE	DATE			Standard Who column
CREATED_BY	NUMBER			Standard Who column
AUCTION_CREATION_DATE	DATE			Date of auction creation
BID_CURRENCY_CODE	VARCHAR2	(15)		Currency code specific to this bidder
NUMBER_PRICE_DECIMALS	NUMBER			Precision in bid price
RATE	NUMBER			Currency conversion rate specifc to this bidder
DERIVE_TYPE	VARCHAR2	(8)		distinguishes the bidder specific currency as EMU if it is EMU derived otherwise, NULL
ADDITIONAL_CONTACT_EMAIL	VARCHAR2	(240)		email address for additional negotiation contact invited
ROUND_NUMBER	NUMBER			The round number in which the bidder is invited ( mainly used in multi-round negotiations )
SUPP_ACKNOWLEDGEMENT	VARCHAR2	(1)		'Y', 'N', or NULL indicating whether invited bidder intends to participate
ACK_PARTNER_CONTACT_NAME	VARCHAR2	(240)		username of participant who entered the latest acknowledgement info
ACK_PARTNER_CONTACT_ID	NUMBER			id of participant who entered latest acknowledgement info
ACKNOWLEDGEMENT_TIME	DATE			latest system time during which acknowledgement info was entered
ACK_NOTE_TO_AUCTIONEER	VARCHAR2	(4000)		reason invited bidder will or will not participate
REGISTRATION_ID	NUMBER			UMF unique identifier for additional contact invitations
RATE_DSP	NUMBER			User entered rate from bid to auction currency
WF_ITEM_KEY	VARCHAR2	(240)		Track the workflow item key for the invitation process
LAST_AMENDMENT_UPDATE	NUMBER			Last amendment number when this record was modified.
VENDOR_SITE_ID	NUMBER			Foreign key to po_vendor_sites_all
VENDOR_SITE_CODE	VARCHAR2	(15)		Stores the vendor site code of invited vendor from po_vendor_sites_all
MODIFIED_FLAG	VARCHAR2	(1)		Y/N flag to indicate if this record was modified between rounds or amendments.
ACCESS_TYPE	VARCHAR2	(25)		Denotes access to negotiation lines
REQUESTED_SUPPLIER_ID	NUMBER			Requested Supplier id
REQUESTED_SUPPLIER_CONTACT_ID	NUMBER			Requested Supplier Contact Id
REQUESTED_SUPPLIER_NAME	VARCHAR2	(240)		Requested Supplier Name
REQUESTED_SUPP_CONTACT_NAME	VARCHAR2	(300)		Requested Supplier Contact Name
FROM_EMD_FLAG	VARCHAR2	(1)		Indicates whether supplier is added during EMD process
EXEMPT_FLAG	VARCHAR2	(1)		Indicates if the supplier has been exempted from paying EMD amount

Query Text

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


SELECT AUCTION_HEADER_ID
,      LIST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      SEQUENCE
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      NEW_SUPPLIER_NAME
,      NEW_SUPPLIER_CONTACT_FNAME
,      NEW_SUPPLIER_CONTACT_LNAME
,      NEW_SUPPLIER_EMAIL
,      NOTE_TO_NEW_SUPPLIER
,      WF_USER_NAME
,      INVITATION_ID
,      CREATION_DATE
,      CREATED_BY
,      AUCTION_CREATION_DATE
,      BID_CURRENCY_CODE
,      NUMBER_PRICE_DECIMALS
,      RATE
,      DERIVE_TYPE
,      ADDITIONAL_CONTACT_EMAIL
,      ROUND_NUMBER
,      SUPP_ACKNOWLEDGEMENT
,      ACK_PARTNER_CONTACT_NAME
,      ACK_PARTNER_CONTACT_ID
,      ACKNOWLEDGEMENT_TIME
,      ACK_NOTE_TO_AUCTIONEER
,      REGISTRATION_ID
,      RATE_DSP
,      WF_ITEM_KEY
,      LAST_AMENDMENT_UPDATE
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      MODIFIED_FLAG
,      ACCESS_TYPE
,      REQUESTED_SUPPLIER_ID
,      REQUESTED_SUPPLIER_CONTACT_ID
,      REQUESTED_SUPPLIER_NAME
,      REQUESTED_SUPP_CONTACT_NAME
,      FROM_EMD_FLAG
,      EXEMPT_FLAG
FROM PON.PON_BIDDING_PARTIES;

Dependencies

[top of page]

PON.PON_BIDDING_PARTIES does not reference any database object

PON.PON_BIDDING_PARTIES is referenced by following:

PON: PON_BIDDING_PARTIES#