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_HEADERS

Object Details

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

PON_BID_HEADERS stores responses to negotiations. This tables stores header level information, such as response number, trading partner and contact information, business terms and conditions, currency, et cetera.

Oracle Sourcing creates a record in this table for every response to a negotiation. The STATUS column indicates whether the response is:
- the most recent available in the marketplace (ACTIVE)
- a disqualified response (DISQUALIFIED)
- an old response (ARCHIVED)

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_BID_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BID_NUMBER
PON_BID_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRADING_PARTNER_CONTACT_ID BID_STATUS
PON_BID_HEADERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRADING_PARTNER_ID BID_STATUS
PON_BID_HEADERS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
PON_BID_HEADERS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID SURROG_BID_CREATED_TP_ID BID_STATUS
PON_BID_HEADERS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BID_NUMBER	NUMBER		Yes	System-generated unique number
AUCTION_HEADER_ID	NUMBER		Yes	Auction Header Identifier
BIDDERS_BID_NUMBER	VARCHAR2	(25)		Bidder provided bid number
BID_TYPE	VARCHAR2	(25)		Bid type
CONTRACT_TYPE	VARCHAR2	(25)		Contract type either Sport Buy or Long Term agreement
TRADING_PARTNER_CONTACT_NAME	VARCHAR2	(255)		Contact person for Bidder trading partner
TRADING_PARTNER_CONTACT_ID	NUMBER			Identifier for contact person of bidder trading partner
TRADING_PARTNER_NAME	VARCHAR2	(255)		Bidder trading partner name
TRADING_PARTNER_ID	NUMBER			Identifier for bidder trading partner
PHONE	VARCHAR2	(100)		Phone number
FAX	VARCHAR2	(100)		Fax number
EMAIL	VARCHAR2	(100)		Email address
BID_STATUS	VARCHAR2	(25)		Bid status
BID_STATUS_NAME	VARCHAR2	(80)		No longer used
AWARD_STATUS	VARCHAR2	(25)		Award status
AWARD_STATUS_NAME	VARCHAR2	(80)		No longer used
BID_EFFECTIVE_DATE	DATE			Bid effective date
BID_EXPIRATION_DATE	DATE			Number of days from the Auction Close date on which bid expires
PUBLISH_DATE	DATE			Date on which bid is published
CANCELLED_DATE	DATE			Date on which bid is cancelled
DISQUALIFY_REASON	VARCHAR2	(240)		Disqualify reason given by auctioneer if auctioneer disqualifies bid
FREIGHT_TERMS_CODE	VARCHAR2	(25)		Freight terms code
CARRIER_CODE	VARCHAR2	(25)		Carrier code
FOB_CODE	VARCHAR2	(25)		Free on board code
NOTE_TO_AUCTION_OWNER	VARCHAR2	(4000)		Note to auction owner
ATTACHMENTS_FLAG	VARCHAR2	(1)		Y or N flag to indicate attachments
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
BID_CURRENCY_CODE	VARCHAR2	(15)		Currency code for bid
RATE	NUMBER			Currency conversion rate
RATE_TYPE	VARCHAR2	(25)		Currency conversion rate type
RATE_DATE	DATE			Date of currency conversion rate
MIN_BID_CHANGE	NUMBER			Minimum bid change if proxy bidding is allowed
ORDER_NUMBER	VARCHAR2	(20)		Purchase order number
PO_TXN_FLAG	VARCHAR2	(1)		Y or N flag to indicate whether purchase order transaction was requested by the auctioneer during the auction completion
DOCUMENT_TRACKING_ID	NUMBER			Identifier for purchase order document tracking
PROXY_BID_FLAG	VARCHAR2	(1)		Y or N flag to indicate that proxy bid is allowed
NUMBER_PRICE_DECIMALS	NUMBER			Precision in bid price
PO_AGREED_AMOUNT	NUMBER			Purchase order agreed amount
BID_NUMBER_ORIGINAL_ROUND	NUMBER			Bid Number for this Bidder 's original round
BID_NUMBER_PREV_ROUND	NUMBER			Bid Number for this Bidder's previous round
DOCTYPE_ID	NUMBER			Identifier for document type
BID_REVISION_NUMBER	NUMBER			Bid revision number
ORIGINAL_BID_NUMBER	NUMBER			Original Bid number for this round before revisions
ORIGINAL_REVISION_NUMBER	NUMBER			Original revision number for this round
CANCEL_REASON	VARCHAR2	(240)		Reason for cancelling bid
VENDOR_ID	NUMBER			stores the vendor id of the bidder
VENDOR_SITE_ID	NUMBER			stores vendor site id used to create the po
AGENT_ID	NUMBER			stores the buyer used to create the po
CREATE_SOURCING_RULES	VARCHAR2	(1)		stores if sourcing rules are created or updated when the blanket po is created
UPDATE_SOURCING_RULES	VARCHAR2	(1)		flag needed by po to indicate if the process should update an existing sourcing rule if one is already in place
RELEASE_METHOD	VARCHAR2	(25)		stores the release method for the sourcing rule when the blanket po is created
PO_HEADER_ID	NUMBER			unique identifier for the purchase order that was created from the bid line
PO_WF_CREATION_RND	NUMBER			the workflow round number in which the po is created
PAYMENT_TERMS_ID	NUMBER			primary key of the payment terms
PO_ERROR_CODE	NUMBER			Error Code returned by the PO autocreate API
RATE_DSP	NUMBER			Display value of rate shown to bidders
PO_START_DATE	DATE			Blanket award effective from date
PO_END_DATE	DATE			Blanket award effective to date
INITIATE_APPROVAL	VARCHAR2	(25)		Flag to indicated whether to initiate the PO approval Workflow
PO_ERROR_MSG	VARCHAR2	(2000)		Stores the outcome creation error
DRAFT_LOCKED	VARCHAR2	(1)		Y or N flag to indicate if the draft is locked by a user.
DRAFT_LOCKED_BY	NUMBER			Trading partner id of the lock owner
DRAFT_LOCKED_BY_CONTACT_ID	NUMBER			Trading partner contact id of the lock owner
DRAFT_LOCKED_DATE	DATE			Date and Time when the draft was locked
DRAFT_UNLOCKED_BY	NUMBER			Trading partner id of the person who unlocked
DRAFT_UNLOCKED_BY_CONTACT_ID	NUMBER			Trading partner contact id of the person who unlocked the draft
DRAFT_UNLOCKED_DATE	DATE			Date and Time when the draft was unlocked
VENDOR_SITE_CODE	VARCHAR2	(15)		Stores the vendor_site_code of the supplier.
INTERNAL_NOTE	VARCHAR2	(4000)		Stores a buyer entered internal note for each supplier
SHORTLIST_FLAG	VARCHAR2	(1)		Stores Y if a supplier is on the shortlist, 'N' otherwise
ATTRIBUTE_LINE_NUMBER	NUMBER		Yes	Internal column - Always stores a -1 denoting the line_number for header level attributes
NOTE_TO_SUPPLIER	VARCHAR2	(4000)		Stores the note to supplier entered during the award process
TOTAL_AWARD_AMOUNT	NUMBER			Stores the calculated award amount for the supplier
ACCEPTANCE_REQUIRED_FLAG	VARCHAR2	(1)		Acceptance required indicator used when creating Purchase Documents in Oracle Purchasing
SURROG_BID_CREATED_TP_ID	NUMBER			Company of the buyer user creating the surrogate bid.
SURROG_BID_CREATED_CONTACT_ID	NUMBER			Contact id of the buyer user creating the surrogate bid
SURROG_BID_RECEIPT_DATE	DATE			Timestamp when the buyer received paper details
SURROG_BID_ONLINE_ENTRY_DATE	DATE			Timestamp when the buyer entered the bid on behalf of supplier.
SURROG_BID_FLAG	VARCHAR2	(1)		Y/N flag to indicate if the bid is a surrogate bid entered by the buyer on behalf of a supplier.
COLOR_SEQUENCE_ID	NUMBER			This will contain a running sequence number within a negotiation. It can contain values greater than the number of permitted colors. In the case of a rebid, the sequence is retained. The permitted colors are contained in PON_COLORS.
AWARD_DATE	DATE			Date of award. This will be populated only when the negotiation does not have any lines.
PARTIAL_RESPONSE_FLAG	VARCHAR2	(1)		'Y' if the supplier has bid partial quantities or on partial lines
INCUMBENT_FLAG	VARCHAR2	(1)		Indicates whether the bid came from an incumbent supplier
SCORE_OVERRIDEN_FLAG	VARCHAR2	(1)		Indicates if the team score for this response has been overriden by the negotiation editor. This flag will be set only for auctions enabled for team scoring and after the scores have been locked.
SCORE_OVERRIDEN_DATE	DATE			The date on which the score was overridden.
SCORE_OVERRIDE_TP_CONTACT_ID	NUMBER			Trading partner contact id of the person who last overrode the team scores.
REQUEST_ID	NUMBER			Concurrent request id for bid spreadsheet import or publish bid.
REQUEST_DATE	DATE			Date/Time when concurrent request was submitted for bidding flow.
REQUESTED_BY	NUMBER			The user id of the person who made the concurrent request.
IMPORT_FILE_NAME	VARCHAR2	(255)		The spreadsheet file name that is used for importing.
REL12_DRAFT_FLAG	VARCHAR2	(1)		This flag indicates that this is a draft created after release 12. For drafts from previous releases, since the draft may not be complete, the draft will be expanded on demand.
OLD_NOTE_TO_AUCTION_OWNER	VARCHAR2	(4000)		Note to negotiation owner from source bid.
OLD_BIDDERS_BID_NUMBER	VARCHAR2	(25)		Bidder specified bidder number from source bid
OLD_BID_EXPIRATION_DATE	DATE			Expiration date from source bid.
OLD_BID_STATUS	VARCHAR2	(25)		Bid status from source bid.
OLD_MIN_BID_CHANGE	NUMBER			Minimum bid decrement from source bid.
OLD_SURROG_BID_RECEIPT_DATE	DATE			Surrogate Bid receipt date from source bid
DISPLAY_PRICE_FACTORS_FLAG	VARCHAR2	(1)		Indicates whether this negotiation has applicable price factors
OLD_BID_NUMBER	NUMBER			The bid number where the old values are populated from
BUYER_BID_TOTAL	NUMBER			Bid total in buyer's currency.
SHORTLIST_TPC_ID	NUMBER			Stores the trading_partner_contact_id of the user who changed the shortlist status
CURRENT_TOTAL_SPEND	NUMBER			Stores current spend for this Quote
FIXED_INCENTIVE	NUMBER			Stores the fixed incentive for this Quote
CURRENT_REBATE	NUMBER			Stores the current rebate percentage
HAS_REBATE_TIERS	VARCHAR2	(1)		Indicates whether rebate tiers have been entered
TECHNICAL_SHORTLIST_FLAG	VARCHAR2	(1)		Y/N indicates if the bid has been shortlisted during the technical evaluation or not.
SUBMIT_STAGE	VARCHAR2	(20)		Submit Stage

