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: CSF.CSF_R_SCHED_REQUESTS#

Source

View Text - Preformatted


select SCHED_REQUEST_ID SCHED_REQUEST_ID, RESULT_FLAG RESULT_FLAG, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PLANMODE PLANMODE, SPARES_LIKELIHOOD SPARES_LIKELIHOOD, SCHED_REQUEST_NAME SCHED_REQUEST_NAME, EXTENDED_EFFORT EXTENDED_EFFORT, PARENT_REQUEST_ID PARENT_REQUEST_ID, TARGET_STATUS_ID TARGET_STATUS_ID, ROUTE_BASED_FLAG ROUTE_BASED_FLAG, CHANGED_OPTION_START CHANGED_OPTION_START, CHANGED_OPTION_END CHANGED_OPTION_END, CHANGED_PLANNED_START CHANGED_PLANNED_START, CHANGED_PLANNED_END CHANGED_PLANNED_END, DISABLED_ACCESS_HOURS_FLAG DISABLED_ACCESS_HOURS_FLAG, CUSTOMER_CONF_RCVD CUSTOMER_CONF_RCVD, SPARES_LIKLIHOOD SPARES_LIKLIHOOD, CONSIDER_STANDBY_SHIFT CONSIDER_STANDBY_SHIFT, SPARES_SOURCE SPARES_SOURCE, SPARES_MANDATORY SPARES_MANDATORY, RES_PREFERENCE RES_PREFERENCE, CUST_OR_DISP_INITIATED CUST_OR_DISP_INITIATED from "CSF"."CSF_R_SCHED_REQUESTS"

View Text - HTML Formatted

SELECT SCHED_REQUEST_ID SCHED_REQUEST_ID
, RESULT_FLAG RESULT_FLAG
, CONCURRENT_REQUEST_ID CONCURRENT_REQUEST_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PLANMODE PLANMODE
, SPARES_LIKELIHOOD SPARES_LIKELIHOOD
, SCHED_REQUEST_NAME SCHED_REQUEST_NAME
, EXTENDED_EFFORT EXTENDED_EFFORT
, PARENT_REQUEST_ID PARENT_REQUEST_ID
, TARGET_STATUS_ID TARGET_STATUS_ID
, ROUTE_BASED_FLAG ROUTE_BASED_FLAG
, CHANGED_OPTION_START CHANGED_OPTION_START
, CHANGED_OPTION_END CHANGED_OPTION_END
, CHANGED_PLANNED_START CHANGED_PLANNED_START
, CHANGED_PLANNED_END CHANGED_PLANNED_END
, DISABLED_ACCESS_HOURS_FLAG DISABLED_ACCESS_HOURS_FLAG
, CUSTOMER_CONF_RCVD CUSTOMER_CONF_RCVD
, SPARES_LIKLIHOOD SPARES_LIKLIHOOD
, CONSIDER_STANDBY_SHIFT CONSIDER_STANDBY_SHIFT
, SPARES_SOURCE SPARES_SOURCE
, SPARES_MANDATORY SPARES_MANDATORY
, RES_PREFERENCE RES_PREFERENCE
, CUST_OR_DISP_INITIATED CUST_OR_DISP_INITIATED
FROM "CSF"."CSF_R_SCHED_REQUESTS"