eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PON.PON_OPTIMIZE_CONSTRAINTS

Object Details

Object Name:	PON_OPTIMIZE_CONSTRAINTS
Object Type:	TABLE
Owner:	PON
FND Design Data:	PON.PON_OPTIMIZE_CONSTRAINTS
Subobject Name:
Status:	VALID

PON_OPTIMIZE_CONSTRAINTS stores information about the user created constraints

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_OPTIMIZE_CONSTRAINTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCENARIO_ID SEQUENCE_NUMBER
PON_OPTIMIZE_CONSTRAINTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SCENARIO_ID CONSTRAINT_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
SCENARIO_ID	NUMBER		Yes	Identifies the scenario to which this constraint belongs
SEQUENCE_NUMBER	NUMBER		Yes	Tracks the order in which the constraints were created
AUCTION_HEADER_ID	NUMBER		Yes	The auction of which this constraint is a part
CONSTRAINT_TYPE	VARCHAR2	(30)	Yes	Type of constraint
LINE_NUMBER	NUMBER			Line number the constraint applies to
MIN_AMOUNT	NUMBER			Minimum amount
MAX_AMOUNT	NUMBER			Maximum amount
AMOUNT_TYPE	VARCHAR2	(25)		Type the min/max amount is specified in - Amount or Percentage
MIN_QUANTITY	NUMBER			Minimum Quantity
MAX_QUANTITY	NUMBER			Maximum Quantity
QUANTITY_CUTOFF	NUMBER			Minimum Quantity for the line level constraints
PRICE_CUTOFF	NUMBER			Maximum price cutoff for line level constraints
SPLIT_AWARD_FLAG	VARCHAR2	(1)		Whether to split award on line
INTEGRAL_QTY_AWARD_FLAG	VARCHAR2	(1)		Stores whether to allow non-integer award on line
EXCLUDED_FLAG	VARCHAR2	(1)		whether to exclude suppliers on PO Hold
FROM_DATE	DATE			From Promise date on line level constraint
TO_DATE	DATE			To Promise date on line level constraint
MIN_SCORE	NUMBER			Minimum attribute (weighted) score cutoff; header or line
SUPP_CLASSIFICATION	VARCHAR2	(25)		Holds the business classification or ASL status
ATTR_SEQUENCE_NUMBER	NUMBER			Identifies the header attribute on which constraint is applied
ATTR_GROUP_NAME	VARCHAR2	(240)		Identifies the header attribute group on which constraint is applied
TRADING_PARTNER_ID	NUMBER			Supplier company on which contraint is applied
TRADING_PARTNER_CONTACT_ID	NUMBER			Supplier company contact on which the constraint is applied
VENDOR_SITE_ID	NUMBER			supplier site on which contraint is applied
CREATION_DATE	DATE			Standard WHO column
CREATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_DATE	DATE			Standard WHO column
LAST_UPDATED_BY	NUMBER			Standard WHO column
LAST_UPDATE_LOGIN	NUMBER			Standard WHO column
MIN_MAX_AMOUNT_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in MIN_AMOUNT and MAX_AMOUNT columns
MIN_MAX_AMOUNT_COST	NUMBER			Cost of constraint value for constraint stored in MIN_AMOUNT and MAX_AMOUNT columns
MIN_MAX_AMOUNT_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in MIN_AMOUNT and MAX_AMOUNT columns was satisfied or not.
MIN_MAX_QUANTITY_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in MIN_QUANTITY and MAX_QUANTITY columns
MIN_MAX_QUANTITY_COST	NUMBER			Cost of constraint value for constraint stored in MIN_QUANTITY and MAX_QUANTITY columns
MIN_MAX_QUANTITY_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in MIN_QUANTITY and MAX_QUANTITY columns was satisfied or not.
QUANTITY_CUTOFF_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in QUANTITY_CUTOFF column
QUANTITY_CUTOFF_COST	NUMBER			Cost of constraint value for constraint stored in QUANTITY_CUTOFF column
QUANTITY_CUTOFF_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in QUANTITY_CUTOFF column was satisfied or not.
PRICE_CUTOFF_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in PRICE_CUTOFF column
PRICE_CUTOFF_COST	NUMBER			Cost of constraint value for constraint stored in PRICE_CUTOFF column
PRICE_CUTOFF_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in PRICE_CUTOFF column was satisfied or not.
SPLIT_AWARD_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in SPLIT_AWARD_FLAG column
SPLIT_AWARD_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in SPLIT_AWARD_FLAG column was satisfied or not.
SPLIT_AWARD_COST	NUMBER			Cost of constraint value for constraint stored in SPLIT_AWARD_FLAG column
INTEGRAL_QTY_AWARD_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in INTEGRAL_QTY_AWARD_FLAG
INTEGRAL_QTY_AWARD_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in INTEGRAL_QTY_AWARD_FLAG column was satisfied or not.
INTEGRAL_QTY_AWARD_COST	NUMBER			Cost of constraint value for constraint stored in INTEGRAL_QTY_AWARD_FLAG column
EXCLUDED_SUPPLIER_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in EXCLUDED_FLAG column
EXCLUDED_SUPPLIER_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in EXCLUDED_FLAG column was satisfied or not.
EXCLUDED_SUPPLIER_COST	NUMBER			Cost of constraint value for constraint stored in EXCLUDED_FLAG column
PROMISED_DATE_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in FROM_DATE and TO_DATE columns
PROMISED_DATE_COST	NUMBER			Cost of constraint value for constraint stored in FROM_DATE and TO_DATE columns
PROMISED_DATE_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in FROM_DATE and TO_DATE columns was satisfied or not.
MIN_SCORE_PRIORITY	VARCHAR2	(30)		Priority of constraint value for constraint stored in MIN_SCORE column
MIN_SCORE_COST	NUMBER			Cost of constraint value for constraint stored in MIN_SCORE column
MIN_SCORE_INFEAS_FLAG	VARCHAR2	(1)		Flag to indicate whether constraint stored in MIN_SCORE column was satisfied or not.

Query Text

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;

Dependencies

[top of page]

PON.PON_OPTIMIZE_CONSTRAINTS does not reference any database object

PON.PON_OPTIMIZE_CONSTRAINTS is referenced by following:

APPS: PON_OPTIMIZE_CONSTRAINTS