/* This script returns information on pending 	*/
/* concurrent program.	*/

select request_id,
       b.user_concurrent_queue_name
from   apps.fnd_concurrent_worker_requests a,
       apps.fnd_concurrent_queues_vl       b
where  a.phase_code  = 'P'
  and  a.status_code = 'I'
  and  a.hold_flag  != 'Y'
  and  a.requested_start_date <= sysdate
  and  a.concurrent_queue_id = b.concurrent_queue_id
  and  a.control_code is null
  and  a.concurrent_queue_name != 'FNDCRM'
 order by
       request_id, b.user_concurrent_queue_name
/