VIEW: PON.PON_BID_HEADERS#

Source

View Text - Preformatted

select BID_NUMBER BID_NUMBER, AUCTION_HEADER_ID AUCTION_HEADER_ID, BIDDERS_BID_NUMBER BIDDERS_BID_NUMBER, BID_TYPE BID_TYPE, CONTRACT_TYPE CONTRACT_TYPE, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID, TRADING_PARTNER_NAME TRADING_PARTNER_NAME, TRADING_PARTNER_ID TRADING_PARTNER_ID, PHONE PHONE, FAX FAX, EMAIL EMAIL, BID_STATUS BID_STATUS, BID_STATUS_NAME BID_STATUS_NAME, AWARD_STATUS AWARD_STATUS, AWARD_STATUS_NAME AWARD_STATUS_NAME, BID_EFFECTIVE_DATE BID_EFFECTIVE_DATE, BID_EXPIRATION_DATE BID_EXPIRATION_DATE, PUBLISH_DATE PUBLISH_DATE, CANCELLED_DATE CANCELLED_DATE, DISQUALIFY_REASON DISQUALIFY_REASON, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, CARRIER_CODE CARRIER_CODE, FOB_CODE FOB_CODE, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER, ATTACHMENTS_FLAG ATTACHMENTS_FLAG, LANGUAGE_CODE LANGUAGE_CODE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, AUCTION_CREATION_DATE AUCTION_CREATION_DATE, BID_CURRENCY_CODE BID_CURRENCY_CODE, RATE RATE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, MIN_BID_CHANGE MIN_BID_CHANGE, ORDER_NUMBER ORDER_NUMBER, PO_TXN_FLAG PO_TXN_FLAG, DOCUMENT_TRACKING_ID DOCUMENT_TRACKING_ID, PROXY_BID_FLAG PROXY_BID_FLAG, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND, DOCTYPE_ID DOCTYPE_ID, BID_REVISION_NUMBER BID_REVISION_NUMBER, ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER, ORIGINAL_REVISION_NUMBER ORIGINAL_REVISION_NUMBER, CANCEL_REASON CANCEL_REASON, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, AGENT_ID AGENT_ID, CREATE_SOURCING_RULES CREATE_SOURCING_RULES, UPDATE_SOURCING_RULES UPDATE_SOURCING_RULES, RELEASE_METHOD RELEASE_METHOD, PO_HEADER_ID PO_HEADER_ID, PO_WF_CREATION_RND PO_WF_CREATION_RND, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, PO_ERROR_CODE PO_ERROR_CODE, RATE_DSP RATE_DSP, PO_START_DATE PO_START_DATE, PO_END_DATE PO_END_DATE, INITIATE_APPROVAL INITIATE_APPROVAL, PO_ERROR_MSG PO_ERROR_MSG, DRAFT_LOCKED DRAFT_LOCKED, DRAFT_LOCKED_BY DRAFT_LOCKED_BY, DRAFT_LOCKED_BY_CONTACT_ID DRAFT_LOCKED_BY_CONTACT_ID, DRAFT_LOCKED_DATE DRAFT_LOCKED_DATE, DRAFT_UNLOCKED_BY DRAFT_UNLOCKED_BY, DRAFT_UNLOCKED_BY_CONTACT_ID DRAFT_UNLOCKED_BY_CONTACT_ID, DRAFT_UNLOCKED_DATE DRAFT_UNLOCKED_DATE, VENDOR_SITE_CODE VENDOR_SITE_CODE, INTERNAL_NOTE INTERNAL_NOTE, SHORTLIST_FLAG SHORTLIST_FLAG, ATTRIBUTE_LINE_NUMBER ATTRIBUTE_LINE_NUMBER, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER, TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG, SURROG_BID_CREATED_TP_ID SURROG_BID_CREATED_TP_ID, SURROG_BID_CREATED_CONTACT_ID SURROG_BID_CREATED_CONTACT_ID, SURROG_BID_RECEIPT_DATE SURROG_BID_RECEIPT_DATE, SURROG_BID_ONLINE_ENTRY_DATE SURROG_BID_ONLINE_ENTRY_DATE, SURROG_BID_FLAG SURROG_BID_FLAG, COLOR_SEQUENCE_ID COLOR_SEQUENCE_ID, AWARD_DATE AWARD_DATE, PARTIAL_RESPONSE_FLAG PARTIAL_RESPONSE_FLAG, INCUMBENT_FLAG INCUMBENT_FLAG, SCORE_OVERRIDEN_FLAG SCORE_OVERRIDEN_FLAG, SCORE_OVERRIDEN_DATE SCORE_OVERRIDEN_DATE, SCORE_OVERRIDE_TP_CONTACT_ID SCORE_OVERRIDE_TP_CONTACT_ID, REQUEST_ID REQUEST_ID, REQUEST_DATE REQUEST_DATE, REQUESTED_BY REQUESTED_BY, IMPORT_FILE_NAME IMPORT_FILE_NAME, REL12_DRAFT_FLAG REL12_DRAFT_FLAG, OLD_NOTE_TO_AUCTION_OWNER OLD_NOTE_TO_AUCTION_OWNER, OLD_BIDDERS_BID_NUMBER OLD_BIDDERS_BID_NUMBER, OLD_BID_EXPIRATION_DATE OLD_BID_EXPIRATION_DATE, OLD_BID_STATUS OLD_BID_STATUS, OLD_MIN_BID_CHANGE OLD_MIN_BID_CHANGE, OLD_SURROG_BID_RECEIPT_DATE OLD_SURROG_BID_RECEIPT_DATE, DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG, OLD_BID_NUMBER OLD_BID_NUMBER, BUYER_BID_TOTAL BUYER_BID_TOTAL, SHORTLIST_TPC_ID SHORTLIST_TPC_ID, CURRENT_TOTAL_SPEND CURRENT_TOTAL_SPEND, FIXED_INCENTIVE FIXED_INCENTIVE, CURRENT_REBATE CURRENT_REBATE, HAS_REBATE_TIERS HAS_REBATE_TIERS, TECHNICAL_SHORTLIST_FLAG TECHNICAL_SHORTLIST_FLAG, SUBMIT_STAGE SUBMIT_STAGE, EVALUATOR_ID EVALUATOR_ID, EVALUATION_FLAG EVALUATION_FLAG, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE, EXTERNAL_IDV EXTERNAL_IDV, IDV_HEADER_ID IDV_HEADER_ID, WITHDRAW_REASON WITHDRAW_REASON from "PON"."PON_BID_HEADERS"

