VIEW: PON.PON_AUCTION_HEADERS_INTERFACE#

Source

View Text - Preformatted

select GROUP_BATCH_ID GROUP_BATCH_ID, BATCH_ID BATCH_ID, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, DOCUMENT_NUMBER DOCUMENT_NUMBER, AUCTION_TITLE AUCTION_TITLE, DESCRIPTION DESCRIPTION, AUCTION_TYPE AUCTION_TYPE, ORG_ID ORG_ID, CONTRACT_TYPE CONTRACT_TYPE, EVENT_ID EVENT_ID, EVENT_TITLE EVENT_TITLE, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG, PO_START_DATE PO_START_DATE, PO_END_DATE PO_END_DATE, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_CODE BILL_TO_LOCATION_CODE, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, CARRIER_CODE CARRIER_CODE, CURRENCY_CODE CURRENCY_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, PUBLISH_RATES_TO_BIDDERS_FLAG PUBLISH_RATES_TO_BIDDERS_FLAG, OPEN_BIDDING_DATE OPEN_BIDDING_DATE, CLOSE_BIDDING_DATE CLOSE_BIDDING_DATE, VIEW_BY_DATE VIEW_BY_DATE, AWARD_BY_DATE AWARD_BY_DATE, PUBLISH_DATE PUBLISH_DATE, OPEN_AUCTION_NOW_FLAG OPEN_AUCTION_NOW_FLAG, PUBLISH_AUCTION_NOW_FLAG PUBLISH_AUCTION_NOW_FLAG, NOTE_TO_BIDDERS NOTE_TO_BIDDERS, SHOW_BIDDER_NOTES SHOW_BIDDER_NOTES, BID_VISIBILITY_CODE BID_VISIBILITY_CODE, BID_SCOPE_CODE BID_SCOPE_CODE, BID_LIST_TYPE BID_LIST_TYPE, BID_FREQUENCY_CODE BID_FREQUENCY_CODE, BID_RANKING BID_RANKING, RANK_INDICATOR RANK_INDICATOR, FULL_QUANTITY_BID_CODE FULL_QUANTITY_BID_CODE, MULTIPLE_ROUNDS_FLAG MULTIPLE_ROUNDS_FLAG, MANUAL_CLOSE_FLAG MANUAL_CLOSE_FLAG, MANUAL_EXTEND_FLAG MANUAL_EXTEND_FLAG, AWARD_APPROVAL_FLAG AWARD_APPROVAL_FLAG, AUCTION_ORIGINATION_CODE AUCTION_ORIGINATION_CODE, DOCTYPE_ID DOCTYPE_ID, BUYER_ID BUYER_ID, STYLE_ID STYLE_ID, PO_STYLE_ID PO_STYLE_ID, ADVANCE_NEGOTIABLE_FLAG ADVANCE_NEGOTIABLE_FLAG, RECOUPMENT_NEGOTIABLE_FLAG RECOUPMENT_NEGOTIABLE_FLAG, PROGRESS_PYMT_NEGOTIABLE_FLAG PROGRESS_PYMT_NEGOTIABLE_FLAG, RETAINAGE_NEGOTIABLE_FLAG RETAINAGE_NEGOTIABLE_FLAG, MAX_RETAINAGE_NEGOTIABLE_FLAG MAX_RETAINAGE_NEGOTIABLE_FLAG, SUPPLIER_ENTERABLE_PYMT_FLAG SUPPLIER_ENTERABLE_PYMT_FLAG, TWO_PART_FLAG TWO_PART_FLAG, PROJECT_ID PROJECT_ID, PF_TYPE_ALLOWED PF_TYPE_ALLOWED, PRICE_BREAK_RESPONSE PRICE_BREAK_RESPONSE, PRICE_TIERS_INDICATOR PRICE_TIERS_INDICATOR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, INT_ATTRIBUTE_CATEGORY INT_ATTRIBUTE_CATEGORY, INT_ATTRIBUTE1 INT_ATTRIBUTE1, INT_ATTRIBUTE2 INT_ATTRIBUTE2, INT_ATTRIBUTE3 INT_ATTRIBUTE3, INT_ATTRIBUTE4 INT_ATTRIBUTE4, INT_ATTRIBUTE5 INT_ATTRIBUTE5, INT_ATTRIBUTE6 INT_ATTRIBUTE6, INT_ATTRIBUTE7 INT_ATTRIBUTE7, INT_ATTRIBUTE8 INT_ATTRIBUTE8, INT_ATTRIBUTE9 INT_ATTRIBUTE9, INT_ATTRIBUTE10 INT_ATTRIBUTE10, INT_ATTRIBUTE11 INT_ATTRIBUTE11, INT_ATTRIBUTE12 INT_ATTRIBUTE12, INT_ATTRIBUTE13 INT_ATTRIBUTE13, INT_ATTRIBUTE14 INT_ATTRIBUTE14, INT_ATTRIBUTE15 INT_ATTRIBUTE15, EXT_ATTRIBUTE_CATEGORY EXT_ATTRIBUTE_CATEGORY, EXT_ATTRIBUTE1 EXT_ATTRIBUTE1, EXT_ATTRIBUTE2 EXT_ATTRIBUTE2, EXT_ATTRIBUTE3 EXT_ATTRIBUTE3, EXT_ATTRIBUTE4 EXT_ATTRIBUTE4, EXT_ATTRIBUTE5 EXT_ATTRIBUTE5, EXT_ATTRIBUTE6 EXT_ATTRIBUTE6, EXT_ATTRIBUTE7 EXT_ATTRIBUTE7, EXT_ATTRIBUTE8 EXT_ATTRIBUTE8, EXT_ATTRIBUTE9 EXT_ATTRIBUTE9, EXT_ATTRIBUTE10 EXT_ATTRIBUTE10, EXT_ATTRIBUTE11 EXT_ATTRIBUTE11, EXT_ATTRIBUTE12 EXT_ATTRIBUTE12, EXT_ATTRIBUTE13 EXT_ATTRIBUTE13, EXT_ATTRIBUTE14 EXT_ATTRIBUTE14, EXT_ATTRIBUTE15 EXT_ATTRIBUTE15, EFFECTIVE_DATE EFFECTIVE_DATE, SIGNED_DATE SIGNED_DATE, AMENDMENT_FLAG AMENDMENT_FLAG, SOLICITATION_TYPE SOLICITATION_TYPE, UDA_TEMPLATE_ID UDA_TEMPLATE_ID, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE, NO_OF_COPIES NO_OF_COPIES, PO_STYLE_NAME PO_STYLE_NAME, AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION, STANDARD_FORM STANDARD_FORM, DOCUMENT_FORMAT DOCUMENT_FORMAT, AUTO_EXTEND_MIN_TRIGGER_RANK AUTO_EXTEND_MIN_TRIGGER_RANK, ENFORCE_PREVRND_BID_PRICE_FLAG ENFORCE_PREVRND_BID_PRICE_FLAG, STAGGERED_CLOSING_INTERVAL STAGGERED_CLOSING_INTERVAL, FIRST_LINE_CLOSE_DATE FIRST_LINE_CLOSE_DATE, DISPLAY_BEST_PRICE_BLIND_FLAG DISPLAY_BEST_PRICE_BLIND_FLAG, BID_DECREMENT_METHOD BID_DECREMENT_METHOD, SUPPLIER_VIEW_TYPE SUPPLIER_VIEW_TYPE, ABSTRACT_DETAILS ABSTRACT_DETAILS, HDR_ATTR_DISPLAY_SCORE HDR_ATTR_DISPLAY_SCORE, PROGRESS_PAYMENT_TYPE PROGRESS_PAYMENT_TYPE, LINE_MAS_ENABLED_FLAG LINE_MAS_ENABLED_FLAG, HDR_ATTR_ENABLE_WEIGHTS HDR_ATTR_ENABLE_WEIGHTS, AUTO_EXTEND_FLAG AUTO_EXTEND_FLAG, AUTO_EXTEND_NUMBER AUTO_EXTEND_NUMBER, MIN_BID_DECREMENT MIN_BID_DECREMENT, MIN_BID_CHANGE_TYPE MIN_BID_CHANGE_TYPE, PRICE_DRIVEN_AUCTION_FLAG PRICE_DRIVEN_AUCTION_FLAG, AUTO_EXTEND_ALL_LINES_FLAG AUTO_EXTEND_ALL_LINES_FLAG, ALLOW_OTHER_BID_CURRENCY_FLAG ALLOW_OTHER_BID_CURRENCY_FLAG, AUTO_EXTEND_DURATION AUTO_EXTEND_DURATION, SEALED_AUCTION_STATUS SEALED_AUCTION_STATUS, AUTO_EXTEND_TYPE_FLAG AUTO_EXTEND_TYPE_FLAG, SHOW_BIDDER_SCORES SHOW_BIDDER_SCORES, AUCTION_HEADER_ID AUCTION_HEADER_ID, RETAIN_CLAUSE_FLAG RETAIN_CLAUSE_FLAG, UPDATE_CLAUSE_FLAG UPDATE_CLAUSE_FLAG, RETAIN_ATTACHMENTS_FLAG RETAIN_ATTACHMENTS_FLAG, ALLOW_MULTIPLE_ACTIVE_OFFERS ALLOW_MULTIPLE_ACTIVE_OFFERS, ALLOW_UNSOL_OFFER_LINES ALLOW_UNSOL_OFFER_LINES, ALLOW_WITHDRAW_FLAG ALLOW_WITHDRAW_FLAG, AMENDUPDATED_AFTERCDGENERATED AMENDUPDATED_AFTERCDGENERATED, CANCEL_AMENDMENT CANCEL_AMENDMENT, CD_EDITBYUSER_FLAG CD_EDITBYUSER_FLAG, CD_GENERATED_DATE CD_GENERATED_DATE, CD_GENERATED_FLAG CD_GENERATED_FLAG, CHANGEDESCRIPTION_DATA CHANGEDESCRIPTION_DATA, FAIR_OPP_NOTICE_FLAG FAIR_OPP_NOTICE_FLAG, FEDERAL_PUBLICATION_EXCEPTION FEDERAL_PUBLICATION_EXCEPTION, REVISION REVISION, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID, AUCTION_PUBLISHED_FLAG AUCTION_PUBLISHED_FLAG, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_GROUP_ID INTERFACE_GROUP_ID, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME from "PON"."PON_AUCTION_HEADERS_INTERFACE"

