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: APPS.FND_CONCURRENT_WORKER_REQUESTS

Source

View Text - Preformatted


Select R."REQUEST_ID",R."LAST_UPDATE_DATE",R."LAST_UPDATED_BY",R."REQUEST_DATE",R."REQUESTED_BY",R."PHASE_CODE",R."STATUS_CODE",R."PRIORITY_REQUEST_ID",R."PRIORITY",R."REQUESTED_START_DATE",R."HOLD_FLAG",R."ENFORCE_SERIALITY_FLAG",R."SINGLE_THREAD_FLAG",R."HAS_SUB_REQUEST",R."IS_SUB_REQUEST",R."IMPLICIT_CODE",R."UPDATE_PROTECTED",R."QUEUE_METHOD_CODE",R."ARGUMENT_INPUT_METHOD_CODE",R."ORACLE_ID",R."PROGRAM_APPLICATION_ID",R."CONCURRENT_PROGRAM_ID",R."RESPONSIBILITY_APPLICATION_ID",R."RESPONSIBILITY_ID",R."NUMBER_OF_ARGUMENTS",R."NUMBER_OF_COPIES",R."SAVE_OUTPUT_FLAG",R."NLS_COMPLIANT",R."LAST_UPDATE_LOGIN",R."NLS_LANGUAGE",R."NLS_TERRITORY",R."PRINTER",R."PRINT_STYLE",R."PRINT_GROUP",R."REQUEST_CLASS_APPLICATION_ID",R."CONCURRENT_REQUEST_CLASS_ID",R."PARENT_REQUEST_ID",R."CONC_LOGIN_ID",R."LANGUAGE_ID",R."DESCRIPTION",R."REQ_INFORMATION",R."RESUBMIT_INTERVAL",R."RESUBMIT_INTERVAL_UNIT_CODE",R."RESUBMIT_INTERVAL_TYPE_CODE",R."RESUBMIT_TIME",R."RESUBMIT_END_DATE",R."RESUBMITTED",R."CONTROLLING_MANAGER",R."ACTUAL_START_DATE",R."ACTUAL_COMPLETION_DATE",R."COMPLETION_TEXT",R."OUTCOME_PRODUCT",R."OUTCOME_CODE",R."CPU_SECONDS",R."LOGICAL_IOS",R."PHYSICAL_IOS",R."LOGFILE_NAME",R."LOGFILE_NODE_NAME",R."OUTFILE_NAME",R."OUTFILE_NODE_NAME",R."ARGUMENT_TEXT",R."ARGUMENT1",R."ARGUMENT2",R."ARGUMENT3",R."ARGUMENT4",R."ARGUMENT5",R."ARGUMENT6",R."ARGUMENT7",R."ARGUMENT8",R."ARGUMENT9",R."ARGUMENT10",R."ARGUMENT11",R."ARGUMENT12",R."ARGUMENT13",R."ARGUMENT14",R."ARGUMENT15",R."ARGUMENT16",R."ARGUMENT17",R."ARGUMENT18",R."ARGUMENT19",R."ARGUMENT20",R."ARGUMENT21",R."ARGUMENT22",R."ARGUMENT23",R."ARGUMENT24",R."ARGUMENT25",R."CRM_THRSHLD",R."CRM_TSTMP",R."CRITICAL",R."REQUEST_TYPE",R."ORACLE_PROCESS_ID",R."ORACLE_SESSION_ID",R."OS_PROCESS_ID",R."PRINT_JOB_ID",R."OUTPUT_FILE_TYPE",R."RELEASE_CLASS_APP_ID",R."RELEASE_CLASS_ID",R."STALE_DATE",R."CANCEL_OR_HOLD",R."NOTIFY_ON_PP_ERROR",R."CD_ID",R."REQUEST_LIMIT",R."CRM_RELEASE_DATE",R."POST_REQUEST_STATUS",R."COMPLETION_CODE",R."INCREMENT_DATES",R."RESTART",R."ENABLE_TRACE",R."RESUB_COUNT",R."NLS_CODESET",R."OFILE_SIZE",R."LFILE_SIZE",R."STALE",R."SECURITY_GROUP_ID",R."RESOURCE_CONSUMER_GROUP",R."EXP_DATE",R."QUEUE_APP_ID",R."QUEUE_ID",R."OPS_INSTANCE",R."INTERIM_STATUS_CODE",R."ROOT_REQUEST_ID",R."ORIGIN",R."NLS_NUMERIC_CHARACTERS",R."PP_START_DATE",R."PP_END_DATE",R."ORG_ID",R."RUN_NUMBER",R."NODE_NAME1",R."NODE_NAME2",R."CONNSTR1",R."CONNSTR2",R."EDITION_NAME", Q.Application_ID Queue_Application_ID,
       Q.Concurrent_Queue_ID,Q.Concurrent_Queue_Name,Control_Code,
       Processor_Application_ID, Concurrent_Processor_ID,
       Running_Processes, Max_Processes, Cache_Size,
       Target_Node,
       QT.Description Queue_Description,
       Concurrent_Program_Name, Execution_Method_Code,
       Argument_Method_Code, Queue_Control_Flag, Run_Alone_Flag,
       P.Enabled_Flag, PT.Description Program_Description,
       PT.User_Concurrent_Program_Name,
       Decode(R.Description, NULL,
        PT.User_Concurrent_Program_Name,
        R.Description||' ('||PT.User_Concurrent_Program_Name||')')
       Request_Description
