VIEW: PON.PON_OPTIMIZE_CONSTRAINTS#

Source

View Text - Preformatted

select SCENARIO_ID SCENARIO_ID, SEQUENCE_NUMBER SEQUENCE_NUMBER, AUCTION_HEADER_ID AUCTION_HEADER_ID, CONSTRAINT_TYPE CONSTRAINT_TYPE, LINE_NUMBER LINE_NUMBER, MIN_AMOUNT MIN_AMOUNT, MAX_AMOUNT MAX_AMOUNT, AMOUNT_TYPE AMOUNT_TYPE, MIN_QUANTITY MIN_QUANTITY, MAX_QUANTITY MAX_QUANTITY, QUANTITY_CUTOFF QUANTITY_CUTOFF, PRICE_CUTOFF PRICE_CUTOFF, SPLIT_AWARD_FLAG SPLIT_AWARD_FLAG, INTEGRAL_QTY_AWARD_FLAG INTEGRAL_QTY_AWARD_FLAG, EXCLUDED_FLAG EXCLUDED_FLAG, FROM_DATE FROM_DATE, TO_DATE TO_DATE, MIN_SCORE MIN_SCORE, SUPP_CLASSIFICATION SUPP_CLASSIFICATION, ATTR_SEQUENCE_NUMBER ATTR_SEQUENCE_NUMBER, ATTR_GROUP_NAME ATTR_GROUP_NAME, TRADING_PARTNER_ID TRADING_PARTNER_ID, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID, VENDOR_SITE_ID VENDOR_SITE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MIN_MAX_AMOUNT_PRIORITY MIN_MAX_AMOUNT_PRIORITY, MIN_MAX_AMOUNT_COST MIN_MAX_AMOUNT_COST, MIN_MAX_AMOUNT_INFEAS_FLAG MIN_MAX_AMOUNT_INFEAS_FLAG, MIN_MAX_QUANTITY_PRIORITY MIN_MAX_QUANTITY_PRIORITY, MIN_MAX_QUANTITY_COST MIN_MAX_QUANTITY_COST, MIN_MAX_QUANTITY_INFEAS_FLAG MIN_MAX_QUANTITY_INFEAS_FLAG, QUANTITY_CUTOFF_PRIORITY QUANTITY_CUTOFF_PRIORITY, QUANTITY_CUTOFF_COST QUANTITY_CUTOFF_COST, QUANTITY_CUTOFF_INFEAS_FLAG QUANTITY_CUTOFF_INFEAS_FLAG, PRICE_CUTOFF_PRIORITY PRICE_CUTOFF_PRIORITY, PRICE_CUTOFF_COST PRICE_CUTOFF_COST, PRICE_CUTOFF_INFEAS_FLAG PRICE_CUTOFF_INFEAS_FLAG, SPLIT_AWARD_PRIORITY SPLIT_AWARD_PRIORITY, SPLIT_AWARD_INFEAS_FLAG SPLIT_AWARD_INFEAS_FLAG, SPLIT_AWARD_COST SPLIT_AWARD_COST, INTEGRAL_QTY_AWARD_PRIORITY INTEGRAL_QTY_AWARD_PRIORITY, INTEGRAL_QTY_AWARD_INFEAS_FLAG INTEGRAL_QTY_AWARD_INFEAS_FLAG, INTEGRAL_QTY_AWARD_COST INTEGRAL_QTY_AWARD_COST, EXCLUDED_SUPPLIER_PRIORITY EXCLUDED_SUPPLIER_PRIORITY, EXCLUDED_SUPPLIER_INFEAS_FLAG EXCLUDED_SUPPLIER_INFEAS_FLAG, EXCLUDED_SUPPLIER_COST EXCLUDED_SUPPLIER_COST, PROMISED_DATE_PRIORITY PROMISED_DATE_PRIORITY, PROMISED_DATE_COST PROMISED_DATE_COST, PROMISED_DATE_INFEAS_FLAG PROMISED_DATE_INFEAS_FLAG, MIN_SCORE_PRIORITY MIN_SCORE_PRIORITY, MIN_SCORE_COST MIN_SCORE_COST, MIN_SCORE_INFEAS_FLAG MIN_SCORE_INFEAS_FLAG from "PON"."PON_OPTIMIZE_CONSTRAINTS"

View Text - HTML Formatted

SELECT SCENARIO_ID SCENARIO_ID
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, CONSTRAINT_TYPE CONSTRAINT_TYPE
, LINE_NUMBER LINE_NUMBER
, MIN_AMOUNT MIN_AMOUNT
, MAX_AMOUNT MAX_AMOUNT
, AMOUNT_TYPE AMOUNT_TYPE
, MIN_QUANTITY MIN_QUANTITY
, MAX_QUANTITY MAX_QUANTITY
, QUANTITY_CUTOFF QUANTITY_CUTOFF
, PRICE_CUTOFF PRICE_CUTOFF
, SPLIT_AWARD_FLAG SPLIT_AWARD_FLAG
, INTEGRAL_QTY_AWARD_FLAG INTEGRAL_QTY_AWARD_FLAG
, EXCLUDED_FLAG EXCLUDED_FLAG
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, MIN_SCORE MIN_SCORE
, SUPP_CLASSIFICATION SUPP_CLASSIFICATION
, ATTR_SEQUENCE_NUMBER ATTR_SEQUENCE_NUMBER
, ATTR_GROUP_NAME ATTR_GROUP_NAME
, TRADING_PARTNER_ID TRADING_PARTNER_ID
, TRADING_PARTNER_CONTACT_ID TRADING_PARTNER_CONTACT_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MIN_MAX_AMOUNT_PRIORITY MIN_MAX_AMOUNT_PRIORITY
, MIN_MAX_AMOUNT_COST MIN_MAX_AMOUNT_COST
, MIN_MAX_AMOUNT_INFEAS_FLAG MIN_MAX_AMOUNT_INFEAS_FLAG
, MIN_MAX_QUANTITY_PRIORITY MIN_MAX_QUANTITY_PRIORITY
, MIN_MAX_QUANTITY_COST MIN_MAX_QUANTITY_COST
, MIN_MAX_QUANTITY_INFEAS_FLAG MIN_MAX_QUANTITY_INFEAS_FLAG
, QUANTITY_CUTOFF_PRIORITY QUANTITY_CUTOFF_PRIORITY
, QUANTITY_CUTOFF_COST QUANTITY_CUTOFF_COST
, QUANTITY_CUTOFF_INFEAS_FLAG QUANTITY_CUTOFF_INFEAS_FLAG
, PRICE_CUTOFF_PRIORITY PRICE_CUTOFF_PRIORITY
, PRICE_CUTOFF_COST PRICE_CUTOFF_COST
, PRICE_CUTOFF_INFEAS_FLAG PRICE_CUTOFF_INFEAS_FLAG
, SPLIT_AWARD_PRIORITY SPLIT_AWARD_PRIORITY
, SPLIT_AWARD_INFEAS_FLAG SPLIT_AWARD_INFEAS_FLAG
, SPLIT_AWARD_COST SPLIT_AWARD_COST
, INTEGRAL_QTY_AWARD_PRIORITY INTEGRAL_QTY_AWARD_PRIORITY
, INTEGRAL_QTY_AWARD_INFEAS_FLAG INTEGRAL_QTY_AWARD_INFEAS_FLAG
, INTEGRAL_QTY_AWARD_COST INTEGRAL_QTY_AWARD_COST
, EXCLUDED_SUPPLIER_PRIORITY EXCLUDED_SUPPLIER_PRIORITY
, EXCLUDED_SUPPLIER_INFEAS_FLAG EXCLUDED_SUPPLIER_INFEAS_FLAG
, EXCLUDED_SUPPLIER_COST EXCLUDED_SUPPLIER_COST
, PROMISED_DATE_PRIORITY PROMISED_DATE_PRIORITY
, PROMISED_DATE_COST PROMISED_DATE_COST
, PROMISED_DATE_INFEAS_FLAG PROMISED_DATE_INFEAS_FLAG
, MIN_SCORE_PRIORITY MIN_SCORE_PRIORITY
, MIN_SCORE_COST MIN_SCORE_COST
, MIN_SCORE_INFEAS_FLAG MIN_SCORE_INFEAS_FLAG
FROM "PON"."PON_OPTIMIZE_CONSTRAINTS"