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

TABLE: PON.PON_AUCTION_HEADERS_ALL

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


PON_AUCTION_HEADERS stores auctions, RFQs, and RFIs header information. Each row includes general negotiation information such as type, style, business terms and conditions, response controls, et cetera.
The DOCTYPE_ID column indicates whether the transaction is an auction, RFQ, or RFI.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PON_AUCTION_HEADERS_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID
PON_AUCTION_HEADERS_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
PON_AUCTION_HEADERS_ALL_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_TITLE
PON_AUCTION_HEADERS_ALL_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
PON_AUCTION_HEADERS_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID_ORIG_ROUND
ColumnAUCTION_ROUND_NUMBER
PON_AUCTION_HEADERS_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRADING_PARTNER_CONTACT_ID
PON_AUCTION_HEADERS_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAWARD_APPR_AME_TRANS_ID
PON_AUCTION_HEADERS_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUCTION_HEADER_ID_ORIG_AMEND
PON_AUCTION_HEADERS_ALL_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_NUMBER
PON_AUCTION_HEADERS_ALL_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUYER_ID
PON_AUCTION_HEADERS_ALL_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
Columns
Name Datatype Length Mandatory Comments
AUCTION_HEADER_ID NUMBER
Yes System-generated unique Identifier
AUCTION_TITLE VARCHAR2 (80)
Auction title
AUCTION_STATUS VARCHAR2 (25)
Status of auction. Possible values are DRAFT, ACTIVE, CANCELLED
AUCTION_STATUS_NAME VARCHAR2 (80)
No longer used
AWARD_STATUS VARCHAR2 (25)
Award status of auction
AWARD_STATUS_NAME VARCHAR2 (80)
No longer used
AUCTION_TYPE VARCHAR2 (25)
Auction type to denote whether selling(FORWARD) or buying(REVERSE) items
CONTRACT_TYPE VARCHAR2 (25)
Type of contract. Spot buy or Long Term Buy
TRADING_PARTNER_CONTACT_NAME VARCHAR2 (255)
Contact person name for Trading Partner that owns auction
TRADING_PARTNER_CONTACT_ID NUMBER

Unique Identifier for contact person for Trading Partner that owns auction
TRADING_PARTNER_NAME VARCHAR2 (255)
Trading Partner name that owns auction
TRADING_PARTNER_NAME_UPPER VARCHAR2 (255)
Uppercase of Trading Partner that owns auction
TRADING_PARTNER_ID NUMBER

Unique Identifier of Trading Partner that owns auction
SHIP_TO_LOCATION_ID NUMBER

Location Identifier to which auction items will be shipped
BILL_TO_LOCATION_ID NUMBER

Unique Identifier for billing location address
OPEN_BIDDING_DATE DATE

Date that auction is open for bidding
CLOSE_BIDDING_DATE DATE

Current date that auction closes for bidding (Bids will not be accepted from this date onward)
ORIGINAL_CLOSE_BIDDING_DATE DATE

Original date for which auction was setup to close for bidding
VIEW_BY_DATE DATE

Date by which bids can be viewed
AWARD_BY_DATE DATE

Date by which the winning bids are scheduled for awarding by the auctioneer
PUBLISH_DATE DATE

Date auction will be published so that authorized bidders can preview auction details prior to bid commencment.
CLOSE_DATE DATE

Date for auction process being closed
CANCEL_DATE DATE

Date of auction cancellation
TIME_ZONE VARCHAR2 (25)
Not currently used
BID_VISIBILITY_CODE VARCHAR2 (25)
Code specifying who in the system can view the bids. For OPEN_BIDDING the bid are visible to every authorized user, SEALED_AUCTION only the auctioner can view the bids, SEALED_BIDDING neither the auctioneer nor any userr can view the bids until the auctioneer has unsealed the auction.
BID_LIST_TYPE VARCHAR2 (25)
Bid List Type to indicate whether bidders are by invitation only or public bidders
BID_FREQUENCY_CODE VARCHAR2 (25)
Bid Frequency Code to indicate if only one bid per bidder can be entered or multiple bids are only
BID_SCOPE_CODE VARCHAR2 (25)
Code specifying whether bidder can bid on individual items or must bid on all items
AUTO_EXTEND_FLAG VARCHAR2 (1)
Y or N flag to indicate that auction can be automatically extended
AUTO_EXTEND_NUMBER NUMBER

Allowable number of automatic extensions
NUMBER_OF_EXTENSIONS NUMBER

Number of extensions made
NUMBER_OF_BIDS NUMBER

Number of bids received
MIN_BID_DECREMENT NUMBER

Minimum allowable bid decrement in a bidders bid if multiple bids are allowed
PRICE_DRIVEN_AUCTION_FLAG VARCHAR2 (1)
Y or N flag for auction being price-driven
PAYMENT_TERMS_ID NUMBER

