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.

[Home] [Help]

VIEW: PON.PON_OPTIMIZE_SCENARIOS#

Source

View Text - Preformatted


select AUCTION_HEADER_ID AUCTION_HEADER_ID, SCENARIO_ID SCENARIO_ID, SCENARIO_NUMBER SCENARIO_NUMBER, SCENARIO_NAME SCENARIO_NAME, OBJECTIVE_CODE OBJECTIVE_CODE, STATUS STATUS, PRICE_TYPE PRICE_TYPE, INTERNAL_NOTE INTERNAL_NOTE, TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT, TOTAL_PO_AMOUNT TOTAL_PO_AMOUNT, PARTIAL_AWARD_FLAG PARTIAL_AWARD_FLAG, NUMBER_AWARDED_SUPPLIERS NUMBER_AWARDED_SUPPLIERS, LAST_RUN_DATE LAST_RUN_DATE, UPDATED_TP_CONTACT_ID UPDATED_TP_CONTACT_ID, LAST_TP_UPDATE_DATE LAST_TP_UPDATE_DATE, ACCEPTED_DATE ACCEPTED_DATE, 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, REQUEST_ID REQUEST_ID, REQUEST_DATE REQUEST_DATE, REQUESTED_BY REQUESTED_BY, TOTAL_SAVINGS_PERCENT TOTAL_SAVINGS_PERCENT, TOTAL_SAVINGS_AMOUNT TOTAL_SAVINGS_AMOUNT, TOTAL_TRANSFORMED_AMOUNT TOTAL_TRANSFORMED_AMOUNT, COST_SCENARIO_FLAG COST_SCENARIO_FLAG, PARENT_SCENARIO_ID PARENT_SCENARIO_ID, CONSTRAINT_PRIORITY_TYPE CONSTRAINT_PRIORITY_TYPE, CRITICAL_COEFF CRITICAL_COEFF, VERY_IMP_COEFF VERY_IMP_COEFF, IMP_COEFF IMP_COEFF, LESS_IMP_COEFF LESS_IMP_COEFF from "PON"."PON_OPTIMIZE_SCENARIOS"

View Text - HTML Formatted

SELECT AUCTION_HEADER_ID AUCTION_HEADER_ID
, SCENARIO_ID SCENARIO_ID
, SCENARIO_NUMBER SCENARIO_NUMBER
, SCENARIO_NAME SCENARIO_NAME
, OBJECTIVE_CODE OBJECTIVE_CODE
, STATUS STATUS
, PRICE_TYPE PRICE_TYPE
, INTERNAL_NOTE INTERNAL_NOTE
, TOTAL_AWARD_AMOUNT TOTAL_AWARD_AMOUNT
, TOTAL_PO_AMOUNT TOTAL_PO_AMOUNT
, PARTIAL_AWARD_FLAG PARTIAL_AWARD_FLAG
, NUMBER_AWARDED_SUPPLIERS NUMBER_AWARDED_SUPPLIERS
, LAST_RUN_DATE LAST_RUN_DATE
, UPDATED_TP_CONTACT_ID UPDATED_TP_CONTACT_ID
, LAST_TP_UPDATE_DATE LAST_TP_UPDATE_DATE
, ACCEPTED_DATE ACCEPTED_DATE
, 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
, REQUEST_ID REQUEST_ID
, REQUEST_DATE REQUEST_DATE
, REQUESTED_BY REQUESTED_BY
, TOTAL_SAVINGS_PERCENT TOTAL_SAVINGS_PERCENT
, TOTAL_SAVINGS_AMOUNT TOTAL_SAVINGS_AMOUNT
, TOTAL_TRANSFORMED_AMOUNT TOTAL_TRANSFORMED_AMOUNT
, COST_SCENARIO_FLAG COST_SCENARIO_FLAG
, PARENT_SCENARIO_ID PARENT_SCENARIO_ID
, CONSTRAINT_PRIORITY_TYPE CONSTRAINT_PRIORITY_TYPE
, CRITICAL_COEFF CRITICAL_COEFF
, VERY_IMP_COEFF VERY_IMP_COEFF
, IMP_COEFF IMP_COEFF
, LESS_IMP_COEFF LESS_IMP_COEFF
FROM "PON"."PON_OPTIMIZE_SCENARIOS"