[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#;
|
|
|