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

TABLE: PON.PON_BID_HEADERS_ARCH

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


no longer used.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_BID_HEADERS_ARCH_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnAUCTION_HEADER_ID
ColumnBID_NUMBER
ColumnBID_REVISION_NUMBER
Columns
Name Datatype Length Mandatory Comments
LATEST_EXTERNAL_FLAG VARCHAR2 (1) Yes Y or N flag to indicate if this is the latest archived row
AUCTION_HEADER_ID NUMBER
Yes Auction Header Identifier
BID_NUMBER NUMBER
Yes Bid Number
BID_REVISION_NUMBER NUMBER
Yes Bid revision number
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)
Name of contact person for bidder trading partner
TRADING_PARTNER_CONTACT_ID NUMBER

Identifier for contact person of bidder trading partner
TRADING_PARTNER_NAME VARCHAR2 (255)
Name of bidder trading partner
TRADING_PARTNER_ID NUMBER

Identifier for bidder trading partner
BID_STATUS VARCHAR2 (25)
Bid status
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
PAYMENT_TERMS_ID NUMBER

Unique Identifier for payment terms
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
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
ATTACHMENTS_FLAG VARCHAR2 (1)
Y or N flag to indicate attachments
DISQUALIFY_REASON VARCHAR2 (240)
Disqualify reason given by auctioneer if auctioneer disqualifies bid
PAYMENT_TERMS VARCHAR2 (80)
No longer used
FREIGHT_TERMS VARCHAR2 (80)
No longer used
CARRIER VARCHAR2 (80)
No longer used
FOB VARCHAR2 (80)
No longer used
BID_STATUS_NAME VARCHAR2 (80)
No longer used
LANGUAGE_CODE VARCHAR2 (4)
No longer used
AWARD_STATUS VARCHAR2 (25)
Award status
AWARD_STATUS_NAME VARCHAR2 (80)
No longer used
PAYMENT_TERMS_CODE VARCHAR2 (80)
Payment terms code
PHONE VARCHAR2 (100)
Phone number
FAX VARCHAR2 (100)
Fax number
EMAIL VARCHAR2 (100)
Email address
BID_CURRENCY_CODE VARCHAR2 (15)
Currency code of 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
ORIGINAL_BID_NUMBER NUMBER

Original Bid number for this round before revisions
ORIGINAL_REVISION_NUMBER NUMBER

Original revision number for this round
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
CANCEL_REASON VARCHAR2 (240)
Reason for cancelling bid
MODE_OF_TRANSPORT_CODE VARCHAR2 (25)
Code for mode of transport
VENDOR_ID NUMBER

Vendor id of the bidder
VENDOR_SITE_ID NUMBER

Vendor Site id used to create the PO
UPDATE_SOURCING_RULES VARCHAR2 (1)
'Y' if existing sourcing rule should be updated
AGENT_ID NUMBER

Buyer used to create the PO
CREATE_SOURCING_RULES VARCHAR2 (1)
'Y' if sourcing rules should be created
RELEASE_METHOD VARCHAR2 (25)
Release Method for sourcing rule
PO_HEADER_ID NUMBER

unique identifier for the PO that was created for this bid
PO_ERROR_CODE NUMBER

stores any error which occurs during PO genreation
PO_WF_CREATION_RND NUMBER

Workflow round number in which the PO is created
RATE_DSP NUMBER

Display value of rate shown to bidders.
Query Text

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


SELECT LATEST_EXTERNAL_FLAG
,      AUCTION_HEADER_ID
,      BID_NUMBER
,      BID_REVISION_NUMBER
,      BIDDERS_BID_NUMBER
,      BID_TYPE
,      CONTRACT_TYPE
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_ID
,      BID_STATUS
,      BID_EFFECTIVE_DATE
,      BID_EXPIRATION_DATE
,      PUBLISH_DATE
,      CANCELLED_DATE
,      PAYMENT_TERMS_ID
,      FREIGHT_TERMS_CODE
,      CARRIER_CODE
,      FOB_CODE
,      NOTE_TO_AUCTION_OWNER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      AUCTION_CREATION_DATE
,      ATTACHMENTS_FLAG
,      DISQUALIFY_REASON
,      PAYMENT_TERMS
,      FREIGHT_TERMS
,      CARRIER
,      FOB
,      BID_STATUS_NAME
,      LANGUAGE_CODE
,      AWARD_STATUS
,      AWARD_STATUS_NAME
,      PAYMENT_TERMS_CODE
,      PHONE
,      FAX
,      EMAIL
,      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
,      ORIGINAL_BID_NUMBER
,      ORIGINAL_REVISION_NUMBER
,      BID_NUMBER_ORIGINAL_ROUND
,      BID_NUMBER_PREV_ROUND
,      DOCTYPE_ID
,      CANCEL_REASON
,      MODE_OF_TRANSPORT_CODE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      UPDATE_SOURCING_RULES
,      AGENT_ID
,      CREATE_SOURCING_RULES
,      RELEASE_METHOD
,      PO_HEADER_ID
,      PO_ERROR_CODE
,      PO_WF_CREATION_RND
,      RATE_DSP
FROM PON.PON_BID_HEADERS_ARCH;

Dependencies

[top of page]

PON.PON_BID_HEADERS_ARCH does not reference any database object

PON.PON_BID_HEADERS_ARCH is referenced by following:

SchemaAPPS
SynonymPON_BID_HEADERS_ARCH