VIEW: PON.PON_AUCTION_TEMPLATES#

Source

View Text - Preformatted

select NAME NAME, DESCRIPTION DESCRIPTION, TEMPLATE_ID TEMPLATE_ID, TEMPLATE_TYPE TEMPLATE_TYPE, STATUS STATUS, SCOPE SCOPE, STATUS_DSP STATUS_DSP, AUCTION_TYPE AUCTION_TYPE, AUCTION_DURATION AUCTION_DURATION, AUCTION_DURATION_UNIT AUCTION_DURATION_UNIT, BID_VISIBILITY_CODE BID_VISIBILITY_CODE, BID_LIST_TYPE BID_LIST_TYPE, BID_FREQUENCY_CODE BID_FREQUENCY_CODE, BID_SCOPE_CODE BID_SCOPE_CODE, CURRENCY_CODE CURRENCY_CODE, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, PAYMENT_TERMS_CODE PAYMENT_TERMS_CODE, PAYMENT_TERMS PAYMENT_TERMS, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE, FREIGHT_TERMS FREIGHT_TERMS, CARRIER_CODE CARRIER_CODE, CARRIER CARRIER, FOB_CODE FOB_CODE, FOB FOB, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS, NOTE_TO_BIDDERS NOTE_TO_BIDDERS, CONTRACT_TYPE CONTRACT_TYPE, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID, ATTACHMENT_FLAG ATTACHMENT_FLAG, AUTO_EXTEND_FLAG AUTO_EXTEND_FLAG, AUTO_EXTEND_NUMBER AUTO_EXTEND_NUMBER, PRICE_DRIVEN_AUCTION_FLAG PRICE_DRIVEN_AUCTION_FLAG, MIN_BID_DECREMENT MIN_BID_DECREMENT, 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, TIME_ZONE TIME_ZONE, NUMBER_OF_EXTENSIONS NUMBER_OF_EXTENSIONS, NUMBER_OF_BIDS NUMBER_OF_BIDS, LANGUAGE_CODE LANGUAGE_CODE, RATE_TYPE RATE_TYPE, RATE_DATE RATE_DATE, RATE RATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, TRADING_PARTNER_NAME_UPPER TRADING_PARTNER_NAME_UPPER, AUTO_EXTEND_ALL_LINES_FLAG AUTO_EXTEND_ALL_LINES_FLAG, AUTO_EXTEND_DURATION AUTO_EXTEND_DURATION, PROXY_BID_ALLOWED_FLAG PROXY_BID_ALLOWED_FLAG, PUBLISH_RATES_TO_BIDDERS_FLAG PUBLISH_RATES_TO_BIDDERS_FLAG, MIN_BID_INCREMENT MIN_BID_INCREMENT, ALLOW_OTHER_BID_CURRENCY_FLAG ALLOW_OTHER_BID_CURRENCY_FLAG, SHIPPING_TERMS_CODE SHIPPING_TERMS_CODE, SHIPPING_TERMS SHIPPING_TERMS, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SHIPPING_METHOD SHIPPING_METHOD, ATTRIBUTES_EXIST ATTRIBUTES_EXIST, OPEN_AUCTION_IMMEDIATELY_FLAG OPEN_AUCTION_IMMEDIATELY_FLAG, CATEGORY_ID CATEGORY_ID, CATEGORY_NAME CATEGORY_NAME, FULL_QUANTITY_BID_CODE FULL_QUANTITY_BID_CODE, MIN_BID_CHANGE_TYPE MIN_BID_CHANGE_TYPE, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, MODE_OF_TRANSPORT_CODE MODE_OF_TRANSPORT_CODE, AUTO_EXTEND_TYPE_FLAG AUTO_EXTEND_TYPE_FLAG, MULTIPLE_ROUNDS_FLAG MULTIPLE_ROUNDS_FLAG, DOCTYPE_ID DOCTYPE_ID, OFFER_TYPE OFFER_TYPE, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, MAX_RESPONSES MAX_RESPONSES, MAX_RESPONSE_ITERATIONS MAX_RESPONSE_ITERATIONS, PO_AGREED_AMOUNT PO_AGREED_AMOUNT, RESPONSE_ALLOWED_FLAG RESPONSE_ALLOWED_FLAG, FOB_NEG_FLAG FOB_NEG_FLAG, CARRIER_NEG_FLAG CARRIER_NEG_FLAG, FREIGHT_TERMS_NEG_FLAG FREIGHT_TERMS_NEG_FLAG, PAYMENT_TERMS_NEG_FLAG PAYMENT_TERMS_NEG_FLAG, MODE_OF_TRANSPORT_NEG_FLAG MODE_OF_TRANSPORT_NEG_FLAG, MANUAL_CLOSE_FLAG MANUAL_CLOSE_FLAG, MANUAL_EXTEND_FLAG MANUAL_EXTEND_FLAG, AUTOEXTEND_CHANGED_FLAG AUTOEXTEND_CHANGED_FLAG, SHIPPING_METHOD_NEG_FLAG SHIPPING_METHOD_NEG_FLAG, SHIPPING_TERMS_NEG_FLAG SHIPPING_TERMS_NEG_FLAG, USE_REGIONAL_PRICING_FLAG USE_REGIONAL_PRICING_FLAG, SHOW_BIDDER_NOTES SHOW_BIDDER_NOTES, BID_RANKING BID_RANKING, RANK_INDICATOR RANK_INDICATOR, SHOW_BIDDER_SCORES SHOW_BIDDER_SCORES, HAS_PRICE_ELEMENTS_FLAG HAS_PRICE_ELEMENTS_FLAG, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE from "PON"."PON_AUCTION_TEMPLATES"

