SELECT a.request_id "Req Id" ,
a.phase_code,
a.status_code ,
actual_start_date ,
actual_completion_date ,
c.concurrent_program_name
|| ': '
|| ctl.user_concurrent_program_name "program"
FROM APPLSYS.fnd_Concurrent_requests a,
APPLSYS.fnd_concurrent_processes b,
applsys.fnd_concurrent_queues q ,
APPLSYS.fnd_concurrent_programs c ,
APPLSYS.fnd_concurrent_programs_tl ctl
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.status_code = 'E'
AND a.phase_code = 'C'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND ctl.LANGUAGE = 'US'
ORDER BY 5 DESC;
a.phase_code,
a.status_code ,
actual_start_date ,
actual_completion_date ,
c.concurrent_program_name
|| ': '
|| ctl.user_concurrent_program_name "program"
FROM APPLSYS.fnd_Concurrent_requests a,
APPLSYS.fnd_concurrent_processes b,
applsys.fnd_concurrent_queues q ,
APPLSYS.fnd_concurrent_programs c ,
APPLSYS.fnd_concurrent_programs_tl ctl
WHERE a.controlling_manager = b.concurrent_process_id
AND a.concurrent_program_id = c.concurrent_program_id
AND a.program_application_id = c.application_id
AND a.status_code = 'E'
AND a.phase_code = 'C'
AND b.queue_application_id = q.application_id
AND b.concurrent_queue_id = q.concurrent_queue_id
AND ctl.concurrent_program_id = c.concurrent_program_id
AND ctl.LANGUAGE = 'US'
ORDER BY 5 DESC;
No comments:
Post a Comment