Identifier for payment terms
FREIGHT_TERMS_CODE VARCHAR2 (25)
Freight terms code
FOB_CODE VARCHAR2 (25)
Free on board code
CARRIER_CODE VARCHAR2 (25)
Carrier code
CURRENCY_CODE VARCHAR2 (15)
Base Currency code in which the auction will be conducted
RATE_TYPE VARCHAR2 (25)
Currency rate type(CORPORATE,USER)
RATE_DATE DATE

Currency Conversion rate date. Applicable only if the RATE TYPE is CORPORATE.
RATE NUMBER

No longer used
NOTE_TO_BIDDERS VARCHAR2 (4000)
Note to bidders
ATTACHMENT_FLAG VARCHAR2 (1)
Y or N flag to indicate attachments for auction
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
WF_ITEM_KEY VARCHAR2 (240)
Workflow Item Key for the main AUCTION workflow.
WF_ROLE_NAME VARCHAR2 (30)
Workflow Role name created to hold the invited bidders as well as active bidders.
AUTO_EXTEND_ALL_LINES_FLAG VARCHAR2 (1)
Y or N flag to indicate if all auction items are automatically extended if one item qualifies for auto-extension
MIN_BID_INCREMENT NUMBER

Minimum allowable bid increment of a bidders bid if multiple bids are allowed
ALLOW_OTHER_BID_CURRENCY_FLAG VARCHAR2 (1)
Y or N flag to indicate if other bid currencies are allowed
SHIPPING_TERMS_CODE VARCHAR2 (25)
Code for shipping terms
SHIPPING_TERMS VARCHAR2 (80)
No longer used
AUTO_EXTEND_DURATION NUMBER

Duration to be added in each automatic extension of the auction (in minutes)
PROXY_BID_ALLOWED_FLAG VARCHAR2 (1)
Y or N flag to idicate if proxy bids are allowed
PUBLISH_RATES_TO_BIDDERS_FLAG VARCHAR2 (1)
Y or N flag to indicate if currency exchange rates are allowed to be published to bidders
ATTRIBUTES_EXIST VARCHAR2 (20)
Development only flag to indicate existence of item attributes
ORDER_NUMBER VARCHAR2 (20)
Not currently used
DOCUMENT_TRACKING_ID NUMBER

Not currently used
PO_TXN_FLAG VARCHAR2 (1)
Not currently used
EVENT_ID NUMBER

Auction Event Identifier for a group of auctions to be monitored
EVENT_TITLE VARCHAR2 (80)
Title of the event the auction is associated with
SEALED_AUCTION_STATUS VARCHAR2 (30)
Status of sealed auction
SEALED_ACTUAL_UNLOCK_DATE DATE

Date on which sealed auction was unlocked
SEALED_ACTUAL_UNSEAL_DATE DATE

Date on which sealed auction was unsealed
SEALED_UNLOCK_TP_CONTACT_ID NUMBER

Unique Identifier for contact person of trading partner conducting the auction who unlocks the sealed auction
SEALED_UNSEAL_TP_CONTACT_ID NUMBER

Unique identifier for contact person of trading partner conducting the auction who unseals the sealed auction
MODE_OF_TRANSPORT VARCHAR2 (80)
No longer used
MODE_OF_TRANSPORT_CODE VARCHAR2 (25)
Code for mode of transport
PO_START_DATE DATE

Purchase order start date. Applicable only for long term Buyer's auction.
PO_END_DATE DATE

Purchase order end date. Applicable only for long term Buyer's auction.
PO_AGREED_AMOUNT NUMBER

Purchase order agreed amount. Applicable only for long term Buyer's auction.
MIN_BID_CHANGE_TYPE VARCHAR2 (25)
Minimum bid change type
FULL_QUANTITY_BID_CODE VARCHAR2 (25)
Y or N flag to indicate if full quanitty bid are required.
NUMBER_PRICE_DECIMALS NUMBER

Required precision of bid price
AUTO_EXTEND_TYPE_FLAG VARCHAR2 (25)
Flag to denote base date to use to calculate the new auction close time if the autoextend trigger is on for the auction
AUCTION_ORIGINATION_CODE VARCHAR2 (50)
Code for origin of auction
MULTIPLE_ROUNDS_FLAG VARCHAR2 (1)
Y or N flag to indicate if auction can be conducted in multiple rounds.
AUCTION_HEADER_ID_ORIG_ROUND NUMBER

Auction Header Identifier for the Original Round
AUCTION_HEADER_ID_PREV_ROUND NUMBER

Auction Header Identifier for the previous round
AUCTION_ROUND_NUMBER NUMBER