View Text - HTML Formatted

SELECT NAME NAME
, DESCRIPTION DESCRIPTION
, TEMPLATE_ID TEMPLATE_ID
, TEMPLATE_TYPE TEMPLATE_TYPE
, STATUS STATUS
, SCOPE SCOPE
, STATUS_DSP STATUS_DSP
, AUCTION_TYPE AUCTION_TYPE
, AUCTION_DURATION AUCTION_DURATION
, AUCTION_DURATION_UNIT AUCTION_DURATION_UNIT
, BID_VISIBILITY_CODE BID_VISIBILITY_CODE
, BID_LIST_TYPE BID_LIST_TYPE
, BID_FREQUENCY_CODE BID_FREQUENCY_CODE
, BID_SCOPE_CODE BID_SCOPE_CODE
, CURRENCY_CODE CURRENCY_CODE
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, PAYMENT_TERMS_CODE PAYMENT_TERMS_CODE
, PAYMENT_TERMS PAYMENT_TERMS
, FREIGHT_TERMS_CODE#1 FREIGHT_TERMS_CODE
, FREIGHT_TERMS FREIGHT_TERMS
, CARRIER_CODE CARRIER_CODE
, CARRIER CARRIER
, FOB_CODE FOB_CODE
, FOB FOB
, NUMBER_PRICE_DECIMALS NUMBER_PRICE_DECIMALS
, NOTE_TO_BIDDERS NOTE_TO_BIDDERS
, CONTRACT_TYPE CONTRACT_TYPE
, SHIP_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID BILL_TO_LOCATION_ID
, ATTACHMENT_FLAG ATTACHMENT_FLAG
, AUTO_EXTEND_FLAG AUTO_EXTEND_FLAG
, AUTO_EXTEND_NUMBER AUTO_EXTEND_NUMBER
, PRICE_DRIVEN_AUCTION_FLAG PRICE_DRIVEN_AUCTION_FLAG
, MIN_BID_DECREMENT MIN_BID_DECREMENT
, 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
, TIME_ZONE TIME_ZONE
, NUMBER_OF_EXTENSIONS NUMBER_OF_EXTENSIONS
, NUMBER_OF_BIDS NUMBER_OF_BIDS
, LANGUAGE_CODE LANGUAGE_CODE
, RATE_TYPE RATE_TYPE
, RATE_DATE RATE_DATE
, RATE RATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, TRADING_PARTNER_NAME_UPPER TRADING_PARTNER_NAME_UPPER
, AUTO_EXTEND_ALL_LINES_FLAG AUTO_EXTEND_ALL_LINES_FLAG
, AUTO_EXTEND_DURATION AUTO_EXTEND_DURATION
, PROXY_BID_ALLOWED_FLAG PROXY_BID_ALLOWED_FLAG
, PUBLISH_RATES_TO_BIDDERS_FLAG PUBLISH_RATES_TO_BIDDERS_FLAG
, MIN_BID_INCREMENT MIN_BID_INCREMENT
, ALLOW_OTHER_BID_CURRENCY_FLAG ALLOW_OTHER_BID_CURRENCY_FLAG
, SHIPPING_TERMS_CODE SHIPPING_TERMS_CODE
, SHIPPING_TERMS SHIPPING_TERMS
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SHIPPING_METHOD SHIPPING_METHOD
, ATTRIBUTES_EXIST ATTRIBUTES_EXIST
, OPEN_AUCTION_IMMEDIATELY_FLAG OPEN_AUCTION_IMMEDIATELY_FLAG
, CATEGORY_ID CATEGORY_ID
, CATEGORY_NAME CATEGORY_NAME
, FULL_QUANTITY_BID_CODE FULL_QUANTITY_BID_CODE
, MIN_BID_CHANGE_TYPE MIN_BID_CHANGE_TYPE
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, MODE_OF_TRANSPORT_CODE MODE_OF_TRANSPORT_CODE
, AUTO_EXTEND_TYPE_FLAG AUTO_EXTEND_TYPE_FLAG
, MULTIPLE_ROUNDS_FLAG MULTIPLE_ROUNDS_FLAG
, DOCTYPE_ID DOCTYPE_ID
, OFFER_TYPE OFFER_TYPE
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, MAX_RESPONSES MAX_RESPONSES
, MAX_RESPONSE_ITERATIONS MAX_RESPONSE_ITERATIONS
, PO_AGREED_AMOUNT PO_AGREED_AMOUNT
, RESPONSE_ALLOWED_FLAG RESPONSE_ALLOWED_FLAG
, FOB_NEG_FLAG FOB_NEG_FLAG
, CARRIER_NEG_FLAG CARRIER_NEG_FLAG
, FREIGHT_TERMS_NEG_FLAG FREIGHT_TERMS_NEG_FLAG
, PAYMENT_TERMS_NEG_FLAG PAYMENT_TERMS_NEG_FLAG
, MODE_OF_TRANSPORT_NEG_FLAG MODE_OF_TRANSPORT_NEG_FLAG
, MANUAL_CLOSE_FLAG MANUAL_CLOSE_FLAG
, MANUAL_EXTEND_FLAG MANUAL_EXTEND_FLAG
, AUTOEXTEND_CHANGED_FLAG AUTOEXTEND_CHANGED_FLAG
, SHIPPING_METHOD_NEG_FLAG SHIPPING_METHOD_NEG_FLAG
, SHIPPING_TERMS_NEG_FLAG SHIPPING_TERMS_NEG_FLAG
, USE_REGIONAL_PRICING_FLAG USE_REGIONAL_PRICING_FLAG
, SHOW_BIDDER_NOTES SHOW_BIDDER_NOTES
, BID_RANKING BID_RANKING
, RANK_INDICATOR RANK_INDICATOR
, SHOW_BIDDER_SCORES SHOW_BIDDER_SCORES
, HAS_PRICE_ELEMENTS_FLAG HAS_PRICE_ELEMENTS_FLAG
, PO_MIN_REL_AMOUNT PO_MIN_REL_AMOUNT
, GLOBAL_AGREEMENT_FLAG GLOBAL_AGREEMENT_FLAG
, SECURITY_LEVEL_CODE SECURITY_LEVEL_CODE
FROM "PON"."PON_AUCTION_TEMPLATES"