[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_HEADERS_ALL_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PON.PON_AUCTION_HEADERS_ALL_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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).For paused negotiations this date is a tentative close bidding date. | ||
| 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 authorised 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 autorized exchange member, SEALED_AUCTION only the auctioner can view the bids, SEALED_BIDDING neither the auctioner nor any excahgne member 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 | (30) | 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 | |
| AUCTION_SORTCOL | NUMBER | Column derived to be able to sort on the displayed document number | ||
| CREATED_BY_FULL_NAME | VARCHAR2 | (4000) | Displayed Full Name of the Negotation creator | |
| ORGANIZATION_NAME | VARCHAR2 | (240) | ||
| DOCUMENT_NUMBER | VARCHAR2 | (240) | Displayed document number | |
| NEGOTIATION_STATUS | VARCHAR2 | (38) | Derived code for Displayed Negotiation Status | |
| 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. | |
| AMENDMENT_NUMBER | NUMBER | |||
| AMENDMENT_DESCRIPTION | VARCHAR2 | (4000) | ||
| AUCTION_HEADER_ID_ORIG_AMEND | NUMBER | |||
| AUCTION_HEADER_ID_PREV_AMEND | NUMBER | |||
| AWARD_APPROVAL_FLAG | VARCHAR2 | (1) | ||
| AWARD_APPROVAL_STATUS | VARCHAR2 | (30) | ||
| 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 contract terms exist for this negotiation | |
| 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 | ||
| SUPPL_NEGOTIATION_STATUS | VARCHAR2 | (9) | ||
| MAX_BID_COLOR_SEQUENCE_ID | NUMBER | Maximum color sequence number allotted to the responses for this negotiation. | ||
| HAS_ITEMS_FLAG | VARCHAR2 | (1) | Flag that indicates if there are any line items for this negotiation. | |
| 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. | ||
| ACTUAL_CLOSE_BIDDING_DATE | DATE | Date stored in close_bidding_date column | ||
| MAX_DOCUMENT_LINE_NUM | NUMBER | Maximun document line number that is displayed to users for this negotiation | ||
| ABSTRACT_STATUS | VARCHAR2 | (20) | Abstract Status | |
| ABSTRACT_DETAILS | VARCHAR2 | (4000) | Abstract Details | |
| INCLUDE_PDF_IN_EXTERNAL_PAGE | VARCHAR2 | (1) | Whether to Include Pdf in External Page? | |
| TEAM_SCORING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| HAS_SCORING_TEAMS_FLAG | VARCHAR2 | (1) | ||
| SCORING_LOCK_DATE | DATE | |||
| SCORING_LOCK_TP_CONTACT_ID | NUMBER | |||
| STYLE_ID | NUMBER | |||
| LINE_ATTRIBUTE_ENABLED_FLAG | VARCHAR2 | (1) | ||
| LINE_MAS_ENABLED_FLAG | VARCHAR2 | (1) | ||
| PRICE_ELEMENT_ENABLED_FLAG | VARCHAR2 | (1) | ||
| RFI_LINE_ENABLED_FLAG | VARCHAR2 | (1) | ||
| LOT_ENABLED_FLAG | VARCHAR2 | (1) | ||
| GROUP_ENABLED_FLAG | VARCHAR2 | (1) | ||
| LARGE_NEG_ENABLED_FLAG | VARCHAR2 | (1) | ||
| HDR_ATTRIBUTE_ENABLED_FLAG | VARCHAR2 | (1) | ||
| NEG_TEAM_ENABLED_FLAG | VARCHAR2 | (1) | ||
| PROXY_BIDDING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| POWER_BIDDING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| AUTO_EXTEND_ENABLED_FLAG | VARCHAR2 | (1) | ||
| PO_STYLE_ID | NUMBER | |||
| PROGRESS_PAYMENT_TYPE | VARCHAR2 | (10) | ||
| ADVANCE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
| RECOUPMENT_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
| PROGRESS_PYMT_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
| RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
| MAX_RETAINAGE_NEGOTIABLE_FLAG | VARCHAR2 | (1) | ||
| SUPPLIER_ENTERABLE_PYMT_FLAG | VARCHAR2 | (1) | ||
| PROJECT_ID | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| REQUEST_DATE | DATE | |||
| REQUESTED_BY | NUMBER | |||
| IMPORT_FILE_NAME | VARCHAR2 | (255) | ||
| NUMBER_OF_LINES | NUMBER | |||
| LAST_LINE_NUMBER | NUMBER | |||
| GLOBAL_TEMPLATE_FLAG | VARCHAR2 | (1) | Stores whether the template is global or not | |
| CONTRACT_TEMPLATE_ID | NUMBER | Contract template id for the template row | ||
| PRICE_BREAK_RESPONSE | VARCHAR2 | (25) | Price break response: None, Optional or Required | |
| 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) | ||
| STAGGERED_CLOSING_INTERVAL | NUMBER | |||
| FIRST_LINE_CLOSE_DATE | DATE | |||
| 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. | |
| AUTO_EXTEND_MIN_TRIGGER_RANK | NUMBER | The minimum rank that will trigger auto extenstion. Null value means any bid. | ||
| PRICE_TIERS_INDICATOR | VARCHAR2 | (30) | Indicates the price tier level for the auction - none, price_breaks or Quantity_tiers | |
| 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 indicates if this is a two-part RFQ. | |
| TECHNICAL_LOCK_STATUS | VARCHAR2 | (20) | Stores the technical part's lock status | |
| TECHNICAL_EVALUATION_STATUS | VARCHAR2 | (20) | Store 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 | ||
| EMD_ENABLE_FLAG | VARCHAR2 | (1) | ||
| EMD_AMOUNT | NUMBER | |||
| EMD_DUE_DATE | DATE | |||
| EMD_TYPE | VARCHAR2 | (30) | ||
| EMD_GUARANTEE_EXPIRY_DATE | NUMBER | |||
| EMD_ADDITIONAL_INFORMATION | VARCHAR2 | (2000) | ||
| POST_EMD_TO_FINANCE | VARCHAR2 | (1) | ||
| REVISION | NUMBER | Revision number for conformed CLM Documents | ||
| AMENDMENT_FLAG | VARCHAR2 | (1) | Is Amendment? | |
| CANCEL_AMENDMENT | VARCHAR2 | (1) | Is Cancellation Amendment? | |
| EFFECTIVE_DATE | DATE | Date on which Amendment is effective | ||
| SIGNED_DATE | DATE | Date on which document is approved. | ||
| SOLICITATION_TYPE | VARCHAR2 | (10) | ||
| NO_OF_COPIES | NUMBER | |||
| UDA_TEMPLATE_ID | NUMBER | |||
| STANDARD_FORM | VARCHAR2 | (240) | Standard Form for Printing Formats | |
| DOCUMENT_FORMAT | VARCHAR2 | (240) | Document Format for Printing Formats | |
| 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. | |
| EXT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| INT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| NEGOTIATION_REQUESTER_ID | NUMBER | |||
| FEDERAL_PUBLICATION_EXCEPTION | VARCHAR2 | (30) | Exception reason for not publishing solicitation to FedBizOpps | |
| ALLOW_WITHDRAW_FLAG | VARCHAR2 | (1) | Indicates whether withdrawal is allowed. | |
| FAIR_OPP_NOTICE_FLAG | VARCHAR2 | (1) | Indicates if the document is a Fair Opportunity Notice. | |
| UMBRELLA_PROGRAM_ID | NUMBER | Stores Umbrella Program ID for Award(FON) and IDV(Solicitation). | ||
| ALLOW_UNSOL_OFFER_LINES | VARCHAR2 | (1) | Stores if unsolicited lines are allowed on offer | |
| ALLOW_MULTIPLE_ACTIVE_OFFERS | VARCHAR2 | (1) | Stores if multiple active offers are allowed for this negotiation. | |
| 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
, 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
, AUCTION_SORTCOL
, CREATED_BY_FULL_NAME
, ORGANIZATION_NAME
, DOCUMENT_NUMBER
, NEGOTIATION_STATUS
, SHARE_AWARD_DECISION
, DESCRIPTION
, TEMPLATE_SCOPE
, TEMPLATE_STATUS
, IS_TEMPLATE_FLAG
, AMENDMENT_NUMBER
, AMENDMENT_DESCRIPTION
, AUCTION_HEADER_ID_ORIG_AMEND
, AUCTION_HEADER_ID_PREV_AMEND
, AWARD_APPROVAL_FLAG
, AWARD_APPROVAL_STATUS
, 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
, SUPPL_NEGOTIATION_STATUS
, MAX_BID_COLOR_SEQUENCE_ID
, HAS_ITEMS_FLAG
, PF_TYPE_ALLOWED
, SUPPLIER_VIEW_TYPE
, IS_PAUSED
, PAUSE_REMARKS
, LAST_PAUSE_DATE
, ACTUAL_CLOSE_BIDDING_DATE
, MAX_DOCUMENT_LINE_NUM
, ABSTRACT_STATUS
, ABSTRACT_DETAILS
, INCLUDE_PDF_IN_EXTERNAL_PAGE
, TEAM_SCORING_ENABLED_FLAG
, HAS_SCORING_TEAMS_FLAG
, SCORING_LOCK_DATE
, SCORING_LOCK_TP_CONTACT_ID
, 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
, 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
, REQUEST_ID
, REQUEST_DATE
, REQUESTED_BY
, IMPORT_FILE_NAME
, NUMBER_OF_LINES
, LAST_LINE_NUMBER
, GLOBAL_TEMPLATE_FLAG
, CONTRACT_TEMPLATE_ID
, PRICE_BREAK_RESPONSE
, BID_DECREMENT_METHOD
, DISPLAY_BEST_PRICE_BLIND_FLAG
, STAGGERED_CLOSING_INTERVAL
, FIRST_LINE_CLOSE_DATE
, ENFORCE_PREVRND_BID_PRICE_FLAG
, AUTO_EXTEND_MIN_TRIGGER_RANK
, PRICE_TIERS_INDICATOR
, 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
, EMD_ENABLE_FLAG
, EMD_AMOUNT
, EMD_DUE_DATE
, EMD_TYPE
, EMD_GUARANTEE_EXPIRY_DATE
, EMD_ADDITIONAL_INFORMATION
, POST_EMD_TO_FINANCE
, REVISION
, AMENDMENT_FLAG
, CANCEL_AMENDMENT
, EFFECTIVE_DATE
, SIGNED_DATE
, SOLICITATION_TYPE
, NO_OF_COPIES
, UDA_TEMPLATE_ID
, STANDARD_FORM
, DOCUMENT_FORMAT
, 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
, EXT_ATTRIBUTE1
, EXT_ATTRIBUTE10
, EXT_ATTRIBUTE11
, EXT_ATTRIBUTE12
, EXT_ATTRIBUTE13
, EXT_ATTRIBUTE14
, EXT_ATTRIBUTE15
, EXT_ATTRIBUTE2
, EXT_ATTRIBUTE3
, EXT_ATTRIBUTE4
, EXT_ATTRIBUTE5
, EXT_ATTRIBUTE6
, EXT_ATTRIBUTE7
, EXT_ATTRIBUTE8
, EXT_ATTRIBUTE9
, EXT_ATTRIBUTE_CATEGORY
, INT_ATTRIBUTE1
, INT_ATTRIBUTE10
, INT_ATTRIBUTE11
, INT_ATTRIBUTE12
, INT_ATTRIBUTE13
, INT_ATTRIBUTE14
, INT_ATTRIBUTE15
, INT_ATTRIBUTE2
, INT_ATTRIBUTE3
, INT_ATTRIBUTE4
, INT_ATTRIBUTE5
, INT_ATTRIBUTE6
, INT_ATTRIBUTE7
, INT_ATTRIBUTE8
, INT_ATTRIBUTE9
, INT_ATTRIBUTE_CATEGORY
, NEGOTIATION_REQUESTER_ID
, FEDERAL_PUBLICATION_EXCEPTION
, ALLOW_WITHDRAW_FLAG
, FAIR_OPP_NOTICE_FLAG
, UMBRELLA_PROGRAM_ID
, ALLOW_UNSOL_OFFER_LINES
, ALLOW_MULTIPLE_ACTIVE_OFFERS
, ALLOW_STAGGERED_AWARDS
FROM APPS.PON_AUCTION_HEADERS_ALL_V;
APPS
FND_LOOKUP_VALUES
HR_ALL_ORGANIZATION_UNITS_TL
HZ_PARTIES
PON_AUCTION_HEADERS_ALL
PON_LOCALE_PKG
- show dependent code
APPS
PON_AUCTION_PKG
- show dependent code
PO_CLMREQ_LINE_SOL_REFS_V
PO_VERIFY_VENDOR_ELIGIBILITY
- show dependent code
|
|
|
|