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_SCENARIOS

Object Details

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

PON_OPTIMIZE_SCENARIOS stores information about the award optimization scenarios

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PON_OPTIMIZE_SCENARIOS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCENARIO_ID
PON_OPTIMIZE_SCENARIOS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	AUCTION_HEADER_ID SCENARIO_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
AUCTION_HEADER_ID	NUMBER		Yes	Identifies auction to which this scenario belongs
SCENARIO_ID	NUMBER		Yes	DB generated sequential ID to identify the scenario
SCENARIO_NUMBER	NUMBER		Yes	Display number for the scenario
SCENARIO_NAME	VARCHAR2	(240)	Yes	User entered name for the scenario
OBJECTIVE_CODE	VARCHAR2	(30)	Yes	FND lookup code representing this objective
STATUS	VARCHAR2	(25)	Yes	Current status for the scenario
PRICE_TYPE	VARCHAR2	(30)	Yes	FND_LOOKUP code representing whether prices will be transformed or not
INTERNAL_NOTE	VARCHAR2	(4000)		Stores internal note for scenario
TOTAL_AWARD_AMOUNT	NUMBER			Total award amount for this scenario
TOTAL_PO_AMOUNT	NUMBER			Total PO amount for this scenario
PARTIAL_AWARD_FLAG	VARCHAR2	(1)		Stores whether all lines for this negotiation have been awarded by this scenario
NUMBER_AWARDED_SUPPLIERS	NUMBER			Number of awarded suppliers for this scenario
LAST_RUN_DATE	DATE			Last time this scenario was run
UPDATED_TP_CONTACT_ID	NUMBER			Stores the tp_contact_id of the user who last updated the scenario
LAST_TP_UPDATE_DATE	DATE			Date this scenario was last updated
ACCEPTED_DATE	DATE			Date scenario was accepted
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
REQUEST_ID	NUMBER			Concurrent request id for optimize process for large auctions
REQUEST_DATE	DATE			Concurrent request submission date/time
REQUESTED_BY	NUMBER			The user id of the person who made the concurrent request.
TOTAL_SAVINGS_PERCENT	NUMBER			Stores the savings percent for this scenario
TOTAL_SAVINGS_AMOUNT	NUMBER			Stores the total savings amount for this scenario.
TOTAL_TRANSFORMED_AMOUNT	NUMBER			Stores total award amount with transformation factors for this scenario.
COST_SCENARIO_FLAG	VARCHAR2	(1)		This column specifies whether this scenario is used to calculate cost of constraint
PARENT_SCENARIO_ID	NUMBER			This column is applicable for all dummy scenarios only. This column refers to the scenario_id of the main scenario
CONSTRAINT_PRIORITY_TYPE	VARCHAR2	(20)		This column stores either of the following values - "USER_DEFINED" or "MANDATORY"
CRITICAL_COEFF	NUMBER			user-entered coefficient to be used by the system for Critical constraints
VERY_IMP_COEFF	NUMBER			user-entered coefficient to be used by the system for Very Important constraints
IMP_COEFF	NUMBER			user-entered coefficient to be used by the system for Important constraints
LESS_IMP_COEFF	NUMBER			user-entered coefficient to be used by the system for Less Important constraints

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT AUCTION_HEADER_ID
,      SCENARIO_ID
,      SCENARIO_NUMBER
,      SCENARIO_NAME
,      OBJECTIVE_CODE
,      STATUS
,      PRICE_TYPE
,      INTERNAL_NOTE
,      TOTAL_AWARD_AMOUNT
,      TOTAL_PO_AMOUNT
,      PARTIAL_AWARD_FLAG
,      NUMBER_AWARDED_SUPPLIERS
,      LAST_RUN_DATE
,      UPDATED_TP_CONTACT_ID
,      LAST_TP_UPDATE_DATE
,      ACCEPTED_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      REQUEST_DATE
,      REQUESTED_BY
,      TOTAL_SAVINGS_PERCENT
,      TOTAL_SAVINGS_AMOUNT
,      TOTAL_TRANSFORMED_AMOUNT
,      COST_SCENARIO_FLAG
,      PARENT_SCENARIO_ID
,      CONSTRAINT_PRIORITY_TYPE
,      CRITICAL_COEFF
,      VERY_IMP_COEFF
,      IMP_COEFF
,      LESS_IMP_COEFF
FROM PON.PON_OPTIMIZE_SCENARIOS;

Dependencies

[top of page]

PON.PON_OPTIMIZE_SCENARIOS does not reference any database object

PON.PON_OPTIMIZE_SCENARIOS is referenced by following:

PON: PON_OPTIMIZE_SCENARIOS#