Number of rounds for this auction
MANUAL_CLOSE_FLAG VARCHAR2 (1)
Y or N flag to indicate that auction will be closed manually
MANUAL_EXTEND_FLAG VARCHAR2 (1)
Y or N flag to indicate that auction can be manually extended
AUTOEXTEND_CHANGED_FLAG VARCHAR2 (1)
Y or N flag to indicate that autoextension details are changed by the auctioneer
DOCTYPE_ID NUMBER

Identifier for document type associated with this auction
OFFER_TYPE VARCHAR2 (30)
Type of Offer ( Initial or Commitment)
APPROVAL_REQUIRED_FLAG VARCHAR2 (1)
Y or N flag to indicate if approval is required to submit a counter offer
MAX_RESPONSES NUMBER

Maximum responses allowed
RESPONSE_ALLOWED_FLAG VARCHAR2 (1)
Y or N flag to indicate that offer responses are allowed
FOB_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that free on board is negotiable
CARRIER_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that carrier is negotiable
FREIGHT_TERMS_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that freight terms are negotiable
MAX_RESPONSE_ITERATIONS NUMBER

Maximum number of responses
PAYMENT_TERMS_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that payment terms are negotiable
MODE_OF_TRANSPORT_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that mode of transport is negotiable
CONTRACT_ID NUMBER

Identifier for contract
CONTRACT_VERSION_NUM NUMBER

Version number of contract
SHIPPING_TERMS_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that shipping terms is negotiable
SHIPPING_METHOD_NEG_FLAG VARCHAR2 (1)
Y or N flag to indicate that shipping method is negotiable
USE_REGIONAL_PRICING_FLAG VARCHAR2 (1)
Y or N flag to indicate if regional pricing is used
SHOW_BIDDER_NOTES VARCHAR2 (1)
Flag indicating if bidder notes and attachments are visible to other bidders
DERIVE_TYPE VARCHAR2 (8)
distinguishes the auction currency as EMU if it is EMU derived otherwise, NULL
PRE_DELETE_AUCTION_STATUS VARCHAR2 (25)
storage field for AUCTION_STATUS before changing the auction's status to 'DELETED' (For history purposes)
DRAFT_LOCKED VARCHAR2 (1)
Y or N flag for if negotiation is locked
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 the draft was locked
DRAFT_UNLOCKED_BY NUMBER

trading partner id of the person who unlocked the draft
DRAFT_UNLOCKED_BY_CONTACT_ID NUMBER

trading partner contact id of the person who unlocked the draft
DRAFT_UNLOCKED_DATE DATE

date the draft was unlocked
MAX_LINE_NUMBER NUMBER

The highest/maximum line number of the current round negotiation. This is mainly used for numbering multi-round negotiation items
BID_RANKING VARCHAR2 (25)
Bid evaluation method for this negotiation
RANK_INDICATOR VARCHAR2 (25)
Rank indicator for this negotiation
SHOW_BIDDER_SCORES VARCHAR2 (25)
whether scoring model is show to bidders
OPEN_AUCTION_NOW_FLAG VARCHAR2 (1)
open auction now flag
PUBLISH_AUCTION_NOW_FLAG VARCHAR2 (1)
publish auction now flag
TEMPLATE_ID NUMBER

FK to pom_auction_templates
REMINDER_DATE DATE

reminder date that reminder e-mail should be sent out if invited bidder has not acknowledged partcipation
ORG_ID NUMBER

org_id for multi-org
BUYER_ID NUMBER

Buyer Id from Purchasing Requisitions
MANUAL_EDIT_FLAG VARCHAR2 (1)
'Y' if this draft is manually edited
WF_PONCOMPL_ITEM_KEY VARCHAR2 (240)
Workflow item key for PO creation process
HAS_PE_FOR_ALL_ITEMS VARCHAR2 (30)
Flag to indicate if any item in the negotiation doc has Price Elements defined.
HAS_PRICE_ELEMENTS VARCHAR2 (30)
Flag to indicate if all the items in the negotiation doc has Price Elements defined.
PO_MIN_REL_AMOUNT NUMBER

Blanket Minimum Release Amount
GLOBAL_AGREEMENT_FLAG VARCHAR2 (1)
Global Agreement Flag
OUTCOME_STATUS VARCHAR2 (30)
Status to indicate outcome creation
SOURCE_REQS_FLAG VARCHAR2 (25)
Indicates whether to source requisitions against blanket agreements
AWARD_COMPLETE_DATE DATE

Date the negotiation award process was Completed.
WF_PONCOMPL_CURRENT_ROUND NUMBER

Current Workflow round kicked off to create outcome documents
SECURITY_LEVEL_CODE VARCHAR2 (25)
Security level Code. Values are: PRIVATE/PUBLIC/HIERARCHY
WF_APPROVAL_ITEM_KEY VARCHAR2 (240)
Approval workflow key identifier
APPROVAL_STATUS VARCHAR2 (30)
Approval status of a negotiation. The possible values are : INPROCESS APPROVED REJECTED TIMEOUT REQUIRED NOT_REQUIRED
SOURCE_DOC_ID NUMBER