View Text - HTML Formatted

SELECT BID_NUMBER BID_NUMBER
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, BIDDERS_BID_NUMBER BIDDERS_BID_NUMBER
, BID_TYPE BID_TYPE
, CONTRACT_TYPE CONTRACT_TYPE
, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME
, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, TRADING_PARTNER_ID TRADING_PARTNER_ID
, PHONE PHONE
, FAX FAX
, EMAIL EMAIL
, BID_STATUS BID_STATUS
, BID_STATUS_NAME BID_STATUS_NAME
, AWARD_STATUS AWARD_STATUS
, AWARD_STATUS_NAME AWARD_STATUS_NAME
, BID_EFFECTIVE_DATE BID_EFFECTIVE_DATE
, BID_EXPIRATION_DATE BID_EXPIRATION_DATE
, PUBLISH_DATE PUBLISH_DATE
, CANCELLED_DATE CANCELLED_DATE
, DISQUALIFY_REASON DISQUALIFY_REASON
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, CARRIER_CODE CARRIER_CODE
, FOB_CODE FOB_CODE
, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER
, ATTACHMENTS_FLAG ATTACHMENTS_FLAG
, LANGUAGE_CODE LANGUAGE_CODE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, AUCTION_CREATION_DATE AUCTION_CREATION_DATE
, BID_CURRENCY_CODE BID_CURRENCY_CODE
, RATE RATE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, MIN_BID_CHANGE MIN_BID_CHANGE
, ORDER_NUMBER ORDER_NUMBER
, PO_TXN_FLAG PO_TXN_FLAG
, DOCUMENT_TRACKING_ID DOCUMENT_TRACKING_ID
, PROXY_BID_FLAG PROXY_BID_FLAG
, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND
, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND
, DOCTYPE_ID DOCTYPE_ID
, BID_REVISION_NUMBER BID_REVISION_NUMBER
, ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER
, ORIGINAL_REVISION_NUMBER ORIGINAL_REVISION_NUMBER
, CANCEL_REASON CANCEL_REASON
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, AGENT_ID AGENT_ID
, CREATE_SOURCING_RULES CREATE_SOURCING_RULES
, UPDATE_SOURCING_RULES UPDATE_SOURCING_RULES
, RELEASE_METHOD RELEASE_METHOD
, PO_HEADER_ID PO_HEADER_ID
, PO_WF_CREATION_RND PO_WF_CREATION_RND
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, PO_ERROR_CODE PO_ERROR_CODE
, RATE_DSP RATE_DSP
, PO_START_DATE PO_START_DATE
, PO_END_DATE PO_END_DATE
, INITIATE_APPROVAL INITIATE_APPROVAL
, PO_ERROR_MSG PO_ERROR_MSG
, DRAFT_LOCKED DRAFT_LOCKED
, DRAFT_LOCKED_BY DRAFT_LOCKED_BY
, DRAFT_LOCKED_BY_CONTACT_ID DRAFT_LOCKED_BY_CONTACT_ID
, DRAFT_LOCKED_DATE DRAFT_LOCKED_DATE
, DRAFT_UNLOCKED_BY DRAFT_UNLOCKED_BY
, DRAFT_UNLOCKED_BY_CONTACT_ID DRAFT_UNLOCKED_BY_CONTACT_ID
, DRAFT_UNLOCKED_DATE DRAFT_UNLOCKED_DATE
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, INTERNAL_NOTE INTERNAL_NOTE
, SHORTLIST_FLAG SHORTLIST_FLAG
, ATTRIBUTE_LINE_NUMBER ATTRIBUTE_LINE_NUMBER
, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER
, TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT
, ACCEPTANCE_REQUIRED_FLAG ACCEPTANCE_REQUIRED_FLAG
, SURROG_BID_CREATED_TP_ID SURROG_BID_CREATED_TP_ID
, SURROG_BID_CREATED_CONTACT_ID SURROG_BID_CREATED_CONTACT_ID
, SURROG_BID_RECEIPT_DATE SURROG_BID_RECEIPT_DATE
, SURROG_BID_ONLINE_ENTRY_DATE SURROG_BID_ONLINE_ENTRY_DATE
, SURROG_BID_FLAG SURROG_BID_FLAG
, COLOR_SEQUENCE_ID COLOR_SEQUENCE_ID
, AWARD_DATE AWARD_DATE
, PARTIAL_RESPONSE_FLAG PARTIAL_RESPONSE_FLAG
, INCUMBENT_FLAG INCUMBENT_FLAG
, SCORE_OVERRIDEN_FLAG SCORE_OVERRIDEN_FLAG
, SCORE_OVERRIDEN_DATE SCORE_OVERRIDEN_DATE
, SCORE_OVERRIDE_TP_CONTACT_ID SCORE_OVERRIDE_TP_CONTACT_ID
, REQUEST_ID REQUEST_ID
, REQUEST_DATE REQUEST_DATE
, REQUESTED_BY REQUESTED_BY
, IMPORT_FILE_NAME IMPORT_FILE_NAME
, REL12_DRAFT_FLAG REL12_DRAFT_FLAG
, OLD_NOTE_TO_AUCTION_OWNER OLD_NOTE_TO_AUCTION_OWNER
, OLD_BIDDERS_BID_NUMBER OLD_BIDDERS_BID_NUMBER
, OLD_BID_EXPIRATION_DATE OLD_BID_EXPIRATION_DATE
, OLD_BID_STATUS OLD_BID_STATUS
, OLD_MIN_BID_CHANGE OLD_MIN_BID_CHANGE
, OLD_SURROG_BID_RECEIPT_DATE OLD_SURROG_BID_RECEIPT_DATE
, DISPLAY_PRICE_FACTORS_FLAG DISPLAY_PRICE_FACTORS_FLAG
, OLD_BID_NUMBER OLD_BID_NUMBER
, BUYER_BID_TOTAL BUYER_BID_TOTAL
, SHORTLIST_TPC_ID SHORTLIST_TPC_ID
, CURRENT_TOTAL_SPEND CURRENT_TOTAL_SPEND
, FIXED_INCENTIVE FIXED_INCENTIVE
, CURRENT_REBATE CURRENT_REBATE
, HAS_REBATE_TIERS HAS_REBATE_TIERS
, TECHNICAL_SHORTLIST_FLAG TECHNICAL_SHORTLIST_FLAG
, SUBMIT_STAGE SUBMIT_STAGE
, EVALUATOR_ID EVALUATOR_ID
, EVALUATION_FLAG EVALUATION_FLAG
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE
, EXTERNAL_IDV EXTERNAL_IDV
, IDV_HEADER_ID IDV_HEADER_ID
, WITHDRAW_REASON WITHDRAW_REASON
FROM "PON"."PON_BID_HEADERS"