DBA Data[Home] [Help]

APPS.FND_DIAG_REQUEST_ANALYZER dependencies on FND_CONCURRENT_WORKER_REQUESTS

Line 35: FROM fnd_concurrent_worker_requests

31: 'X', 'N', -- Aborted
32: 'D', 'N', -- Deactivate
33: 'E', 'N', -- Deactivated
34: 'Y') active
35: FROM fnd_concurrent_worker_requests
36: WHERE request_id = rid
37: AND NOT((queue_application_id = 0)
38: AND(concurrent_queue_id IN(1, 4)));
39: run_alone_flag VARCHAR2(1);

Line 89: fnd_concurrent_worker_requests fcwr,

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
93: AND fcwr.concurrent_queue_id NOT IN(1, 4)