Source Document Id
SOURCE_DOC_NUMBER VARCHAR2 (20)
Source document number display
SOURCE_DOC_MSG VARCHAR2 (30)
Source doc. display message name
SOURCE_DOC_LINE_MSG VARCHAR2 (30)
Souce doc. line display message name
SOURCE_DOC_MSG_APP VARCHAR2 (3)
Message application short name
SHARE_AWARD_DECISION VARCHAR2 (1)
Share award decision with suppliers?
DESCRIPTION VARCHAR2 (250)
Template description
TEMPLATE_SCOPE VARCHAR2 (25)
Scope of template. Private or Public.
TEMPLATE_STATUS VARCHAR2 (25)
Template status. Active or inactive.
IS_TEMPLATE_FLAG VARCHAR2 (1)
Flag that identifies if the row represents a template or negotiation. The value 'Y' implies this is a template.
AWARD_APPROVAL_FLAG VARCHAR2 (1)
Flag to indicate if award approval is required for this negotiation before the award process can be completed.
AWARD_APPROVAL_STATUS VARCHAR2 (30)
Award Approval Status
AWARD_APPR_AME_TRANS_ID VARCHAR2 (80)
Current AME approval transaction id.
AWARD_APPR_AME_TRANS_PREV_ID VARCHAR2 (80)
Previous AME approval transaction id.
WF_AWARD_APPROVAL_ITEM_KEY VARCHAR2 (240)
Award Approval Workflow Item Key.
AMENDMENT_NUMBER NUMBER

Amendment Number.
AMENDMENT_DESCRIPTION VARCHAR2 (4000)
Amendment description.
AUCTION_HEADER_ID_ORIG_AMEND NUMBER

Auction header id corresponding to the first round for multi round negotiation.
AUCTION_HEADER_ID_PREV_AMEND NUMBER

Previous round auction header id.
DOCUMENT_NUMBER VARCHAR2 (240)
Negotiation number.
AWARD_APPR_AME_TXN_DATE DATE

Date and time at which the Award Approval was initiated.
HDR_ATTR_ENABLE_WEIGHTS VARCHAR2 (1)
Denotes whether weights are enabled on Header Attributes
HDR_ATTR_DISPLAY_SCORE VARCHAR2 (1)
Denotes whether to show header attribute scoring criteria to suppliers
HDR_ATTR_MAXIMUM_SCORE NUMBER

Stores the default maximum score on the header attributes
ATTRIBUTE_LINE_NUMBER NUMBER
Yes Internal column - will always store a value of -1 to denote the line number for header attributes
CONTERMS_EXIST_FLAG VARCHAR2 (1)
Indicates if the negotiation has contract terms
CONTERMS_ARTICLES_UPD_DATE DATE

Last update date for the negotiation's contract articles
CONTERMS_DELIV_UPD_DATE DATE

Last update date for the negotiation's contract deliverables
AWARD_MODE VARCHAR2 (30)
Stores the mode in which the last award was saved
HAS_HDR_ATTR_FLAG VARCHAR2 (1)
Flag that denotes whether any header attributes exists for this negotiation
AWARD_DATE DATE

Date the latest Award was saved
MAX_INTERNAL_LINE_NUM NUMBER

Holds the maximum line number for this negotiation.
MAX_BID_COLOR_SEQUENCE_ID NUMBER

Maximum color sequence number allotted to the responses for this negotiation. For negotiations created before this column existed, the value will be upgraded to -1. When the user tries to view the live console for the negotiation, the value will be recalculated and populated. For new negotiations, the value is initially 0.
HAS_ITEMS_FLAG VARCHAR2 (1)
Flag that indicates if there are any line items for this negotiation. This flag is set to 'Y' for templates.
INT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Not currently used
INT_ATTRIBUTE1 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE2 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE3 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE4 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE5 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE6 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE7 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE8 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE9 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE10 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE11 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE12 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE13 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE14 VARCHAR2 (150)
Not currently used
INT_ATTRIBUTE15 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Not currently used
EXT_ATTRIBUTE1 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE2 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE3 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE4 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE5 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE6 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE7 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE8 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE9 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE10 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE11 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE12 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE13 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE14 VARCHAR2 (150)
Not currently used
EXT_ATTRIBUTE15 VARCHAR2 (150)
Not currently used
INCLUDE_PDF_IN_EXTERNAL_PAGE VARCHAR2 (1)
Whether to Include Pdf In External Page?
ABSTRACT_DETAILS VARCHAR2 (4000)
Abstract Details
ABSTRACT_STATUS VARCHAR2 (20)
Abstract Status
PF_TYPE_ALLOWED VARCHAR2 (30)
Indicates the combination of buyer/supplier price factors. Stored as lookup values.
SUPPLIER_VIEW_TYPE VARCHAR2 (30)
Indicates whether suppliers will see their quotes transformed. Stored as lookup values.
IS_PAUSED VARCHAR2 (1)
Indicates whether the negotiation is Paused or not.
PAUSE_REMARKS VARCHAR2 (2000)
Reason for which the Negotiation is paused.
LAST_PAUSE_DATE DATE

