[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PON_AUCTION_HEADERS_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | PON |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUCTION_HEADER_ID | NUMBER | Yes | ||
| AUCTION_TITLE | VARCHAR2 | (80) | ||
| AUCTION_STATUS | VARCHAR2 | (25) | ||
| AUCTION_STATUS_NAME | VARCHAR2 | (80) | ||
| AWARD_STATUS | VARCHAR2 | (25) | ||
| AWARD_STATUS_NAME | VARCHAR2 | (80) | ||
| AUCTION_TYPE | VARCHAR2 | (25) | ||
| CONTRACT_TYPE | VARCHAR2 | (25) | ||
| TRADING_PARTNER_CONTACT_NAME | VARCHAR2 | (255) | ||
| TRADING_PARTNER_CONTACT_ID | NUMBER | |||
| TRADING_PARTNER_NAME | VARCHAR2 | (255) | ||
| TRADING_PARTNER_NAME_UPPER | VARCHAR2 | (255) | ||
| TRADING_PARTNER_ID | NUMBER | |||
| SHIP_TO_LOCATION_ID | NUMBER | |||
| BILL_TO_LOCATION_ID | NUMBER | |||
| OPEN_BIDDING_DATE | DATE | |||
| CLOSE_BIDDING_DATE | DATE | |||
| ORIGINAL_CLOSE_BIDDING_DATE | DATE | |||
| VIEW_BY_DATE | DATE | |||
| AWARD_BY_DATE | DATE | |||
| PUBLISH_DATE | DATE | |||
| CLOSE_DATE | DATE | |||
| CANCEL_DATE | DATE | |||
| TIME_ZONE | VARCHAR2 | (25) | ||
| BID_VISIBILITY_CODE | VARCHAR2 | (25) | ||
| BID_LIST_TYPE | VARCHAR2 | (25) | ||
| BID_FREQUENCY_CODE | VARCHAR2 | (25) | ||
| BID_SCOPE_CODE | VARCHAR2 | (25) | ||
| AUTO_EXTEND_FLAG | VARCHAR2 | (1) | ||
| AUTO_EXTEND_NUMBER | NUMBER | |||
| NUMBER_OF_EXTENSIONS | NUMBER | |||
| NUMBER_OF_BIDS | NUMBER | |||
| MIN_BID_DECREMENT | NUMBER | |||
| PRICE_DRIVEN_AUCTION_FLAG | VARCHAR2 | (1) | ||
| PAYMENT_TERMS_ID | NUMBER | |||
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | ||
| FOB_CODE | VARCHAR2 | (25) | ||
| CARRIER_CODE | VARCHAR2 | (25) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| RATE_TYPE | VARCHAR2 | (25) | ||
| RATE_DATE | DATE | |||
| RATE | NUMBER | |||
| NOTE_TO_BIDDERS | VARCHAR2 | (4000) | ||
| ATTACHMENT_FLAG | VARCHAR2 | (1) | ||
| LANGUAGE_CODE | VARCHAR2 | (4) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| WF_ITEM_KEY | VARCHAR2 | (240) | ||
| WF_ROLE_NAME | VARCHAR2 | (30) | ||
| AUTO_EXTEND_ALL_LINES_FLAG | VARCHAR2 | (1) | ||
| MIN_BID_INCREMENT | NUMBER | |||
| ALLOW_OTHER_BID_CURRENCY_FLAG | VARCHAR2 | (1) | ||
| SHIPPING_TERMS_CODE | VARCHAR2 | (25) | ||
| SHIPPING_TERMS | VARCHAR2 | (80) | ||
| AUTO_EXTEND_DURATION | NUMBER | |||
| PROXY_BID_ALLOWED_FLAG | VARCHAR2 | (1) | ||
| PUBLISH_RATES_TO_BIDDERS_FLAG | VARCHAR2 | (1) | ||
| ATTRIBUTES_EXIST | VARCHAR2 | (20) | ||
| ORDER_NUMBER | VARCHAR2 | (20) | ||
| DOCUMENT_TRACKING_ID | NUMBER | |||
| PO_TXN_FLAG | VARCHAR2 | (1) | ||
| EVENT_ID | NUMBER | |||
| EVENT_TITLE | VARCHAR2 | (80) | ||
| SEALED_AUCTION_STATUS | VARCHAR2 | (30) | ||
| SEALED_ACTUAL_UNLOCK_DATE | DATE | |||
| SEALED_ACTUAL_UNSEAL_DATE | DATE | |||
| SEALED_UNLOCK_TP_CONTACT_ID | NUMBER | |||
| SEALED_UNSEAL_TP_CONTACT_ID | NUMBER | |||
| MODE_OF_TRANSPORT | VARCHAR2 | (80) | ||
| MODE_OF_TRANSPORT_CODE | VARCHAR2 | (25) | ||
| PO_START_DATE | DATE | |||
| PO_END_DATE | DATE | |||
| PO_AGREED_AMOUNT | NUMBER | |||
| MIN_BID_CHANGE_TYPE | VARCHAR2 | (25) | ||
| FULL_QUANTITY_BID_CODE | VARCHAR2 | (25) | ||
| NUMBER_PRICE_DECIMALS | NUMBER | |||
| AUTO_EXTEND_TYPE_FLAG | VARCHAR2 | (25) | ||
| AUCTION_ORIGINATION_CODE | VARCHAR2 | (50) | ||
| MULTIPLE_ROUNDS_FLAG | VARCHAR2 | (1) | ||
| AUCTION_HEADER_ID_ORIG_ROUND | NUMBER | |||
| AUCTION_HEADER_ID_PREV_ROUND | NUMBER | |||
| AUCTION_ROUND_NUMBER | NUMBER | |||
| MANUAL_CLOSE_FLAG | VARCHAR2 | (1) | ||
| MANUAL_EXTEND_FLAG | VARCHAR2 | (1) | ||
| AUTOEXTEND_CHANGED_FLAG | VARCHAR2 | (1) | ||
| DOCTYPE_ID | NUMBER | |||
| OFFER_TYPE | VARCHAR2 | (30) | ||
| APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| MAX_RESPONSES | NUMBER | |||
| RESPONSE_ALLOWED_FLAG | VARCHAR2 | (1) | ||
| FOB_NEG_FLAG | VARCHAR2 | (1) | ||
| CARRIER_NEG_FLAG | VARCHAR2 | (1) | ||
| FREIGHT_TERMS_NEG_FLAG | VARCHAR2 | (1) | ||
| MAX_RESPONSE_ITERATIONS | NUMBER | |||
| PAYMENT_TERMS_NEG_FLAG | VARCHAR2 | (1) | ||
| MODE_OF_TRANSPORT_NEG_FLAG | VARCHAR2 | (1) | ||
| CONTRACT_ID | NUMBER | |||
| CONTRACT_VERSION_NUM | NUMBER | |||
| SHIPPING_TERMS_NEG_FLAG | VARCHAR2 | (1) | ||
| SHIPPING_METHOD_NEG_FLAG | VARCHAR2 | (1) | ||
| USE_REGIONAL_PRICING_FLAG | VARCHAR2 | (1) | ||
| SHOW_BIDDER_NOTES | VARCHAR2 | (1) | ||
| DERIVE_TYPE | VARCHAR2 | (8) | ||
| PRE_DELETE_AUCTION_STATUS | VARCHAR2 | (25) | ||
| DRAFT_LOCKED | VARCHAR2 | (1) | ||
| DRAFT_LOCKED_BY | NUMBER | |||
| DRAFT_LOCKED_BY_CONTACT_ID | NUMBER | |||
| DRAFT_LOCKED_DATE | DATE | |||
| DRAFT_UNLOCKED_BY | NUMBER | |||
| DRAFT_UNLOCKED_BY_CONTACT_ID | NUMBER | |||
| DRAFT_UNLOCKED_DATE | DATE | |||
| MAX_LINE_NUMBER | NUMBER | |||
| BID_RANKING | VARCHAR2 | (25) | ||
| RANK_INDICATOR | VARCHAR2 | (25) | ||
| SHOW_BIDDER_SCORES | VARCHAR2 | (25) | ||
| OPEN_AUCTION_NOW_FLAG | VARCHAR2 | (1) | ||
| PUBLISH_AUCTION_NOW_FLAG | VARCHAR2 | (1) | ||
| TEMPLATE_ID | NUMBER | |||
| REMINDER_DATE | DATE | |||
| ORG_ID | NUMBER | |||
| BUYER_ID | NUMBER | |||
| MANUAL_EDIT_FLAG | VARCHAR2 | (1) | ||
| WF_PONCOMPL_ITEM_KEY | VARCHAR2 | (240) | ||
| HAS_PE_FOR_ALL_ITEMS | VARCHAR2 | (30) | ||
| HAS_PRICE_ELEMENTS | VARCHAR2 | (30) | ||
| PO_MIN_REL_AMOUNT | NUMBER | |||
| GLOBAL_AGREEMENT_FLAG | VARCHAR2 | (1) | ||
| OUTCOME_STATUS | VARCHAR2 | (30) | ||
| SOURCE_REQS_FLAG | VARCHAR2 | (25) | ||
| AWARD_COMPLETE_DATE | DATE | |||
| WF_PONCOMPL_CURRENT_ROUND | NUMBER | |||
| SECURITY_LEVEL_CODE | VARCHAR2 | (25) | ||
| WF_APPROVAL_ITEM_KEY | VARCHAR2 | (240) | ||
| APPROVAL_STATUS | VARCHAR2 | (30) | ||
| SOURCE_DOC_ID | NUMBER | |||
| SOURCE_DOC_NUMBER | VARCHAR2 | (20) | ||
| SOURCE_DOC_MSG | VARCHAR2 | (30) | ||
| SOURCE_DOC_LINE_MSG | VARCHAR2 | (30) | ||
| SOURCE_DOC_MSG_APP | VARCHAR2 | (3) | ||
| SHARE_AWARD_DECISION | VARCHAR2 | (1) | ||
| DESCRIPTION | VARCHAR2 | (250) | ||
| TEMPLATE_SCOPE | VARCHAR2 | (25) | ||
| TEMPLATE_STATUS | VARCHAR2 | (25) | ||
| IS_TEMPLATE_FLAG | VARCHAR2 | (1) | ||
| AWARD_APPROVAL_FLAG | VARCHAR2 | (1) | ||
| AWARD_APPROVAL_STATUS | VARCHAR2 | (30) | ||
| AWARD_APPR_AME_TRANS_ID | VARCHAR2 | (80) | ||
| AWARD_APPR_AME_TRANS_PREV_ID | VARCHAR2 | (80) | ||
| WF_AWARD_APPROVAL_ITEM_KEY | VARCHAR2 | (240) | ||
| AMENDMENT_NUMBER | NUMBER | |||
| AMENDMENT_DESCRIPTION | VARCHAR2 | (4000) | ||
| AUCTION_HEADER_ID_ORIG_AMEND | NUMBER | |||
| AUCTION_HEADER_ID_PREV_AMEND | NUMBER | |||
| DOCUMENT_NUMBER | VARCHAR2 | (240) | ||
| AWARD_APPR_AME_TXN_DATE | DATE | |||
| HDR_ATTR_ENABLE_WEIGHTS | VARCHAR2 | (1) | ||
| HDR_ATTR_DISPLAY_SCORE | VARCHAR2 | (1) | ||
| HDR_ATTR_MAXIMUM_SCORE | NUMBER | |||
| ATTRIBUTE_LINE_NUMBER | NUMBER | Yes | ||
| CONTERMS_EXIST_FLAG | VARCHAR2 | (1) | ||
| CONTERMS_ARTICLES_UPD_DATE | DATE | |||
| CONTERMS_DELIV_UPD_DATE | DATE | |||
| AWARD_MODE | VARCHAR2 | (30) | ||
| HAS_HDR_ATTR_FLAG | VARCHAR2 | (1) | ||
| AWARD_DATE | DATE | |||
| MAX_INTERNAL_LINE_NUM | NUMBER | |||
| MAX_BID_COLOR_SEQUENCE_ID | NUMBER | |||
| HAS_ITEMS_FLAG | VARCHAR2 | (1) | ||
| INT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| INT_ATTRIBUTE1 | 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_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| INT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| EXT_ATTRIBUTE1 | 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_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| EXT_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| INCLUDE_PDF_IN_EXTERNAL_PAGE | VARCHAR2 | (1) | ||
| ABSTRACT_DETAILS | VARCHAR2 | (4000) | ||
| ABSTRACT_STATUS | VARCHAR2 | (20) | ||
| PF_TYPE_ALLOWED | VARCHAR2 | (30) | ||
| SUPPLIER_VIEW_TYPE | VARCHAR2 | (30) | ||
| IS_PAUSED | VARCHAR2 | (1) | ||
| PAUSE_REMARKS | VARCHAR2 | (2000) | ||
| LAST_PAUSE_DATE | DATE | |||
| MAX_DOCUMENT_LINE_NUM | 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 | |||
| TEAM_SCORING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| HAS_SCORING_TEAMS_FLAG | VARCHAR2 | (1) | ||
| SCORING_LOCK_DATE | DATE | |||
| SCORING_LOCK_TP_CONTACT_ID | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| REQUEST_DATE | DATE | |||
| REQUESTED_BY | NUMBER | |||
| IMPORT_FILE_NAME | VARCHAR2 | (255) | ||
| NUMBER_OF_LINES | NUMBER | |||
| LAST_LINE_NUMBER | 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 | |||
| PRICE_BREAK_RESPONSE | VARCHAR2 | (25) | ||
| GLOBAL_TEMPLATE_FLAG | VARCHAR2 | (1) | ||
| CONTRACT_TEMPLATE_ID | NUMBER | |||
| COMPLETE_FLAG | VARCHAR2 | (1) | ||
| BID_DECREMENT_METHOD | VARCHAR2 | (15) | ||
| DISPLAY_BEST_PRICE_BLIND_FLAG | VARCHAR2 | (1) | ||
| FIRST_LINE_CLOSE_DATE | DATE | |||
| STAGGERED_CLOSING_INTERVAL | NUMBER | |||
| ENFORCE_PREVRND_BID_PRICE_FLAG | VARCHAR2 | (1) | ||
| PRICE_TIERS_INDICATOR | VARCHAR2 | (30) | ||
| AUTO_EXTEND_MIN_TRIGGER_RANK | NUMBER | |||
| QTY_PRICE_TIERS_ENABLED_FLAG | VARCHAR2 | (1) | ||
| TWO_PART_FLAG | VARCHAR2 | (1) | ||
| TECHNICAL_LOCK_STATUS | VARCHAR2 | (20) | ||
| TECHNICAL_EVALUATION_STATUS | VARCHAR2 | (20) | ||
| TECHNICAL_ACTUAL_UNLOCK_DATE | DATE | |||
| TECHNICAL_ACTUAL_UNSEAL_DATE | DATE | |||
| TECHNICAL_UNLOCK_TP_CONTACT_ID | NUMBER | |||
| TECHNICAL_UNSEAL_TP_CONTACT_ID | NUMBER | |||
| NO_OF_NOTIFICATIONS_SENT | NUMBER | |||
| 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) | ||
| NEGOTIATION_REQUESTER_ID | NUMBER | |||
| SUPP_REG_QUAL_FLAG | VARCHAR2 | (1) | ||
| SUPP_EVAL_FLAG | VARCHAR2 | (1) | ||
| HIDE_TERMS_FLAG | VARCHAR2 | (1) | ||
| HIDE_ABSTRACT_FORMS_FLAG | VARCHAR2 | (1) | ||
| HIDE_ATTACHMENTS_FLAG | VARCHAR2 | (1) | ||
| INTERNAL_EVAL_FLAG | VARCHAR2 | (1) | ||
| HDR_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | ||
| INTGR_HDR_ATTR_FLAG | VARCHAR2 | (1) | ||
| INTGR_HDR_ATTACH_FLAG | VARCHAR2 | (1) | ||
| LINE_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | ||
| ITEM_SUPP_ATTR_ENABLED_FLAG | VARCHAR2 | (1) | ||
| INTGR_CAT_LINE_ATTR_FLAG | VARCHAR2 | (1) | ||
| INTGR_ITEM_LINE_ATTR_FLAG | VARCHAR2 | (1) | ||
| INTGR_CAT_LINE_ASL_FLAG | VARCHAR2 | (1) | ||
| INTERNAL_ONLY_FLAG | VARCHAR2 | (1) | ||
| SYNC_STATUS | VARCHAR2 | (25) | ||
| REVISION | NUMBER | |||
| AMENDMENT_FLAG | VARCHAR2 | (1) | ||
| CANCEL_AMENDMENT | VARCHAR2 | (1) | ||
| EFFECTIVE_DATE | DATE | |||
| SIGNED_DATE | DATE | |||
| UDA_TEMPLATE_ID | NUMBER | |||
| UDA_TEMPLATE_DATE | DATE | |||
| SOLICITATION_TYPE | VARCHAR2 | (10) | ||
| NO_OF_COPIES | NUMBER | |||
| CD_GENERATED_DATE | DATE | |||
| CD_EDITBYUSER_FLAG | VARCHAR2 | (1) | ||
| CD_GENERATED_FLAG | VARCHAR2 | (1) | ||
| AMENDUPDATED_AFTERCDGENERATED | VARCHAR2 | (1) | ||
| CHANGEDESCRIPTION_DATA | CLOB | (4000) | ||
| CONCURRENT_REQID | VARCHAR2 | (20) | ||
| STANDARD_FORM | VARCHAR2 | (240) | ||
| DOCUMENT_FORMAT | VARCHAR2 | (240) | ||
| FEDERAL_PUBLICATION_EXCEPTION | VARCHAR2 | (30) | ||
| UMBRELLA_PROGRAM_ID | NUMBER | |||
| FAIR_OPP_NOTICE_FLAG | VARCHAR2 | (1) | ||
| ALLOW_WITHDRAW_FLAG | VARCHAR2 | (1) | ||
| ALLOW_UNSOL_OFFER_LINES | VARCHAR2 | (1) | ||
| ALLOW_MULTIPLE_ACTIVE_OFFERS | VARCHAR2 | (1) | ||
| ALLOW_STAGGERED_AWARDS | VARCHAR2 | (1) |
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
, 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
, ALLOW_STAGGERED_AWARDS
FROM PON.PON_AUCTION_HEADERS_ALL#;
PON
PON_AUCTION_HEADERS_ALL
APPS
PON_AUCTION_HEADERS
PON_AUCTION_HEADERS_ALL
|
|
|
|