VIEW: PON.PON_BID_HEADERS_ARCH#

Source

View Text - Preformatted

select LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG, AUCTION_HEADER_ID AUCTION_HEADER_ID, BID_NUMBER BID_NUMBER, BID_REVISION_NUMBER BID_REVISION_NUMBER, 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, BID_STATUS BID_STATUS, BID_EFFECTIVE_DATE BID_EFFECTIVE_DATE, BID_EXPIRATION_DATE BID_EXPIRATION_DATE, PUBLISH_DATE PUBLISH_DATE, CANCELLED_DATE CANCELLED_DATE, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, CARRIER_CODE CARRIER_CODE, FOB_CODE FOB_CODE, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER, 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, ATTACHMENTS_FLAG ATTACHMENTS_FLAG, DISQUALIFY_REASON DISQUALIFY_REASON, PAYMENT_TERMS PAYMENT_TERMS, FREIGHT_TERMS FREIGHT_TERMS, CARRIER CARRIER, FOB FOB, BID_STATUS_NAME BID_STATUS_NAME, LANGUAGE_CODE LANGUAGE_CODE, AWARD_STATUS AWARD_STATUS, AWARD_STATUS_NAME AWARD_STATUS_NAME, PAYMENT_TERMS_CODE PAYMENT_TERMS_CODE, PHONE PHONE, FAX FAX, EMAIL EMAIL, 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, ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER, ORIGINAL_REVISION_NUMBER ORIGINAL_REVISION_NUMBER, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND, DOCTYPE_ID DOCTYPE_ID, CANCEL_REASON CANCEL_REASON, MODE_OF_TRANSPORT_CODE MODE_OF_TRANSPORT_CODE, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, UPDATE_SOURCING_RULES UPDATE_SOURCING_RULES, AGENT_ID AGENT_ID, CREATE_SOURCING_RULES CREATE_SOURCING_RULES, RELEASE_METHOD RELEASE_METHOD, PO_HEADER_ID PO_HEADER_ID, PO_ERROR_CODE PO_ERROR_CODE, PO_WF_CREATION_RND PO_WF_CREATION_RND, RATE_DSP RATE_DSP from "PON"."PON_BID_HEADERS_ARCH"

View Text - HTML Formatted

SELECT LATEST_EXTERNAL_FLAG LATEST_EXTERNAL_FLAG
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, BID_NUMBER BID_NUMBER
, BID_REVISION_NUMBER BID_REVISION_NUMBER
, 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
, BID_STATUS BID_STATUS
, BID_EFFECTIVE_DATE BID_EFFECTIVE_DATE
, BID_EXPIRATION_DATE BID_EXPIRATION_DATE
, PUBLISH_DATE PUBLISH_DATE
, CANCELLED_DATE CANCELLED_DATE
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, CARRIER_CODE CARRIER_CODE
, FOB_CODE FOB_CODE
, NOTE_TO_AUCTION_OWNER NOTE_TO_AUCTION_OWNER
, 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
, ATTACHMENTS_FLAG ATTACHMENTS_FLAG
, DISQUALIFY_REASON DISQUALIFY_REASON
, PAYMENT_TERMS PAYMENT_TERMS
, FREIGHT_TERMS FREIGHT_TERMS
, CARRIER CARRIER
, FOB FOB
, BID_STATUS_NAME BID_STATUS_NAME
, LANGUAGE_CODE LANGUAGE_CODE
, AWARD_STATUS AWARD_STATUS
, AWARD_STATUS_NAME AWARD_STATUS_NAME
, PAYMENT_TERMS_CODE PAYMENT_TERMS_CODE
, PHONE PHONE
, FAX FAX
, EMAIL EMAIL
, 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
, ORIGINAL_BID_NUMBER ORIGINAL_BID_NUMBER
, ORIGINAL_REVISION_NUMBER ORIGINAL_REVISION_NUMBER
, BID_NUMBER_ORIGINAL_ROUND BID_NUMBER_ORIGINAL_ROUND
, BID_NUMBER_PREV_ROUND BID_NUMBER_PREV_ROUND
, DOCTYPE_ID DOCTYPE_ID
, CANCEL_REASON CANCEL_REASON
, MODE_OF_TRANSPORT_CODE MODE_OF_TRANSPORT_CODE
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, UPDATE_SOURCING_RULES UPDATE_SOURCING_RULES
, AGENT_ID AGENT_ID
, CREATE_SOURCING_RULES CREATE_SOURCING_RULES
, RELEASE_METHOD RELEASE_METHOD
, PO_HEADER_ID PO_HEADER_ID
, PO_ERROR_CODE PO_ERROR_CODE
, PO_WF_CREATION_RND PO_WF_CREATION_RND
, RATE_DSP RATE_DSP
FROM "PON"."PON_BID_HEADERS_ARCH"