Date on which the negotiation is paused.
MAX_DOCUMENT_LINE_NUM NUMBER

Maximun document line number that is displayed to users for this negotiation
PROGRESS_PAYMENT_TYPE VARCHAR2 (10)
Indicates whether the negotiation is used for complex services and the type. 'NONE' indicates that the negotiation is not used for complex services, 'FINANCE' indicates financing will be provided and 'ACTUAL' indicates that payments will be made against actuals
ADVANCE_NEGOTIABLE_FLAG VARCHAR2 (1)
Indicates whether the Supplier can negotiate the amount of advance on a line
RECOUPMENT_NEGOTIABLE_FLAG VARCHAR2 (1)
Indicates whether the recoupment rate on the line is negotiable
PROGRESS_PYMT_NEGOTIABLE_FLAG VARCHAR2 (1)
Indicates whether the progress payment rate is negotiable
RETAINAGE_NEGOTIABLE_FLAG VARCHAR2 (1)
Indicates whether the retainage rate on the line is negotiable
MAX_RETAINAGE_NEGOTIABLE_FLAG VARCHAR2 (1)
Indicates whether the maximum retainage amount on the line is negotiable
SUPPLIER_ENTERABLE_PYMT_FLAG VARCHAR2 (1)
Indicates whether the supplier is allowed to create or modify pay items on negotiations with complex services. If not, the supplier can only respond to the pay items as proposed by the buyer
PROJECT_ID NUMBER

Unique identifier of the project in Oracle Projects which governs the negotiation
TEAM_SCORING_ENABLED_FLAG VARCHAR2 (1)
Indicates if the style applied to this negotiation has team scoring enabled. The team scoring portion will be shown in the negotiation creation and review screens only if this flag is set.
HAS_SCORING_TEAMS_FLAG VARCHAR2 (1)
Indicates if this negotiation has been enabled for Team Scoring. 'Y' indicates negotiation is enabled and is set such when editor creates scoring teams for this negotiation. The flag will be set to NULL or 'N' when team scoring is not enabled for this negotiation.
SCORING_LOCK_DATE DATE

Date on which this negotiation was closed for team scoring. Beyond this date a scorer will not be able to enter scores to evaluate the responses unless scoring is unlocked. An editor may manually lock the scores or implicitly do so when the negotiation is submitted for award approval or the award is completed.
SCORING_LOCK_TP_CONTACT_ID NUMBER

Identifier of the trading partner contact who locked down team scoring
REQUEST_ID NUMBER

Concurrent request id for creation flow/award flow - used to store the request id when import items/awards are in progress or when auction is published.
REQUEST_DATE DATE

Date/time when concurrent request was submitted for creation/award 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.
NUMBER_OF_LINES NUMBER

Number of lines in the negotiation.
LAST_LINE_NUMBER NUMBER

Maximum line, lot, or group number in the negotiation.
STYLE_ID NUMBER

Style id
LINE_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if the attribute is enabled.
LINE_MAS_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if MAS is enabled.
PRICE_ELEMENT_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if price element is enabled.
RFI_LINE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if line is enabled, applicable to RFI.
LOT_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if lot is enabled.
GROUP_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if group is enabled.
LARGE_NEG_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if large negotiation is enabled.
HDR_ATTRIBUTE_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if header attribute is enabled.
NEG_TEAM_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if collaboration team is enabled.
PROXY_BIDDING_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if proxy bidding is enabled.
POWER_BIDDING_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if power bidding is enabled.
AUTO_EXTEND_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if auto-extension is enabled.
PO_STYLE_ID NUMBER

Part of the unique key of PO style for the negotiation. The other part, PO document type, is stored in contract_type.
PRICE_BREAK_RESPONSE VARCHAR2 (25)
Default price break setting for a blanket. Possbile values are : NONE, OPTIONAL, or REQUIRED. This column is not applicable to templates.
GLOBAL_TEMPLATE_FLAG VARCHAR2 (1)
Stores whether the template is global or not
CONTRACT_TEMPLATE_ID NUMBER

