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_CONCURRENT_PROCESSES#

Source

View Text - Preformatted


select CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID, 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, QUEUE_APPLICATION_ID QUEUE_APPLICATION_ID, CONCURRENT_QUEUE_ID CONCURRENT_QUEUE_ID, PROCESS_STATUS_CODE PROCESS_STATUS_CODE, SESSION_ID SESSION_ID, ORACLE_PROCESS_ID ORACLE_PROCESS_ID, PROCESS_START_DATE PROCESS_START_DATE, OS_PROCESS_NAME OS_PROCESS_NAME, OS_PROCESS_ID OS_PROCESS_ID, MANAGER_TYPE MANAGER_TYPE, NODE_NAME NODE_NAME, DB_NAME DB_NAME, DB_DOMAIN DB_DOMAIN, SQLNET_STRING SQLNET_STRING, LOGFILE_NAME LOGFILE_NAME, JOB_ID JOB_ID, DB_INSTANCE DB_INSTANCE, LK_HANDLE LK_HANDLE, PLSQL_LOG PLSQL_LOG, PLSQL_OUT PLSQL_OUT, LAST_TXN_START LAST_TXN_START, LAST_TXN_END LAST_TXN_END, PLSQL_DIR PLSQL_DIR, INSTANCE_NUMBER INSTANCE_NUMBER, PROCESS_CONTEXT PROCESS_CONTEXT, SERVICE_PARAMETERS SERVICE_PARAMETERS, GSM_INTERNAL_STATUS GSM_INTERNAL_STATUS, GSM_INTERNAL_INFO GSM_INTERNAL_INFO from "APPLSYS"."FND_CONCURRENT_PROCESSES"

View Text - HTML Formatted

SELECT CONCURRENT_PROCESS_ID CONCURRENT_PROCESS_ID
, 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
, QUEUE_APPLICATION_ID QUEUE_APPLICATION_ID
, CONCURRENT_QUEUE_ID CONCURRENT_QUEUE_ID
, PROCESS_STATUS_CODE PROCESS_STATUS_CODE
, SESSION_ID SESSION_ID
, ORACLE_PROCESS_ID ORACLE_PROCESS_ID
, PROCESS_START_DATE PROCESS_START_DATE
, OS_PROCESS_NAME OS_PROCESS_NAME
, OS_PROCESS_ID OS_PROCESS_ID
, MANAGER_TYPE MANAGER_TYPE
, NODE_NAME NODE_NAME
, DB_NAME DB_NAME
, DB_DOMAIN DB_DOMAIN
, SQLNET_STRING SQLNET_STRING
, LOGFILE_NAME LOGFILE_NAME
, JOB_ID JOB_ID
, DB_INSTANCE DB_INSTANCE
, LK_HANDLE LK_HANDLE
, PLSQL_LOG PLSQL_LOG
, PLSQL_OUT PLSQL_OUT
, LAST_TXN_START LAST_TXN_START
, LAST_TXN_END LAST_TXN_END
, PLSQL_DIR PLSQL_DIR
, INSTANCE_NUMBER INSTANCE_NUMBER
, PROCESS_CONTEXT PROCESS_CONTEXT
, SERVICE_PARAMETERS SERVICE_PARAMETERS
, GSM_INTERNAL_STATUS GSM_INTERNAL_STATUS
, GSM_INTERNAL_INFO GSM_INTERNAL_INFO
FROM "APPLSYS"."FND_CONCURRENT_PROCESSES"