vrijdag 7 juni 2013

Query concurrent requests

Just for sharing ...



select p.concurrent_program_name
,      p.description
,      r.request_id
,      to_char(r.actual_start_date,'dd-mm-yyyy hh24:mi:ss')      actual_start_date
,      to_char(r.actual_completion_date,'dd-mm-yyyy hh24:mi:ss') actual_completion_date
from   fnd_concurrent_programs_vl p
,      fnd_concurrent_requests r
where  r.concurrent_program_id = p.concurrent_program_id
order by r.actual_start_date desc

2 opmerkingen: