VIEW: PON.PON_BIDDING_PARTIES#

Source

View Text - Preformatted

select AUCTION_HEADER_ID AUCTION_HEADER_ID, LIST_ID LIST_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, SEQUENCE SEQUENCE, TRADING_PARTNER_NAME TRADING_PARTNER_NAME, TRADING_PARTNER_ID TRADING_PARTNER_ID, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID, NEW_SUPPLIER_NAME NEW_SUPPLIER_NAME, NEW_SUPPLIER_CONTACT_FNAME NEW_SUPPLIER_CONTACT_FNAME, NEW_SUPPLIER_CONTACT_LNAME NEW_SUPPLIER_CONTACT_LNAME, NEW_SUPPLIER_EMAIL NEW_SUPPLIER_EMAIL, NOTE_TO_NEW_SUPPLIER NOTE_TO_NEW_SUPPLIER, WF_USER_NAME WF_USER_NAME, INVITATION_ID INVITATION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, AUCTION_CREATION_DATE AUCTION_CREATION_DATE, BID_CURRENCY_CODE BID_CURRENCY_CODE, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS, RATE RATE, DERIVE_TYPE DERIVE_TYPE, ADDITIONAL_CONTACT_EMAIL ADDITIONAL_CONTACT_EMAIL, ROUND_NUMBER ROUND_NUMBER, SUPP_ACKNOWLEDGEMENT SUPP_ACKNOWLEDGEMENT, ACK_PARTNER_CONTACT_NAME ACK_PARTNER_CONTACT_NAME, ACK_PARTNER_CONTACT_ID ACK_PARTNER_CONTACT_ID, ACKNOWLEDGEMENT_TIME ACKNOWLEDGEMENT_TIME, ACK_NOTE_TO_AUCTIONEER ACK_NOTE_TO_AUCTIONEER, REGISTRATION_ID REGISTRATION_ID, RATE_DSP RATE_DSP, WF_ITEM_KEY WF_ITEM_KEY, LAST_AMENDMENT_UPDATE LAST_AMENDMENT_UPDATE, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, MODIFIED_FLAG MODIFIED_FLAG, ACCESS_TYPE ACCESS_TYPE, REQUESTED_SUPPLIER_ID REQUESTED_SUPPLIER_ID, REQUESTED_SUPPLIER_CONTACT_ID REQUESTED_SUPPLIER_CONTACT_ID, REQUESTED_SUPPLIER_NAME REQUESTED_SUPPLIER_NAME, REQUESTED_SUPP_CONTACT_NAME REQUESTED_SUPP_CONTACT_NAME, FROM_EMD_FLAG FROM_EMD_FLAG, EXEMPT_FLAG EXEMPT_FLAG from "PON"."PON_BIDDING_PARTIES"

View Text - HTML Formatted

SELECT AUCTION_HEADER_ID AUCTION_HEADER_ID
, LIST_ID LIST_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, SEQUENCE SEQUENCE
, TRADING_PARTNER_NAME TRADING_PARTNER_NAME
, TRADING_PARTNER_ID TRADING_PARTNER_ID
, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME
, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID
, NEW_SUPPLIER_NAME NEW_SUPPLIER_NAME
, NEW_SUPPLIER_CONTACT_FNAME NEW_SUPPLIER_CONTACT_FNAME
, NEW_SUPPLIER_CONTACT_LNAME NEW_SUPPLIER_CONTACT_LNAME
, NEW_SUPPLIER_EMAIL NEW_SUPPLIER_EMAIL
, NOTE_TO_NEW_SUPPLIER NOTE_TO_NEW_SUPPLIER
, WF_USER_NAME WF_USER_NAME
, INVITATION_ID INVITATION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, AUCTION_CREATION_DATE AUCTION_CREATION_DATE
, BID_CURRENCY_CODE BID_CURRENCY_CODE
, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS
, RATE RATE
, DERIVE_TYPE DERIVE_TYPE
, ADDITIONAL_CONTACT_EMAIL ADDITIONAL_CONTACT_EMAIL
, ROUND_NUMBER ROUND_NUMBER
, SUPP_ACKNOWLEDGEMENT SUPP_ACKNOWLEDGEMENT
, ACK_PARTNER_CONTACT_NAME ACK_PARTNER_CONTACT_NAME
, ACK_PARTNER_CONTACT_ID ACK_PARTNER_CONTACT_ID
, ACKNOWLEDGEMENT_TIME ACKNOWLEDGEMENT_TIME
, ACK_NOTE_TO_AUCTIONEER ACK_NOTE_TO_AUCTIONEER
, REGISTRATION_ID REGISTRATION_ID
, RATE_DSP RATE_DSP
, WF_ITEM_KEY WF_ITEM_KEY
, LAST_AMENDMENT_UPDATE LAST_AMENDMENT_UPDATE
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, MODIFIED_FLAG MODIFIED_FLAG
, ACCESS_TYPE ACCESS_TYPE
, REQUESTED_SUPPLIER_ID REQUESTED_SUPPLIER_ID
, REQUESTED_SUPPLIER_CONTACT_ID REQUESTED_SUPPLIER_CONTACT_ID
, REQUESTED_SUPPLIER_NAME REQUESTED_SUPPLIER_NAME
, REQUESTED_SUPP_CONTACT_NAME REQUESTED_SUPP_CONTACT_NAME
, FROM_EMD_FLAG FROM_EMD_FLAG
, EXEMPT_FLAG EXEMPT_FLAG
FROM "PON"."PON_BIDDING_PARTIES"