Contract template id for the template row
COMPLETE_FLAG VARCHAR2 (1)
Indicates whether all batches finish successfully
BID_DECREMENT_METHOD VARCHAR2 (15)
Indicates the method used for bid decrement for open auctions. 'BEST_PRICE' indicates bid should be decremented based on best response price. 'PREVIOUS_PRICE' indicates bid should be decremented based on suppliers previous active response.
DISPLAY_BEST_PRICE_BLIND_FLAG VARCHAR2 (1)
This column specifies whether the best price on blind negotiations can be displayed to suppliers.
FIRST_LINE_CLOSE_DATE DATE

Date at which the first line is schedueld to close in a staggered closing scenerio.
STAGGERED_CLOSING_INTERVAL NUMBER

Staggered line closing interval.
ENFORCE_PREVRND_BID_PRICE_FLAG VARCHAR2 (1)
When this flag is set, each supplier user sees his previous active bid's quoted price as the start price of each line. This flag can only be set by the buyer when creating a new round. It cannot be set for the first round. For example, if the start price of a line is $100 in the first round, the supplier bids $95 and this control is set in the second round, then the supplier will see a start price of $95 for this line in the second round.
PRICE_TIERS_INDICATOR VARCHAR2 (30)
Stores NONE, PRICE_BREAKS or QUANTITY_TIERS
AUTO_EXTEND_MIN_TRIGGER_RANK NUMBER

The minimum rank that will trigger auto extension. Null means any bid.
QTY_PRICE_TIERS_ENABLED_FLAG VARCHAR2 (1)
Y/N flag to indicate if quantity based price tiers is enabled.
TWO_PART_FLAG VARCHAR2 (1)
Y/N to indicate if this is a two-part RFQ
TECHNICAL_LOCK_STATUS VARCHAR2 (20)
Used to store the technical part's lock status for a 2part RFQ.
TECHNICAL_EVALUATION_STATUS VARCHAR2 (20)
Stores the technical evaluation completion status.
TECHNICAL_ACTUAL_UNLOCK_DATE DATE

Date when the technical unlock was done
TECHNICAL_ACTUAL_UNSEAL_DATE DATE

Date when the technical unseal was done.
TECHNICAL_UNLOCK_TP_CONTACT_ID NUMBER

Trading Partner contact id of the person who unlocked the technical part of the RFQ.
TECHNICAL_UNSEAL_TP_CONTACT_ID NUMBER

Trading Partner Contact Id of the person who unsealed the technical part of the RFQ.
Query Text

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


