VIEW: APPLSYS.FND_CONCURRENT_QUEUES#

Source

View Text - Preformatted

select APPLICATION_ID APPLICATION_ID, CONCURRENT_QUEUE_ID CONCURRENT_QUEUE_ID, CONCURRENT_QUEUE_NAME CONCURRENT_QUEUE_NAME, 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, PROCESSOR_APPLICATION_ID PROCESSOR_APPLICATION_ID, CONCURRENT_PROCESSOR_ID CONCURRENT_PROCESSOR_ID, MAX_PROCESSES MAX_PROCESSES, RUNNING_PROCESSES RUNNING_PROCESSES, CACHE_SIZE CACHE_SIZE, MIN_PROCESSES MIN_PROCESSES, TARGET_PROCESSES TARGET_PROCESSES, TARGET_NODE TARGET_NODE, TARGET_QUEUE TARGET_QUEUE, SLEEP_SECONDS SLEEP_SECONDS, CONTROL_CODE CONTROL_CODE, DIAGNOSTIC_LEVEL DIAGNOSTIC_LEVEL, MANAGER_TYPE MANAGER_TYPE, NODE_NAME NODE_NAME, NODE_NAME2 NODE_NAME2, OS_QUEUE OS_QUEUE, OS_QUEUE2 OS_QUEUE2, DATA_GROUP_ID DATA_GROUP_ID, RESTART_TYPE RESTART_TYPE, RESTART_INTERVAL RESTART_INTERVAL, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE ATTRIBUTE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ENABLED_FLAG ENABLED_FLAG, RESOURCE_CONSUMER_GROUP RESOURCE_CONSUMER_GROUP, PMON_STAT PMON_STAT, LAST_VERIFIED LAST_VERIFIED, WORK_START WORK_START, WORK_END WORK_END, PCP_FLAG PCP_FLAG, INSTANCE_NUMBER INSTANCE_NUMBER, CONTEXT_BUFFER CONTEXT_BUFFER, SERVICE_PARAMETERS SERVICE_PARAMETERS, TIME_PERIOD_ID TIME_PERIOD_ID, TIME_PERIOD_APP_ID TIME_PERIOD_APP_ID, CONCURRENT_TIME_PERIOD_ID CONCURRENT_TIME_PERIOD_ID, PERIOD_APPLICATION_ID PERIOD_APPLICATION_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "APPLSYS"."FND_CONCURRENT_QUEUES"

View Text - HTML Formatted

SELECT APPLICATION_ID APPLICATION_ID
, CONCURRENT_QUEUE_ID CONCURRENT_QUEUE_ID
, CONCURRENT_QUEUE_NAME CONCURRENT_QUEUE_NAME
, 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
, PROCESSOR_APPLICATION_ID PROCESSOR_APPLICATION_ID
, CONCURRENT_PROCESSOR_ID CONCURRENT_PROCESSOR_ID
, MAX_PROCESSES MAX_PROCESSES
, RUNNING_PROCESSES RUNNING_PROCESSES
, CACHE_SIZE CACHE_SIZE
, MIN_PROCESSES MIN_PROCESSES
, TARGET_PROCESSES TARGET_PROCESSES
, TARGET_NODE TARGET_NODE
, TARGET_QUEUE TARGET_QUEUE
, SLEEP_SECONDS SLEEP_SECONDS
, CONTROL_CODE CONTROL_CODE
, DIAGNOSTIC_LEVEL DIAGNOSTIC_LEVEL
, MANAGER_TYPE MANAGER_TYPE
, NODE_NAME NODE_NAME
, NODE_NAME2 NODE_NAME2
, OS_QUEUE OS_QUEUE
, OS_QUEUE2 OS_QUEUE2
, DATA_GROUP_ID DATA_GROUP_ID
, RESTART_TYPE RESTART_TYPE
, RESTART_INTERVAL RESTART_INTERVAL
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE ATTRIBUTE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ENABLED_FLAG ENABLED_FLAG
, RESOURCE_CONSUMER_GROUP RESOURCE_CONSUMER_GROUP
, PMON_STAT PMON_STAT
, LAST_VERIFIED LAST_VERIFIED
, WORK_START WORK_START
, WORK_END WORK_END
, PCP_FLAG PCP_FLAG
, INSTANCE_NUMBER INSTANCE_NUMBER
, CONTEXT_BUFFER CONTEXT_BUFFER
, SERVICE_PARAMETERS SERVICE_PARAMETERS
, TIME_PERIOD_ID TIME_PERIOD_ID
, TIME_PERIOD_APP_ID TIME_PERIOD_APP_ID
, CONCURRENT_TIME_PERIOD_ID CONCURRENT_TIME_PERIOD_ID
, PERIOD_APPLICATION_ID PERIOD_APPLICATION_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "APPLSYS"."FND_CONCURRENT_QUEUES"