from Fnd_Concurrent_Requests R,
     Fnd_Concurrent_Queues Q, Fnd_Concurrent_Programs P,
     Fnd_Concurrent_Queues_TL QT, Fnd_Concurrent_Programs_TL PT
where
    PT.Language=Userenv('lang')
And PT.Concurrent_Program_ID=P.Concurrent_Program_ID
And PT.Application_ID=P.Application_ID
And P.Application_ID=R.Program_Application_ID
And P.Concurrent_Program_ID=R.Concurrent_Program_ID
And QT.Language=Userenv('lang')
And QT.Concurrent_Queue_ID=Q.Concurrent_Queue_ID
And QT.Application_ID=Q.Application_ID
and R.Status_Code in ('R', 'T', 'Q', 'I')
and (
     (R.Status_Code = 'R' OR R.Status_Code ='T')
     and exists
     ( select null from fnd_concurrent_processes
       where concurrent_process_id=controlling_manager
       and queue_application_id=Q.application_id
       and concurrent_queue_id=Q.concurrent_queue_id
     )
     OR
     (  P.Enabled_Flag='Y'
        And R.Program_Application_Id=P.Application_Id
        And R.Concurrent_Program_Id=P.Concurrent_Program_Id
        AND
        (
           ( Q.Application_ID=0 and Q.Concurrent_Queue_ID=1
             and R.Queue_Method_Code='B' and R.Status_Code='Q'
             and P.Queue_Control_Flag='Y'
           )
           OR
           ( Q.Application_ID=0 and Q.Concurrent_Queue_ID=4
             and R.Queue_Method_Code='B' and R.Status_Code='Q'
             and P.Queue_Control_Flag='N'
           )
           OR
           (
            (R.Status_Code = 'I' OR R.Status_Code = 'Q')
            And P.Queue_Control_Flag='N'
            AND EXISTS
            (  Select Null From Fnd_Oracle_Userid O
              Where R.Oracle_Id=O.Oracle_Id
              AND EXISTS
              ( Select Null From Fnd_Conflicts_Domain C
                Where P.Run_Alone_Flag=C.RunAlone_Flag
                And R.CD_Id = C.CD_Id
              )
            )
           )
           And
           (
             ( Q.APPLICATION_ID=0 AND Q.CONCURRENT_QUEUE_ID=0
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) NOT IN ((510,40112),(510,40113),(510,41497),(510,41498),(530,41859),(530,41860),(535,41492),(535,41493),(535,41494)))
             )
             OR
             ( Q.APPLICATION_ID=0 AND Q.CONCURRENT_QUEUE_ID=1063
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,42852),(0,44706)))
             )
             OR
             ( Q.APPLICATION_ID=275 AND Q.CONCURRENT_QUEUE_ID=40
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((275,32738),(275,34041))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((275,32738),(275,34041)))
             )
             OR
             ( Q.APPLICATION_ID=385 AND Q.CONCURRENT_QUEUE_ID=1260
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((385,45107),(385,45108),(385,45110),(385,45111)))
             )
             OR
             ( Q.APPLICATION_ID=401 AND Q.CONCURRENT_QUEUE_ID=10
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((401,32319),(401,32320),(401,32321),(702,31888),(702,31889),(702,32763),(706,31915))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((401,32237),(401,32319),(401,32320),(401,32321),(702,31888),(702,31889),(702,32763),(706,31892),(706,31915)))
             )
             OR
             ( Q.APPLICATION_ID=510 AND Q.CONCURRENT_QUEUE_ID=1046
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((510,40112),(510,40113),(510,41497),(510,41498)))
             )
             OR
             ( Q.APPLICATION_ID=530 AND Q.CONCURRENT_QUEUE_ID=1258
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((530,41859),(530,41860)))
             )
             OR
             ( Q.APPLICATION_ID=535 AND Q.CONCURRENT_QUEUE_ID=1003
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((535,40117),(535,40118),(535,40119),(535,40120)) OR R.PROGRAM_APPLICATION_ID IN (535))
             )
             OR
             ( Q.APPLICATION_ID=695 AND Q.CONCURRENT_QUEUE_ID=1047
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((695,42002),(695,42003),(695,42004),(695,42005),(695,42006),(695,42007),(695,42008)))
             )
             OR
             ( Q.APPLICATION_ID=696 AND Q.CONCURRENT_QUEUE_ID=1024
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((696,41822)))
             )
             OR
             ( Q.APPLICATION_ID=696 AND Q.CONCURRENT_QUEUE_ID=1025
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((696,41823)))
             )
             OR
             ( Q.APPLICATION_ID=704 AND Q.CONCURRENT_QUEUE_ID=39
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((704,31556))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((704,31556)))
             )
             OR
             ( Q.APPLICATION_ID=716 AND Q.CONCURRENT_QUEUE_ID=1141
                     AND
               ( P.Execution_Method_Code != 'S'
                 OR
(R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((0,98),(0,100),(0,31721),(0,31722),(0,31757))
               )
               AND
((R.PROGRAM_APPLICATION_ID,R.CONCURRENT_PROGRAM_ID) IN ((716,43594)))
             )
           )
        )
     )
    )

