APPS.FND_DIAG_REQUEST_ANALYZER dependencies on FND_CONCURRENT_QUEUES_VL

Line 88: FROM fnd_concurrent_queues_vl fcqv,

84: SELECT user_concurrent_queue_name name,
85: fcwr.running_processes active,
86: decode(fcwr.control_code, 'A', fl.meaning, 'D', fl.meaning, 'E', fl.meaning, 'N', fl.meaning, 'R', fl.meaning, 'T',
87: fl.meaning, 'U', fl.meaning, 'V', fl.meaning, 'X', fl.meaning, NULL, 'Running', '** Unknown Status **') status
88: FROM fnd_concurrent_queues_vl fcqv,
89: fnd_concurrent_worker_requests fcwr,
90: fnd_lookups fl
91: WHERE fcwr.request_id = rid
92: AND fcwr.concurrent_queue_id = fcqv.concurrent_queue_id

Line 173: mgrname fnd_concurrent_queues_vl.user_concurrent_queue_name%TYPE;

169: mgr_workshift boolean;
170: mgr_running boolean;
171: run_alone boolean;
172: reqlimit boolean := FALSE;
173: mgrname fnd_concurrent_queues_vl.user_concurrent_queue_name%TYPE;
174: filename VARCHAR2(255);
175: qcf fnd_concurrent_programs.queue_control_flag%TYPE;
176: req_notfound
177:

Line 355: FROM fnd_concurrent_queues_vl

351:
352: BEGIN
353: SELECT user_concurrent_queue_name
354: INTO mgrname
355: FROM fnd_concurrent_queues_vl
356: WHERE concurrent_queue_id = reqinfo.controlling_manager;
357: note := jtf_diag_report_factory.create_note('It was run by manager: ' || mgrname, reportcontext);
358: inner_section.add_note(note);
359:

Line 397: FROM fnd_concurrent_queues_vl

393: inner_section.add_note(note);
394: BEGIN
395: SELECT user_concurrent_queue_name
396: INTO mgrname
397: FROM fnd_concurrent_queues_vl
398: WHERE concurrent_queue_id = reqinfo.controlling_manager;
399: note := jtf_diag_report_factory.create_note('It is being run by manager: ' || mgrname, reportcontext);
400: inner_section.add_note(note);
401: