[Home] [Help] [Dependency Information]
Object Name: | PON_OPTIMIZE_CONSTRAINTS# |
---|---|
Object Type: | VIEW |
Owner: | PON |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCENARIO_ID | NUMBER | Yes | ||
SEQUENCE_NUMBER | NUMBER | Yes | ||
AUCTION_HEADER_ID | NUMBER | Yes | ||
CONSTRAINT_TYPE | VARCHAR2 | (30) | Yes | |
LINE_NUMBER | NUMBER | |||
MIN_AMOUNT | NUMBER | |||
MAX_AMOUNT | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (25) | ||
MIN_QUANTITY | NUMBER | |||
MAX_QUANTITY | NUMBER | |||
QUANTITY_CUTOFF | NUMBER | |||
PRICE_CUTOFF | NUMBER | |||
SPLIT_AWARD_FLAG | VARCHAR2 | (1) | ||
INTEGRAL_QTY_AWARD_FLAG | VARCHAR2 | (1) | ||
EXCLUDED_FLAG | VARCHAR2 | (1) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
MIN_SCORE | NUMBER | |||
SUPP_CLASSIFICATION | VARCHAR2 | (25) | ||
ATTR_SEQUENCE_NUMBER | NUMBER | |||
ATTR_GROUP_NAME | VARCHAR2 | (240) | ||
TRADING_PARTNER_ID | NUMBER | |||
TRADING_PARTNER_CONTACT_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
MIN_MAX_AMOUNT_PRIORITY | VARCHAR2 | (30) | ||
MIN_MAX_AMOUNT_COST | NUMBER | |||
MIN_MAX_AMOUNT_INFEAS_FLAG | VARCHAR2 | (1) | ||
MIN_MAX_QUANTITY_PRIORITY | VARCHAR2 | (30) | ||
MIN_MAX_QUANTITY_COST | NUMBER | |||
MIN_MAX_QUANTITY_INFEAS_FLAG | VARCHAR2 | (1) | ||
QUANTITY_CUTOFF_PRIORITY | VARCHAR2 | (30) | ||
QUANTITY_CUTOFF_COST | NUMBER | |||
QUANTITY_CUTOFF_INFEAS_FLAG | VARCHAR2 | (1) | ||
PRICE_CUTOFF_PRIORITY | VARCHAR2 | (30) | ||
PRICE_CUTOFF_COST | NUMBER | |||
PRICE_CUTOFF_INFEAS_FLAG | VARCHAR2 | (1) | ||
SPLIT_AWARD_PRIORITY | VARCHAR2 | (30) | ||
SPLIT_AWARD_INFEAS_FLAG | VARCHAR2 | (1) | ||
SPLIT_AWARD_COST | NUMBER | |||
INTEGRAL_QTY_AWARD_PRIORITY | VARCHAR2 | (30) | ||
INTEGRAL_QTY_AWARD_INFEAS_FLAG | VARCHAR2 | (1) | ||
INTEGRAL_QTY_AWARD_COST | NUMBER | |||
EXCLUDED_SUPPLIER_PRIORITY | VARCHAR2 | (30) | ||
EXCLUDED_SUPPLIER_INFEAS_FLAG | VARCHAR2 | (1) | ||
EXCLUDED_SUPPLIER_COST | NUMBER | |||
PROMISED_DATE_PRIORITY | VARCHAR2 | (30) | ||
PROMISED_DATE_COST | NUMBER | |||
PROMISED_DATE_INFEAS_FLAG | VARCHAR2 | (1) | ||
MIN_SCORE_PRIORITY | VARCHAR2 | (30) | ||
MIN_SCORE_COST | NUMBER | |||
MIN_SCORE_INFEAS_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SCENARIO_ID
, SEQUENCE_NUMBER
, AUCTION_HEADER_ID
, CONSTRAINT_TYPE
, LINE_NUMBER
, MIN_AMOUNT
, MAX_AMOUNT
, AMOUNT_TYPE
, MIN_QUANTITY
, MAX_QUANTITY
, QUANTITY_CUTOFF
, PRICE_CUTOFF
, SPLIT_AWARD_FLAG
, INTEGRAL_QTY_AWARD_FLAG
, EXCLUDED_FLAG
, FROM_DATE
, TO_DATE
, MIN_SCORE
, SUPP_CLASSIFICATION
, ATTR_SEQUENCE_NUMBER
, ATTR_GROUP_NAME
, TRADING_PARTNER_ID
, TRADING_PARTNER_CONTACT_ID
, VENDOR_SITE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, MIN_MAX_AMOUNT_PRIORITY
, MIN_MAX_AMOUNT_COST
, MIN_MAX_AMOUNT_INFEAS_FLAG
, MIN_MAX_QUANTITY_PRIORITY
, MIN_MAX_QUANTITY_COST
, MIN_MAX_QUANTITY_INFEAS_FLAG
, QUANTITY_CUTOFF_PRIORITY
, QUANTITY_CUTOFF_COST
, QUANTITY_CUTOFF_INFEAS_FLAG
, PRICE_CUTOFF_PRIORITY
, PRICE_CUTOFF_COST
, PRICE_CUTOFF_INFEAS_FLAG
, SPLIT_AWARD_PRIORITY
, SPLIT_AWARD_INFEAS_FLAG
, SPLIT_AWARD_COST
, INTEGRAL_QTY_AWARD_PRIORITY
, INTEGRAL_QTY_AWARD_INFEAS_FLAG
, INTEGRAL_QTY_AWARD_COST
, EXCLUDED_SUPPLIER_PRIORITY
, EXCLUDED_SUPPLIER_INFEAS_FLAG
, EXCLUDED_SUPPLIER_COST
, PROMISED_DATE_PRIORITY
, PROMISED_DATE_COST
, PROMISED_DATE_INFEAS_FLAG
, MIN_SCORE_PRIORITY
, MIN_SCORE_COST
, MIN_SCORE_INFEAS_FLAG
FROM PON.PON_OPTIMIZE_CONSTRAINTS#;
|
|
|