[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_HEADERS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PON |
| FND Design Data: |  PON.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PON_AUCTION_HEADERS_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 AUCTION_HEADER_ID
|
| SYS_IL0000202949C00301$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| PON_AUCTION_HEADERS_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EVENT_ID
|
| PON_AUCTION_HEADERS_ALL_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUCTION_TITLE
|
| PON_AUCTION_HEADERS_ALL_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_UPDATE_DATE
|
| PON_AUCTION_HEADERS_ALL_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UDA_TEMPLATE_ID
|
| PON_AUCTION_HEADERS_ALL_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUCTION_HEADER_ID_ORIG_ROUND
AUCTION_ROUND_NUMBER
|
| PON_AUCTION_HEADERS_ALL_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRADING_PARTNER_CONTACT_ID
|
| PON_AUCTION_HEADERS_ALL_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AWARD_APPR_AME_TRANS_ID
|
| PON_AUCTION_HEADERS_ALL_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AUCTION_HEADER_ID_ORIG_AMEND
|
| PON_AUCTION_HEADERS_ALL_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOCUMENT_NUMBER
|
| PON_AUCTION_HEADERS_ALL_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUYER_ID
|
| PON_AUCTION_HEADERS_ALL_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
|
| 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 | ||
| 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. | ||
| NO_OF_NOTIFICATIONS_SENT | NUMBER | Number of notifications sent | ||
| EMD_ENABLE_FLAG | VARCHAR2 | (1) | Indicates if EMD is enabled for a negotiation | |
| EMD_AMOUNT | NUMBER | EMD amount to be paid | ||
| EMD_DUE_DATE | DATE | EMD Due date | ||
| EMD_TYPE | VARCHAR2 | (30) | Indicates whether Direct payment or Band Guarantee | |
| EMD_GUARANTEE_EXPIRY_DATE | NUMBER | Bank guarantee expiry date | ||
| EMD_ADDITIONAL_INFORMATION | VARCHAR2 | (2000) | EMD additional information | |
| POST_EMD_TO_FINANCE | VARCHAR2 | (1) | Indicates whether financial integration is enabled for the operating unit | |
| NEGOTIATION_REQUESTER_ID | NUMBER | |||
| SUPP_REG_QUAL_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| SUPP_EVAL_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| HIDE_TERMS_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| HIDE_ABSTRACT_FORMS_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| HIDE_ATTACHMENTS_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTERNAL_EVAL_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| HDR_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTGR_HDR_ATTR_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTGR_HDR_ATTACH_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| LINE_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| ITEM_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTGR_CAT_LINE_ATTR_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTGR_ITEM_LINE_ATTR_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTGR_CAT_LINE_ASL_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| INTERNAL_ONLY_FLAG | VARCHAR2 | (1) | Supplier Management project: configuration flag. | |
| SYNC_STATUS | VARCHAR2 | (25) | ||
| REVISION | NUMBER | Revision number for CLM amendments | ||
| AMENDMENT_FLAG | VARCHAR2 | (1) | Indicates whether the current amendment is conformed | |
| CANCEL_AMENDMENT | VARCHAR2 | (1) | Indicates whether this is cancel amendment | |
| EFFECTIVE_DATE | DATE | Effective date for amendment | ||
| SIGNED_DATE | DATE | Signed date for amendment | ||
| UDA_TEMPLATE_ID | NUMBER | Uda Template Id | ||
| UDA_TEMPLATE_DATE | DATE | Uda Template Date | ||
| SOLICITATION_TYPE | VARCHAR2 | (10) | CLM Solicitation type | |
| NO_OF_COPIES | NUMBER | No Of Copies | ||
| CD_GENERATED_DATE | DATE | Date of generation of system generated description | ||
| CD_EDITBYUSER_FLAG | VARCHAR2 | (1) | Indicates if user has edited system generated description | |
| CD_GENERATED_FLAG | VARCHAR2 | (1) | Indicates if change description is generated | |
| AMENDUPDATED_AFTERCDGENERATED | VARCHAR2 | (1) | Indicates if document updated after system description generation | |
| CHANGEDESCRIPTION_DATA | CLOB | (4000) | Change description data | |
| CONCURRENT_REQID | VARCHAR2 | (20) | Concurrent request ID for system generated description | |
| STANDARD_FORM | VARCHAR2 | (240) | Standard Form for Printing Formats | |
| DOCUMENT_FORMAT | VARCHAR2 | (240) | Document Format for Printing Formats | |
| FEDERAL_PUBLICATION_EXCEPTION | VARCHAR2 | (30) | Exception reason for not publishing a federal document to FedBizOpps site | |
| UMBRELLA_PROGRAM_ID | NUMBER | Stores Umbrella Program ID for Award(FON) and IDV(Solicitation) | ||
| FAIR_OPP_NOTICE_FLAG | VARCHAR2 | (1) | Update the column with 'Y', if the document is a Fair Opportunity Notice | |
| ALLOW_WITHDRAW_FLAG | VARCHAR2 | (1) | update the column with Y if withdrawal is allowed | |
| ALLOW_UNSOL_OFFER_LINES | VARCHAR2 | (1) | Update the column with Y if unsolicited lines are allowed on offer | |
| ALLOW_MULTIPLE_ACTIVE_OFFERS | VARCHAR2 | (1) | Update this column to 'Y' if multiple active responses are enabled for this negotiation. | |
| FREIGHT_TERMS_CODE#1 | VARCHAR2 | (30) | Freight Terms Code | |
| ALLOW_STAGGERED_AWARDS | VARCHAR2 | (1) | Stores Y if staggered awarding is enabled |
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
, 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
, NO_OF_NOTIFICATIONS_SENT
, EMD_ENABLE_FLAG
, EMD_AMOUNT
, EMD_DUE_DATE
, EMD_TYPE
, EMD_GUARANTEE_EXPIRY_DATE
, EMD_ADDITIONAL_INFORMATION
, POST_EMD_TO_FINANCE
, NEGOTIATION_REQUESTER_ID
, SUPP_REG_QUAL_FLAG
, SUPP_EVAL_FLAG
, HIDE_TERMS_FLAG
, HIDE_ABSTRACT_FORMS_FLAG
, HIDE_ATTACHMENTS_FLAG
, INTERNAL_EVAL_FLAG
, HDR_SUPP_ATTR_ENABLED_FLAG
, INTGR_HDR_ATTR_FLAG
, INTGR_HDR_ATTACH_FLAG
, LINE_SUPP_ATTR_ENABLED_FLAG
, ITEM_SUPP_ATTR_ENABLED_FLAG
, INTGR_CAT_LINE_ATTR_FLAG
, INTGR_ITEM_LINE_ATTR_FLAG
, INTGR_CAT_LINE_ASL_FLAG
, INTERNAL_ONLY_FLAG
, SYNC_STATUS
, REVISION
, AMENDMENT_FLAG
, CANCEL_AMENDMENT
, EFFECTIVE_DATE
, SIGNED_DATE
, UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE
, SOLICITATION_TYPE
, NO_OF_COPIES
, CD_GENERATED_DATE
, CD_EDITBYUSER_FLAG
, CD_GENERATED_FLAG
, AMENDUPDATED_AFTERCDGENERATED
, CHANGEDESCRIPTION_DATA
, CONCURRENT_REQID
, STANDARD_FORM
, DOCUMENT_FORMAT
, FEDERAL_PUBLICATION_EXCEPTION
, UMBRELLA_PROGRAM_ID
, FAIR_OPP_NOTICE_FLAG
, ALLOW_WITHDRAW_FLAG
, ALLOW_UNSOL_OFFER_LINES
, ALLOW_MULTIPLE_ACTIVE_OFFERS
, FREIGHT_TERMS_CODE#1
, ALLOW_STAGGERED_AWARDS
FROM PON.PON_AUCTION_HEADERS_ALL;
PON.PON_AUCTION_HEADERS_ALL does not reference any database object
PON.PON_AUCTION_HEADERS_ALL is referenced by following:
PON
PON_AUCTION_HEADERS_ALL#
|
|
|
|