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.

VIEW: APPLSYS.FND_CONC_PROG_ONSITE_INFO#

Source

View Text - Preformatted


select PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID, LAST_RUN_DATE LAST_RUN_DATE, LAST_RUN_REQUEST_ID LAST_RUN_REQUEST_ID, OUTCOME OUTCOME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MONITOR_ENABLED MONITOR_ENABLED, REQUEST_SCH_INTERVAL REQUEST_SCH_INTERVAL, SUCCESSFUL_COMPLETION SUCCESSFUL_COMPLETION, WARNING_COMPLETION WARNING_COMPLETION, ERROR_COMPLETION ERROR_COMPLETION, RESET_DATE RESET_DATE, MIN_RUN_TIME MIN_RUN_TIME, MAX_RUN_TIME MAX_RUN_TIME, AVG_RUN_TIME AVG_RUN_TIME, ON_FAILURE_LOG_LEVEL ON_FAILURE_LOG_LEVEL, SHELF_LIFE SHELF_LIFE, ALERT_LONG_RUNNING_ENABLED ALERT_LONG_RUNNING_ENABLED, ALERT_LONG_RUNNING_THRESHOLD ALERT_LONG_RUNNING_THRESHOLD, ALERT_LONG_RUNNING_TOLERANCE ALERT_LONG_RUNNING_TOLERANCE, ALERT_LONG_PENDING_ENABLED ALERT_LONG_PENDING_ENABLED, ALERT_LONG_PENDING_TOLERANCE ALERT_LONG_PENDING_TOLERANCE, NODE_NAME1 NODE_NAME1, NODE_NAME2 NODE_NAME2, CONNSTR1 CONNSTR1, CONNSTR2 CONNSTR2, BUSINESS_EVENT_MAP BUSINESS_EVENT_MAP from "APPLSYS"."FND_CONC_PROG_ONSITE_INFO"

View Text - HTML Formatted

SELECT PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, CONCURRENT_PROGRAM_ID CONCURRENT_PROGRAM_ID
, LAST_RUN_DATE LAST_RUN_DATE
, LAST_RUN_REQUEST_ID LAST_RUN_REQUEST_ID
, OUTCOME OUTCOME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MONITOR_ENABLED MONITOR_ENABLED
, REQUEST_SCH_INTERVAL REQUEST_SCH_INTERVAL
, SUCCESSFUL_COMPLETION SUCCESSFUL_COMPLETION
, WARNING_COMPLETION WARNING_COMPLETION
, ERROR_COMPLETION ERROR_COMPLETION
, RESET_DATE RESET_DATE
, MIN_RUN_TIME MIN_RUN_TIME
, MAX_RUN_TIME MAX_RUN_TIME
, AVG_RUN_TIME AVG_RUN_TIME
, ON_FAILURE_LOG_LEVEL ON_FAILURE_LOG_LEVEL
, SHELF_LIFE SHELF_LIFE
, ALERT_LONG_RUNNING_ENABLED ALERT_LONG_RUNNING_ENABLED
, ALERT_LONG_RUNNING_THRESHOLD ALERT_LONG_RUNNING_THRESHOLD
, ALERT_LONG_RUNNING_TOLERANCE ALERT_LONG_RUNNING_TOLERANCE
, ALERT_LONG_PENDING_ENABLED ALERT_LONG_PENDING_ENABLED
, ALERT_LONG_PENDING_TOLERANCE ALERT_LONG_PENDING_TOLERANCE
, NODE_NAME1 NODE_NAME1
, NODE_NAME2 NODE_NAME2
, CONNSTR1 CONNSTR1
, CONNSTR2 CONNSTR2
, BUSINESS_EVENT_MAP BUSINESS_EVENT_MAP
FROM "APPLSYS"."FND_CONC_PROG_ONSITE_INFO"