View Text - HTML Formatted

SELECT R."REQUEST_ID"
, R."LAST_UPDATE_DATE"
, R."LAST_UPDATED_BY"
, R."REQUEST_DATE"
, R."REQUESTED_BY"
, R."PHASE_CODE"
, R."STATUS_CODE"
, R."PRIORITY_REQUEST_ID"
, R."PRIORITY"
, R."REQUESTED_START_DATE"
, R."HOLD_FLAG"
, R."ENFORCE_SERIALITY_FLAG"
, R."SINGLE_THREAD_FLAG"
, R."HAS_SUB_REQUEST"
, R."IS_SUB_REQUEST"
, R."IMPLICIT_CODE"
, R."UPDATE_PROTECTED"
, R."QUEUE_METHOD_CODE"
, R."ARGUMENT_INPUT_METHOD_CODE"
, R."ORACLE_ID"
, R."PROGRAM_APPLICATION_ID"
, R."CONCURRENT_PROGRAM_ID"
, R."RESPONSIBILITY_APPLICATION_ID"
, R."RESPONSIBILITY_ID"
, R."NUMBER_OF_ARGUMENTS"
, R."NUMBER_OF_COPIES"
, R."SAVE_OUTPUT_FLAG"
, R."NLS_COMPLIANT"
, R."LAST_UPDATE_LOGIN"
, R."NLS_LANGUAGE"
, R."NLS_TERRITORY"
, R."PRINTER"
, R."PRINT_STYLE"
, R."PRINT_GROUP"
, R."REQUEST_CLASS_APPLICATION_ID"
, R."CONCURRENT_REQUEST_CLASS_ID"
, R."PARENT_REQUEST_ID"
, R."CONC_LOGIN_ID"
, R."LANGUAGE_ID"
, R."DESCRIPTION"
, R."REQ_INFORMATION"
, R."RESUBMIT_INTERVAL"
, R."RESUBMIT_INTERVAL_UNIT_CODE"
, R."RESUBMIT_INTERVAL_TYPE_CODE"
, R."RESUBMIT_TIME"
, R."RESUBMIT_END_DATE"
, R."RESUBMITTED"
, R."CONTROLLING_MANAGER"
, R."ACTUAL_START_DATE"
, R."ACTUAL_COMPLETION_DATE"
, R."COMPLETION_TEXT"
, R."OUTCOME_PRODUCT"
, R."OUTCOME_CODE"
, R."CPU_SECONDS"
, R."LOGICAL_IOS"
, R."PHYSICAL_IOS"
, R."LOGFILE_NAME"
, R."LOGFILE_NODE_NAME"
, R."OUTFILE_NAME"
, R."OUTFILE_NODE_NAME"
, R."ARGUMENT_TEXT"
, R."ARGUMENT1"
, R."ARGUMENT2"
, R."ARGUMENT3"
, R."ARGUMENT4"
, R."ARGUMENT5"
, R."ARGUMENT6"
, R."ARGUMENT7"
, R."ARGUMENT8"
, R."ARGUMENT9"
, R."ARGUMENT10"
, R."ARGUMENT11"
, R."ARGUMENT12"
, R."ARGUMENT13"
, R."ARGUMENT14"
, R."ARGUMENT15"
, R."ARGUMENT16"
, R."ARGUMENT17"
, R."ARGUMENT18"
, R."ARGUMENT19"
, R."ARGUMENT20"
, R."ARGUMENT21"
, R."ARGUMENT22"
, R."ARGUMENT23"
, R."ARGUMENT24"
, R."ARGUMENT25"
, R."CRM_THRSHLD"
, R."CRM_TSTMP"
, R."CRITICAL"
, R."REQUEST_TYPE"
, R."ORACLE_PROCESS_ID"
, R."ORACLE_SESSION_ID"
, R."OS_PROCESS_ID"
, R."PRINT_JOB_ID"
, R."OUTPUT_FILE_TYPE"
, R."RELEASE_CLASS_APP_ID"
, R."RELEASE_CLASS_ID"
, R."STALE_DATE"
, R."CANCEL_OR_HOLD"
, R."NOTIFY_ON_PP_ERROR"
, R."CD_ID"
, R."REQUEST_LIMIT"
, R."CRM_RELEASE_DATE"
, R."POST_REQUEST_STATUS"
, R."COMPLETION_CODE"
, R."INCREMENT_DATES"
, R."RESTART"
, R."ENABLE_TRACE"
, R."RESUB_COUNT"
, R."NLS_CODESET"
, R."OFILE_SIZE"
, R."LFILE_SIZE"
, R."STALE"
, R."SECURITY_GROUP_ID"
, R."RESOURCE_CONSUMER_GROUP"
, R."EXP_DATE"
, R."QUEUE_APP_ID"
, R."QUEUE_ID"
, R."OPS_INSTANCE"
, R."INTERIM_STATUS_CODE"
, R."ROOT_REQUEST_ID"
, R."ORIGIN"
, R."NLS_NUMERIC_CHARACTERS"
, R."PP_START_DATE"
, R."PP_END_DATE"
, R."ORG_ID"
, R."RUN_NUMBER"
, R."NODE_NAME1"
, R."NODE_NAME2"
, R."CONNSTR1"
, R."CONNSTR2"
, R."EDITION_NAME"
, Q.APPLICATION_ID QUEUE_APPLICATION_ID
, Q.CONCURRENT_QUEUE_ID
, Q.CONCURRENT_QUEUE_NAME
, CONTROL_CODE
, PROCESSOR_APPLICATION_ID
, CONCURRENT_PROCESSOR_ID
, RUNNING_PROCESSES
, MAX_PROCESSES
, CACHE_SIZE
, TARGET_NODE
, QT.DESCRIPTION QUEUE_DESCRIPTION
, CONCURRENT_PROGRAM_NAME
, EXECUTION_METHOD_CODE
, ARGUMENT_METHOD_CODE
, QUEUE_CONTROL_FLAG
, RUN_ALONE_FLAG
, P.ENABLED_FLAG
, PT.DESCRIPTION PROGRAM_DESCRIPTION
, PT.USER_CONCURRENT_PROGRAM_NAME
, DECODE(R.DESCRIPTION
, NULL
, PT.USER_CONCURRENT_PROGRAM_NAME
, R.DESCRIPTION||' ('||PT.USER_CONCURRENT_PROGRAM_NAME||')') REQUEST_DESCRIPTION FROM FND_CONCURRENT_REQUESTS R
, FND_CONCURRENT_QUEUES Q
, FND_CONCURRENT_PROGRAMS P
, FND_CONCURRENT_QUEUES_TL QT
, FND_CONCURRENT_PROGRAMS_TL PT WHERE PT.LANGUAGE=USERENV('LANG') AND PT.CONCURRENT_PROGRAM_ID=P.CONCURRENT_PROGRAM_ID AND PT.APPLICATION_ID=P.APPLICATION_ID AND P.APPLICATION_ID=R.PROGRAM_APPLICATION_ID AND P.CONCURRENT_PROGRAM_ID=R.CONCURRENT_PROGRAM_ID AND QT.LANGUAGE=USERENV('LANG') AND QT.CONCURRENT_QUEUE_ID=Q.CONCURRENT_QUEUE_ID AND QT.APPLICATION_ID=Q.APPLICATION_ID AND R.STATUS_CODE IN ('R'
, 'T'
, 'Q'
, 'I') AND ( (R.STATUS_CODE = 'R' OR R.STATUS_CODE ='T')
AND EXISTS ( SELECT NULL
FROM FND_CONCURRENT_PROCESSES
WHERE CONCURRENT_PROCESS_ID=CONTROLLING_MANAGER
AND QUEUE_APPLICATION_ID=Q.APPLICATION_ID
AND CONCURRENT_QUEUE_ID=Q.CONCURRENT_QUEUE_ID ) OR ( P.ENABLED_FLAG='Y'
AND R.PROGRAM_APPLICATION_ID=P.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID=P.CONCURRENT_PROGRAM_ID AND ( ( Q.APPLICATION_ID=0
AND Q.CONCURRENT_QUEUE_ID=1
AND R.QUEUE_METHOD_CODE='B'
AND R.STATUS_CODE='Q'
AND P.QUEUE_CONTROL_FLAG='Y' ) OR ( Q.APPLICATION_ID=0
AND Q.CONCURRENT_QUEUE_ID=4
AND R.QUEUE_METHOD_CODE='B'
AND R.STATUS_CODE='Q'
AND P.QUEUE_CONTROL_FLAG='N' ) OR ( (R.STATUS_CODE = 'I' OR R.STATUS_CODE = 'Q')
AND P.QUEUE_CONTROL_FLAG='N'
AND EXISTS ( SELECT NULL
FROM FND_ORACLE_USERID O
WHERE R.ORACLE_ID=O.ORACLE_ID
AND EXISTS ( SELECT NULL
FROM FND_CONFLICTS_DOMAIN C
WHERE P.RUN_ALONE_FLAG=C.RUNALONE_FLAG
AND R.CD_ID = C.CD_ID ) ) ) AND ( ( Q.APPLICATION_ID=0
AND Q.CONCURRENT_QUEUE_ID=0 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) NOT IN ((510
, 40112)
, (510
, 40113)
, (510
, 41497)
, (510
, 41498)
, (530
, 41859)
, (530
, 41860)
, (535
, 41492)
, (535
, 41493)
, (535
, 41494))) ) OR ( Q.APPLICATION_ID=0
AND Q.CONCURRENT_QUEUE_ID=1063 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 42852)
, (0
, 44706))) ) OR ( Q.APPLICATION_ID=275
AND Q.CONCURRENT_QUEUE_ID=40 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((275
, 32738)
, (275
, 34041)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((275
, 32738)
, (275
, 34041))) ) OR ( Q.APPLICATION_ID=385
AND Q.CONCURRENT_QUEUE_ID=1260 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((385
, 45107)
, (385
, 45108)
, (385
, 45110)
, (385
, 45111))) ) OR ( Q.APPLICATION_ID=401
AND Q.CONCURRENT_QUEUE_ID=10 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((401
, 32319)
, (401
, 32320)
, (401
, 32321)
, (702
, 31888)
, (702
, 31889)
, (702
, 32763)
, (706
, 31915)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((401
, 32237)
, (401
, 32319)
, (401
, 32320)
, (401
, 32321)
, (702
, 31888)
, (702
, 31889)
, (702
, 32763)
, (706
, 31892)
, (706
, 31915))) ) OR ( Q.APPLICATION_ID=510
AND Q.CONCURRENT_QUEUE_ID=1046 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((510
, 40112)
, (510
, 40113)
, (510
, 41497)
, (510
, 41498))) ) OR ( Q.APPLICATION_ID=530
AND Q.CONCURRENT_QUEUE_ID=1258 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((530
, 41859)
, (530
, 41860))) ) OR ( Q.APPLICATION_ID=535
AND Q.CONCURRENT_QUEUE_ID=1003 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((535
, 40117)
, (535
, 40118)
, (535
, 40119)
, (535
, 40120)) OR R.PROGRAM_APPLICATION_ID IN (535)) ) OR ( Q.APPLICATION_ID=695
AND Q.CONCURRENT_QUEUE_ID=1047 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((695
, 42002)
, (695
, 42003)
, (695
, 42004)
, (695
, 42005)
, (695
, 42006)
, (695
, 42007)
, (695
, 42008))) ) OR ( Q.APPLICATION_ID=696
AND Q.CONCURRENT_QUEUE_ID=1024 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((696
, 41822))) ) OR ( Q.APPLICATION_ID=696
AND Q.CONCURRENT_QUEUE_ID=1025 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((696
, 41823))) ) OR ( Q.APPLICATION_ID=704
AND Q.CONCURRENT_QUEUE_ID=39 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((704
, 31556)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((704
, 31556))) ) OR ( Q.APPLICATION_ID=716
AND Q.CONCURRENT_QUEUE_ID=1141 AND ( P.EXECUTION_METHOD_CODE != 'S' OR (R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((0
, 98)
, (0
, 100)
, (0
, 31721)
, (0
, 31722)
, (0
, 31757)) ) AND ((R.PROGRAM_APPLICATION_ID
, R.CONCURRENT_PROGRAM_ID) IN ((716
, 43594))) ) ) ) ) )