SELECT AUCTION_HEADER_ID
,      AUCTION_TITLE
,      AUCTION_STATUS
,      AUCTION_STATUS_NAME
,      AWARD_STATUS
,      AWARD_STATUS_NAME
,      AUCTION_TYPE
,      CONTRACT_TYPE
,      TRADING_PARTNER_CONTACT_NAME
,      TRADING_PARTNER_CONTACT_ID
,      TRADING_PARTNER_NAME
,      TRADING_PARTNER_NAME_UPPER
,      TRADING_PARTNER_ID
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      OPEN_BIDDING_DATE
,      CLOSE_BIDDING_DATE
,      ORIGINAL_CLOSE_BIDDING_DATE
,      VIEW_BY_DATE
,      AWARD_BY_DATE
,      PUBLISH_DATE
,      CLOSE_DATE
,      CANCEL_DATE
,      TIME_ZONE
,      BID_VISIBILITY_CODE
,      BID_LIST_TYPE
,      BID_FREQUENCY_CODE
,      BID_SCOPE_CODE
,      AUTO_EXTEND_FLAG
,      AUTO_EXTEND_NUMBER
,      NUMBER_OF_EXTENSIONS
,      NUMBER_OF_BIDS
,      MIN_BID_DECREMENT
,      PRICE_DRIVEN_AUCTION_FLAG
,      PAYMENT_TERMS_ID
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      CARRIER_CODE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      NOTE_TO_BIDDERS
,      ATTACHMENT_FLAG
,      LANGUAGE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      WF_ITEM_KEY
,      WF_ROLE_NAME
,      AUTO_EXTEND_ALL_LINES_FLAG
,      MIN_BID_INCREMENT
,      ALLOW_OTHER_BID_CURRENCY_FLAG
,      SHIPPING_TERMS_CODE
,      SHIPPING_TERMS
,      AUTO_EXTEND_DURATION
,      PROXY_BID_ALLOWED_FLAG
,      PUBLISH_RATES_TO_BIDDERS_FLAG
,      ATTRIBUTES_EXIST
,      ORDER_NUMBER
,      DOCUMENT_TRACKING_ID
,      PO_TXN_FLAG
,      EVENT_ID
,      EVENT_TITLE
,      SEALED_AUCTION_STATUS
,      SEALED_ACTUAL_UNLOCK_DATE
,      SEALED_ACTUAL_UNSEAL_DATE
,      SEALED_UNLOCK_TP_CONTACT_ID
,      SEALED_UNSEAL_TP_CONTACT_ID
,      MODE_OF_TRANSPORT
,      MODE_OF_TRANSPORT_CODE
,      PO_START_DATE
,      PO_END_DATE
,      PO_AGREED_AMOUNT
,      MIN_BID_CHANGE_TYPE
,      FULL_QUANTITY_BID_CODE
,      NUMBER_PRICE_DECIMALS
,      AUTO_EXTEND_TYPE_FLAG
,      AUCTION_ORIGINATION_CODE
,      MULTIPLE_ROUNDS_FLAG
,      AUCTION_HEADER_ID_ORIG_ROUND
,      AUCTION_HEADER_ID_PREV_ROUND
,      AUCTION_ROUND_NUMBER
,      MANUAL_CLOSE_FLAG
,      MANUAL_EXTEND_FLAG
,      AUTOEXTEND_CHANGED_FLAG
,      DOCTYPE_ID
,      OFFER_TYPE
,      APPROVAL_REQUIRED_FLAG
,      MAX_RESPONSES
,      RESPONSE_ALLOWED_FLAG
,      FOB_NEG_FLAG
,      CARRIER_NEG_FLAG
,      FREIGHT_TERMS_NEG_FLAG
,      MAX_RESPONSE_ITERATIONS
,      PAYMENT_TERMS_NEG_FLAG
,      MODE_OF_TRANSPORT_NEG_FLAG
,      CONTRACT_ID
,      CONTRACT_VERSION_NUM
,      SHIPPING_TERMS_NEG_FLAG
,      SHIPPING_METHOD_NEG_FLAG
,      USE_REGIONAL_PRICING_FLAG
,      SHOW_BIDDER_NOTES
,      DERIVE_TYPE
,      PRE_DELETE_AUCTION_STATUS
,      DRAFT_LOCKED
,      DRAFT_LOCKED_BY
,      DRAFT_LOCKED_BY_CONTACT_ID
,      DRAFT_LOCKED_DATE
,      DRAFT_UNLOCKED_BY
,      DRAFT_UNLOCKED_BY_CONTACT_ID
,      DRAFT_UNLOCKED_DATE
,      MAX_LINE_NUMBER
,      BID_RANKING
,      RANK_INDICATOR
,      SHOW_BIDDER_SCORES
,      OPEN_AUCTION_NOW_FLAG
,      PUBLISH_AUCTION_NOW_FLAG
,      TEMPLATE_ID
,      REMINDER_DATE
,      ORG_ID
,      BUYER_ID
,      MANUAL_EDIT_FLAG
,      WF_PONCOMPL_ITEM_KEY
,      HAS_PE_FOR_ALL_ITEMS
,      HAS_PRICE_ELEMENTS
,      PO_MIN_REL_AMOUNT
,      GLOBAL_AGREEMENT_FLAG
,      OUTCOME_STATUS
,      SOURCE_REQS_FLAG
,      AWARD_COMPLETE_DATE
,      WF_PONCOMPL_CURRENT_ROUND
,      SECURITY_LEVEL_CODE
,      WF_APPROVAL_ITEM_KEY
,      APPROVAL_STATUS
,      SOURCE_DOC_ID
,      SOURCE_DOC_NUMBER
,      SOURCE_DOC_MSG
,      SOURCE_DOC_LINE_MSG
,      SOURCE_DOC_MSG_APP
,      SHARE_AWARD_DECISION
,      DESCRIPTION
,      TEMPLATE_SCOPE
,      TEMPLATE_STATUS
,      IS_TEMPLATE_FLAG
,      AWARD_APPROVAL_FLAG
,      AWARD_APPROVAL_STATUS
,      AWARD_APPR_AME_TRANS_ID
,      AWARD_APPR_AME_TRANS_PREV_ID
,      WF_AWARD_APPROVAL_ITEM_KEY
,      AMENDMENT_NUMBER
,      AMENDMENT_DESCRIPTION
,      AUCTION_HEADER_ID_ORIG_AMEND
,      AUCTION_HEADER_ID_PREV_AMEND
,      DOCUMENT_NUMBER
,      AWARD_APPR_AME_TXN_DATE
,      HDR_ATTR_ENABLE_WEIGHTS
,      HDR_ATTR_DISPLAY_SCORE
,      HDR_ATTR_MAXIMUM_SCORE
,      ATTRIBUTE_LINE_NUMBER
,      CONTERMS_EXIST_FLAG
,      CONTERMS_ARTICLES_UPD_DATE
,      CONTERMS_DELIV_UPD_DATE
,      AWARD_MODE
,      HAS_HDR_ATTR_FLAG
,      AWARD_DATE
,      MAX_INTERNAL_LINE_NUM
,      MAX_BID_COLOR_SEQUENCE_ID
,      HAS_ITEMS_FLAG
,      INT_ATTRIBUTE_CATEGORY
,      INT_ATTRIBUTE1
,      INT_ATTRIBUTE2
,      INT_ATTRIBUTE3
,      INT_ATTRIBUTE4
,      INT_ATTRIBUTE5
,      INT_ATTRIBUTE6
,      INT_ATTRIBUTE7
,      INT_ATTRIBUTE8
,      INT_ATTRIBUTE9
,      INT_ATTRIBUTE10
,      INT_ATTRIBUTE11
,      INT_ATTRIBUTE12
,      INT_ATTRIBUTE13
,      INT_ATTRIBUTE14
,      INT_ATTRIBUTE15
,      EXT_ATTRIBUTE_CATEGORY
,      EXT_ATTRIBUTE1
,      EXT_ATTRIBUTE2
,      EXT_ATTRIBUTE3
,      EXT_ATTRIBUTE4
,      EXT_ATTRIBUTE5
,      EXT_ATTRIBUTE6
,      EXT_ATTRIBUTE7
,      EXT_ATTRIBUTE8
,      EXT_ATTRIBUTE9
,      EXT_ATTRIBUTE10
,      EXT_ATTRIBUTE11
,      EXT_ATTRIBUTE12
,      EXT_ATTRIBUTE13
,      EXT_ATTRIBUTE14
,      EXT_ATTRIBUTE15
,      INCLUDE_PDF_IN_EXTERNAL_PAGE
,      ABSTRACT_DETAILS
,      ABSTRACT_STATUS
,      PF_TYPE_ALLOWED
,      SUPPLIER_VIEW_TYPE
,      IS_PAUSED
,      PAUSE_REMARKS
,      LAST_PAUSE_DATE
,      MAX_DOCUMENT_LINE_NUM
,      PROGRESS_PAYMENT_TYPE
,      ADVANCE_NEGOTIABLE_FLAG
,      RECOUPMENT_NEGOTIABLE_FLAG
,      PROGRESS_PYMT_NEGOTIABLE_FLAG
,      RETAINAGE_NEGOTIABLE_FLAG
,      MAX_RETAINAGE_NEGOTIABLE_FLAG
,      SUPPLIER_ENTERABLE_PYMT_FLAG
,      PROJECT_ID
,      TEAM_SCORING_ENABLED_FLAG
,      HAS_SCORING_TEAMS_FLAG
,      SCORING_LOCK_DATE
,      SCORING_LOCK_TP_CONTACT_ID
,      REQUEST_ID
,      REQUEST_DATE
,      REQUESTED_BY
,      IMPORT_FILE_NAME
,      NUMBER_OF_LINES
,      LAST_LINE_NUMBER
,      STYLE_ID
,      LINE_ATTRIBUTE_ENABLED_FLAG
,      LINE_MAS_ENABLED_FLAG
,      PRICE_ELEMENT_ENABLED_FLAG
,      RFI_LINE_ENABLED_FLAG
,      LOT_ENABLED_FLAG
,      GROUP_ENABLED_FLAG
,      LARGE_NEG_ENABLED_FLAG
,      HDR_ATTRIBUTE_ENABLED_FLAG
,      NEG_TEAM_ENABLED_FLAG
,      PROXY_BIDDING_ENABLED_FLAG
,      POWER_BIDDING_ENABLED_FLAG
,      AUTO_EXTEND_ENABLED_FLAG
,      PO_STYLE_ID
,      PRICE_BREAK_RESPONSE
,      GLOBAL_TEMPLATE_FLAG
,      CONTRACT_TEMPLATE_ID
,      COMPLETE_FLAG
,      BID_DECREMENT_METHOD
,      DISPLAY_BEST_PRICE_BLIND_FLAG
,      FIRST_LINE_CLOSE_DATE
,      STAGGERED_CLOSING_INTERVAL
,      ENFORCE_PREVRND_BID_PRICE_FLAG
,      PRICE_TIERS_INDICATOR
,      AUTO_EXTEND_MIN_TRIGGER_RANK
,      QTY_PRICE_TIERS_ENABLED_FLAG
,      TWO_PART_FLAG
,      TECHNICAL_LOCK_STATUS
,      TECHNICAL_EVALUATION_STATUS
,      TECHNICAL_ACTUAL_UNLOCK_DATE
,      TECHNICAL_ACTUAL_UNSEAL_DATE
,      TECHNICAL_UNLOCK_TP_CONTACT_ID
,      TECHNICAL_UNSEAL_TP_CONTACT_ID
FROM PON.PON_AUCTION_HEADERS_ALL;

Dependencies

[top of page]

PON.PON_AUCTION_HEADERS_ALL does not reference any database object

PON.PON_AUCTION_HEADERS_ALL is referenced by following:

SchemaAPPS
SynonymPON_AUCTION_HEADERS
SynonymPON_AUCTION_HEADERS_ALL