View Text - HTML Formatted

SELECT GROUP_BATCH_ID GROUP_BATCH_ID
, BATCH_ID BATCH_ID
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, DOCUMENT_NUMBER DOCUMENT_NUMBER
, AUCTION_TITLE AUCTION_TITLE
, DESCRIPTION DESCRIPTION
, AUCTION_TYPE AUCTION_TYPE
, ORG_ID ORG_ID
, CONTRACT_TYPE CONTRACT_TYPE
, EVENT_ID EVENT_ID
, EVENT_TITLE EVENT_TITLE
, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG
, PO_START_DATE PO_START_DATE
, PO_END_DATE PO_END_DATE
, SHIP_TO_LOCATION_CODE SHIP_TO_LOCATION_CODE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_CODE BILL_TO_LOCATION_CODE
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, CARRIER_CODE CARRIER_CODE
, CURRENCY_CODE CURRENCY_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, PUBLISH_RATES_TO_BIDDERS_FLAG PUBLISH_RATES_TO_BIDDERS_FLAG
, OPEN_BIDDING_DATE OPEN_BIDDING_DATE
, CLOSE_BIDDING_DATE CLOSE_BIDDING_DATE
, VIEW_BY_DATE VIEW_BY_DATE
, AWARD_BY_DATE AWARD_BY_DATE
, PUBLISH_DATE PUBLISH_DATE
, OPEN_AUCTION_NOW_FLAG OPEN_AUCTION_NOW_FLAG
, PUBLISH_AUCTION_NOW_FLAG PUBLISH_AUCTION_NOW_FLAG
, NOTE_TO_BIDDERS NOTE_TO_BIDDERS
, SHOW_BIDDER_NOTES SHOW_BIDDER_NOTES
, BID_VISIBILITY_CODE BID_VISIBILITY_CODE
, BID_SCOPE_CODE BID_SCOPE_CODE
, BID_LIST_TYPE BID_LIST_TYPE
, BID_FREQUENCY_CODE BID_FREQUENCY_CODE
, BID_RANKING BID_RANKING
, RANK_INDICATOR RANK_INDICATOR
, FULL_QUANTITY_BID_CODE FULL_QUANTITY_BID_CODE
, MULTIPLE_ROUNDS_FLAG MULTIPLE_ROUNDS_FLAG
, MANUAL_CLOSE_FLAG MANUAL_CLOSE_FLAG
, MANUAL_EXTEND_FLAG MANUAL_EXTEND_FLAG
, AWARD_APPROVAL_FLAG AWARD_APPROVAL_FLAG
, AUCTION_ORIGINATION_CODE AUCTION_ORIGINATION_CODE
, DOCTYPE_ID DOCTYPE_ID
, BUYER_ID BUYER_ID
, STYLE_ID STYLE_ID
, PO_STYLE_ID PO_STYLE_ID
, ADVANCE_NEGOTIABLE_FLAG ADVANCE_NEGOTIABLE_FLAG
, RECOUPMENT_NEGOTIABLE_FLAG RECOUPMENT_NEGOTIABLE_FLAG
, PROGRESS_PYMT_NEGOTIABLE_FLAG PROGRESS_PYMT_NEGOTIABLE_FLAG
, RETAINAGE_NEGOTIABLE_FLAG RETAINAGE_NEGOTIABLE_FLAG
, MAX_RETAINAGE_NEGOTIABLE_FLAG MAX_RETAINAGE_NEGOTIABLE_FLAG
, SUPPLIER_ENTERABLE_PYMT_FLAG SUPPLIER_ENTERABLE_PYMT_FLAG
, TWO_PART_FLAG TWO_PART_FLAG
, PROJECT_ID PROJECT_ID
, PF_TYPE_ALLOWED PF_TYPE_ALLOWED
, PRICE_BREAK_RESPONSE PRICE_BREAK_RESPONSE
, PRICE_TIERS_INDICATOR PRICE_TIERS_INDICATOR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, INT_ATTRIBUTE_CATEGORY INT_ATTRIBUTE_CATEGORY
, INT_ATTRIBUTE1 INT_ATTRIBUTE1
, INT_ATTRIBUTE2 INT_ATTRIBUTE2
, INT_ATTRIBUTE3 INT_ATTRIBUTE3
, INT_ATTRIBUTE4 INT_ATTRIBUTE4
, INT_ATTRIBUTE5 INT_ATTRIBUTE5
, INT_ATTRIBUTE6 INT_ATTRIBUTE6
, INT_ATTRIBUTE7 INT_ATTRIBUTE7
, INT_ATTRIBUTE8 INT_ATTRIBUTE8
, INT_ATTRIBUTE9 INT_ATTRIBUTE9
, INT_ATTRIBUTE10 INT_ATTRIBUTE10
, INT_ATTRIBUTE11 INT_ATTRIBUTE11
, INT_ATTRIBUTE12 INT_ATTRIBUTE12
, INT_ATTRIBUTE13 INT_ATTRIBUTE13
, INT_ATTRIBUTE14 INT_ATTRIBUTE14
, INT_ATTRIBUTE15 INT_ATTRIBUTE15
, EXT_ATTRIBUTE_CATEGORY EXT_ATTRIBUTE_CATEGORY
, EXT_ATTRIBUTE1 EXT_ATTRIBUTE1
, EXT_ATTRIBUTE2 EXT_ATTRIBUTE2
, EXT_ATTRIBUTE3 EXT_ATTRIBUTE3
, EXT_ATTRIBUTE4 EXT_ATTRIBUTE4
, EXT_ATTRIBUTE5 EXT_ATTRIBUTE5
, EXT_ATTRIBUTE6 EXT_ATTRIBUTE6
, EXT_ATTRIBUTE7 EXT_ATTRIBUTE7
, EXT_ATTRIBUTE8 EXT_ATTRIBUTE8
, EXT_ATTRIBUTE9 EXT_ATTRIBUTE9
, EXT_ATTRIBUTE10 EXT_ATTRIBUTE10
, EXT_ATTRIBUTE11 EXT_ATTRIBUTE11
, EXT_ATTRIBUTE12 EXT_ATTRIBUTE12
, EXT_ATTRIBUTE13 EXT_ATTRIBUTE13
, EXT_ATTRIBUTE14 EXT_ATTRIBUTE14
, EXT_ATTRIBUTE15 EXT_ATTRIBUTE15
, EFFECTIVE_DATE EFFECTIVE_DATE
, SIGNED_DATE SIGNED_DATE
, AMENDMENT_FLAG AMENDMENT_FLAG
, SOLICITATION_TYPE SOLICITATION_TYPE
, UDA_TEMPLATE_ID UDA_TEMPLATE_ID
, UDA_TEMPLATE_DATE UDA_TEMPLATE_DATE
, NO_OF_COPIES NO_OF_COPIES
, PO_STYLE_NAME PO_STYLE_NAME
, AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION
, STANDARD_FORM STANDARD_FORM
, DOCUMENT_FORMAT DOCUMENT_FORMAT
, AUTO_EXTEND_MIN_TRIGGER_RANK AUTO_EXTEND_MIN_TRIGGER_RANK
, ENFORCE_PREVRND_BID_PRICE_FLAG ENFORCE_PREVRND_BID_PRICE_FLAG
, STAGGERED_CLOSING_INTERVAL STAGGERED_CLOSING_INTERVAL
, FIRST_LINE_CLOSE_DATE FIRST_LINE_CLOSE_DATE
, DISPLAY_BEST_PRICE_BLIND_FLAG DISPLAY_BEST_PRICE_BLIND_FLAG
, BID_DECREMENT_METHOD BID_DECREMENT_METHOD
, SUPPLIER_VIEW_TYPE SUPPLIER_VIEW_TYPE
, ABSTRACT_DETAILS ABSTRACT_DETAILS
, HDR_ATTR_DISPLAY_SCORE HDR_ATTR_DISPLAY_SCORE
, PROGRESS_PAYMENT_TYPE PROGRESS_PAYMENT_TYPE
, LINE_MAS_ENABLED_FLAG LINE_MAS_ENABLED_FLAG
, HDR_ATTR_ENABLE_WEIGHTS HDR_ATTR_ENABLE_WEIGHTS
, AUTO_EXTEND_FLAG AUTO_EXTEND_FLAG
, AUTO_EXTEND_NUMBER AUTO_EXTEND_NUMBER
, MIN_BID_DECREMENT MIN_BID_DECREMENT
, MIN_BID_CHANGE_TYPE MIN_BID_CHANGE_TYPE
, PRICE_DRIVEN_AUCTION_FLAG PRICE_DRIVEN_AUCTION_FLAG
, AUTO_EXTEND_ALL_LINES_FLAG AUTO_EXTEND_ALL_LINES_FLAG
, ALLOW_OTHER_BID_CURRENCY_FLAG ALLOW_OTHER_BID_CURRENCY_FLAG
, AUTO_EXTEND_DURATION AUTO_EXTEND_DURATION
, SEALED_AUCTION_STATUS SEALED_AUCTION_STATUS
, AUTO_EXTEND_TYPE_FLAG AUTO_EXTEND_TYPE_FLAG
, SHOW_BIDDER_SCORES SHOW_BIDDER_SCORES
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, RETAIN_CLAUSE_FLAG RETAIN_CLAUSE_FLAG
, UPDATE_CLAUSE_FLAG UPDATE_CLAUSE_FLAG
, RETAIN_ATTACHMENTS_FLAG RETAIN_ATTACHMENTS_FLAG
, ALLOW_MULTIPLE_ACTIVE_OFFERS ALLOW_MULTIPLE_ACTIVE_OFFERS
, ALLOW_UNSOL_OFFER_LINES ALLOW_UNSOL_OFFER_LINES
, ALLOW_WITHDRAW_FLAG ALLOW_WITHDRAW_FLAG
, AMENDUPDATED_AFTERCDGENERATED AMENDUPDATED_AFTERCDGENERATED
, CANCEL_AMENDMENT CANCEL_AMENDMENT
, CD_EDITBYUSER_FLAG CD_EDITBYUSER_FLAG
, CD_GENERATED_DATE CD_GENERATED_DATE
, CD_GENERATED_FLAG CD_GENERATED_FLAG
, CHANGEDESCRIPTION_DATA CHANGEDESCRIPTION_DATA
, FAIR_OPP_NOTICE_FLAG FAIR_OPP_NOTICE_FLAG
, FEDERAL_PUBLICATION_EXCEPTION FEDERAL_PUBLICATION_EXCEPTION
, REVISION REVISION
, UMBRELLA_PROGRAM_ID UMBRELLA_PROGRAM_ID
, AUCTION_PUBLISHED_FLAG AUCTION_PUBLISHED_FLAG
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_GROUP_ID INTERFACE_GROUP_ID
, TRADING_PARTNER_CONTACT_NAME TRADING_PARTNER_CONTACT_NAME
FROM "PON"."PON_AUCTION_HEADERS_INTERFACE"