VIEW: APPS.FND_CONC_WAITING_REQUESTS

Source

View Text - Preformatted

SELECT R1.request_id reqid, R2.Request_ID wreqid, R2.Program, R2.User_Name, fnd_amp_private.get_phase(r2.phase_code, r2.status_code, r2.hold_flag, r2.enabled_flag, r2.requested_start_date, r2.request_id) phase, fnd_amp_private.get_status(r2.phase_code, r2.status_code, r2.hold_flag, r2.enabled_flag, r2.requested_start_date, r2.request_id) status, R2.Argument_text, R2.Priority, Fnd_Amp_Private.Why_Wait(R1.Request_ID, R1.Single_Thread_Flag, R1.Request_Limit, R1.Requested_By, R1.Program_Application_ID, R1.Concurrent_Program_ID, R1.Status_Code, R2.Request_ID, R2.Single_Thread_Flag,R2.Request_Limit, R2.Requested_By, R2.Run_Alone_Flag, R2.Program_Application_ID, R2.Concurrent_Program_ID, R2.Is_Sub_Request, R2.Parent_Request_ID) why from fnd_concurrent_requests r1, fnd_amp_requests_v r2 WHERE (r2.status_code between 'I' and 'W') and r2.hold_flag = 'N' and r2.enabled_flag= 'Y' and ((r2.priority > r1.priority) or (r2.priority = r1.priority and r2.request_id < r1.request_id)) and ((r2.requested_start_date<= SYSDATE) or (r2.requested_start_date <= r1.requested_start_date)) and ((r2.run_alone_flag = 'Y' and r2.cd_id = r1.cd_id) or r2.request_id in (select request_id from fnd_concurrent_worker_requests where (queue_application_id != 0 or concurrent_queue_id not in (1,4)) and running_processes > 0)) and r2.queue_method_code = 'B' and ((r2.run_alone_flag = 'Y' and r2.cd_id = r1.cd_id) or (r1.queue_method_code = 'B' and ((r1.single_thread_flag = 'Y' and r2.single_thread_flag = 'Y' and r1.requested_by = r2.requested_by) or (r1.status_code='W' and r2.is_sub_request = 'Y' and r2.parent_request_id = r1.request_id) or (r1.request_limit = 'Y' and r2.request_limit='Y' and r1.requested_by = r2.requested_by) or ((r2.program_application_id, r2.concurrent_program_id) in (select running_application_id, running_concurrent_program_id from fnd_concurrent_program_serial where to_run_application_id = r1.program_application_id and to_run_concurrent_program_id = r1.concurrent_program_id and (incompatibility_type = 'G' or r2.cd_id = r1.cd_id)))))) order by reqid, wreqid

View Text - HTML Formatted

SELECT R1.REQUEST_ID REQID
, R2.REQUEST_ID WREQID
, R2.PROGRAM
, R2.USER_NAME
, FND_AMP_PRIVATE.GET_PHASE(R2.PHASE_CODE
, R2.STATUS_CODE
, R2.HOLD_FLAG
, R2.ENABLED_FLAG
, R2.REQUESTED_START_DATE
, R2.REQUEST_ID) PHASE
, FND_AMP_PRIVATE.GET_STATUS(R2.PHASE_CODE
, R2.STATUS_CODE
, R2.HOLD_FLAG
, R2.ENABLED_FLAG
, R2.REQUESTED_START_DATE
, R2.REQUEST_ID) STATUS
, R2.ARGUMENT_TEXT
, R2.PRIORITY
, FND_AMP_PRIVATE.WHY_WAIT(R1.REQUEST_ID
, R1.SINGLE_THREAD_FLAG
, R1.REQUEST_LIMIT
, R1.REQUESTED_BY
, R1.PROGRAM_APPLICATION_ID
, R1.CONCURRENT_PROGRAM_ID
, R1.STATUS_CODE
, R2.REQUEST_ID
, R2.SINGLE_THREAD_FLAG
, R2.REQUEST_LIMIT
, R2.REQUESTED_BY
, R2.RUN_ALONE_FLAG
, R2.PROGRAM_APPLICATION_ID
, R2.CONCURRENT_PROGRAM_ID
, R2.IS_SUB_REQUEST
, R2.PARENT_REQUEST_ID) WHY
FROM FND_CONCURRENT_REQUESTS R1
, FND_AMP_REQUESTS_V R2
WHERE (R2.STATUS_CODE BETWEEN 'I'
AND 'W')
AND R2.HOLD_FLAG = 'N'
AND R2.ENABLED_FLAG= 'Y'
AND ((R2.PRIORITY > R1.PRIORITY) OR (R2.PRIORITY = R1.PRIORITY
AND R2.REQUEST_ID < R1.REQUEST_ID))
AND ((R2.REQUESTED_START_DATE<= SYSDATE) OR (R2.REQUESTED_START_DATE <= R1.REQUESTED_START_DATE))
AND ((R2.RUN_ALONE_FLAG = 'Y'
AND R2.CD_ID = R1.CD_ID) OR R2.REQUEST_ID IN (SELECT REQUEST_ID
FROM FND_CONCURRENT_WORKER_REQUESTS
WHERE (QUEUE_APPLICATION_ID != 0 OR CONCURRENT_QUEUE_ID NOT IN (1
, 4))
AND RUNNING_PROCESSES > 0))
AND R2.QUEUE_METHOD_CODE = 'B'
AND ((R2.RUN_ALONE_FLAG = 'Y'
AND R2.CD_ID = R1.CD_ID) OR (R1.QUEUE_METHOD_CODE = 'B'
AND ((R1.SINGLE_THREAD_FLAG = 'Y'
AND R2.SINGLE_THREAD_FLAG = 'Y'
AND R1.REQUESTED_BY = R2.REQUESTED_BY) OR (R1.STATUS_CODE='W'
AND R2.IS_SUB_REQUEST = 'Y'
AND R2.PARENT_REQUEST_ID = R1.REQUEST_ID) OR (R1.REQUEST_LIMIT = 'Y'
AND R2.REQUEST_LIMIT='Y'
AND R1.REQUESTED_BY = R2.REQUESTED_BY) OR ((R2.PROGRAM_APPLICATION_ID
, R2.CONCURRENT_PROGRAM_ID) IN (SELECT RUNNING_APPLICATION_ID
, RUNNING_CONCURRENT_PROGRAM_ID
FROM FND_CONCURRENT_PROGRAM_SERIAL
WHERE TO_RUN_APPLICATION_ID = R1.PROGRAM_APPLICATION_ID
AND TO_RUN_CONCURRENT_PROGRAM_ID = R1.CONCURRENT_PROGRAM_ID
AND (INCOMPATIBILITY_TYPE = 'G' OR R2.CD_ID = R1.CD_ID)))))) ORDER BY REQID
, WREQID