Query Text

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


SELECT BID_NUMBER
,      AUCTION_HEADER_ID
,      BIDDERS_BID_NUMBER
,      BID_TYPE
,      CONTRACT_TYPE
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      PHONE
,      FAX
,      EMAIL
,      BID_STATUS
,      BID_STATUS_NAME
,      AWARD_STATUS
,      AWARD_STATUS_NAME
,      BID_EFFECTIVE_DATE
,      BID_EXPIRATION_DATE
,      PUBLISH_DATE
,      CANCELLED_DATE
,      DISQUALIFY_REASON
,      FREIGHT_TERMS_CODE
,      CARRIER_CODE
,      FOB_CODE
,      NOTE_TO_AUCTION_OWNER
,      ATTACHMENTS_FLAG
,      LANGUAGE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      AUCTION_CREATION_DATE
,      BID_CURRENCY_CODE
,      RATE
,      RATE_TYPE
,      RATE_DATE
,      MIN_BID_CHANGE
,      ORDER_NUMBER
,      PO_TXN_FLAG
,      DOCUMENT_TRACKING_ID
,      PROXY_BID_FLAG
,      NUMBER_PRICE_DECIMALS
,      PO_AGREED_AMOUNT
,      BID_NUMBER_ORIGINAL_ROUND
,      BID_NUMBER_PREV_ROUND
,      DOCTYPE_ID
,      BID_REVISION_NUMBER
,      ORIGINAL_BID_NUMBER
,      ORIGINAL_REVISION_NUMBER
,      CANCEL_REASON
,      VENDOR_ID
,      VENDOR_SITE_ID
,      AGENT_ID
,      CREATE_SOURCING_RULES
,      UPDATE_SOURCING_RULES
,      RELEASE_METHOD
,      PO_HEADER_ID
,      PO_WF_CREATION_RND
,      PAYMENT_TERMS_ID
,      PO_ERROR_CODE
,      RATE_DSP
,      PO_START_DATE
,      PO_END_DATE
,      INITIATE_APPROVAL
,      PO_ERROR_MSG
,      DRAFT_LOCKED
,      DRAFT_LOCKED_BY
,      DRAFT_LOCKED_BY_CONTACT_ID
,      DRAFT_LOCKED_DATE
,      DRAFT_UNLOCKED_BY
,      DRAFT_UNLOCKED_BY_CONTACT_ID
,      DRAFT_UNLOCKED_DATE
,      VENDOR_SITE_CODE
,      INTERNAL_NOTE
,      SHORTLIST_FLAG
,      ATTRIBUTE_LINE_NUMBER
,      NOTE_TO_SUPPLIER
,      TOTAL_AWARD_AMOUNT
,      ACCEPTANCE_REQUIRED_FLAG
,      SURROG_BID_CREATED_TP_ID
,      SURROG_BID_CREATED_CONTACT_ID
,      SURROG_BID_RECEIPT_DATE
,      SURROG_BID_ONLINE_ENTRY_DATE
,      SURROG_BID_FLAG
,      COLOR_SEQUENCE_ID
,      AWARD_DATE
,      PARTIAL_RESPONSE_FLAG
,      INCUMBENT_FLAG
,      SCORE_OVERRIDEN_FLAG
,      SCORE_OVERRIDEN_DATE
,      SCORE_OVERRIDE_TP_CONTACT_ID
,      REQUEST_ID
,      REQUEST_DATE
,      REQUESTED_BY
,      IMPORT_FILE_NAME
,      REL12_DRAFT_FLAG
,      OLD_NOTE_TO_AUCTION_OWNER
,      OLD_BIDDERS_BID_NUMBER
,      OLD_BID_EXPIRATION_DATE
,      OLD_BID_STATUS
,      OLD_MIN_BID_CHANGE
,      OLD_SURROG_BID_RECEIPT_DATE
,      DISPLAY_PRICE_FACTORS_FLAG
,      OLD_BID_NUMBER
,      BUYER_BID_TOTAL
,      SHORTLIST_TPC_ID
,      CURRENT_TOTAL_SPEND
,      FIXED_INCENTIVE
,      CURRENT_REBATE
,      HAS_REBATE_TIERS
,      TECHNICAL_SHORTLIST_FLAG
,      SUBMIT_STAGE
FROM PON.PON_BID_HEADERS;

Dependencies

[top of page]

PON.PON_BID_HEADERS does not reference any database object

PON.PON_BID_HEADERS is referenced by following:

APPS: PON_BID_HEADERS