Query to find the concurrent programs completed in specific day.

Query to find the concurrent programs completed in specific day.
=====================================================

select
f.request_id ,
pt.user_concurrent_program_name user_conc_program_name,
to_char(f.actual_start_date,’DD-MON-YY HH24:MI:SS’) start_on,
to_char(f.actual_completion_date,’DD-MON-YY HH24:MI:SS’) end_on,
floor(((f.actual_completion_date-f.actual_start_date)
*24*60*60)/3600)
|| ‘ HOURS ‘ ||
floor((((f.actual_completion_date-f.actual_start_date)
*24*60*60) –
floor(((f.actual_completion_date-f.actual_start_date)
*24*60*60)/3600)*3600)/60)
|| ‘ MINUTES ‘ ||
round((((f.actual_completion_date-f.actual_start_date)
*24*60*60) –
floor(((f.actual_completion_date-f.actual_start_date)
*24*60*60)/3600)*3600 –
(floor((((f.actual_completion_date-f.actual_start_date)
*24*60*60) –
floor(((f.actual_completion_date-f.actual_start_date)
*24*60*60)/3600)*3600)/60)*60) ))
|| ‘ SECS ‘ time_difference,
p.concurrent_program_name concurrent_program_name,
decode(f.phase_code,’R’,’Running’,’C’,’Complete’,f.phase_code) Phase,
f.status_code
from  apps.fnd_concurrent_programs p,
apps.fnd_concurrent_programs_tl pt,
apps.fnd_concurrent_requests f
where f.concurrent_program_id = p.concurrent_program_id
and f.program_application_id = p.application_id
and f.concurrent_program_id = pt.concurrent_program_id
and f.program_application_id = pt.application_id
AND pt.language = USERENV(‘Lang’)
and f.actual_start_date like ’21-JAN-18′
order by
f.actual_start_date desc;

  • January 22, 2019 | 29 views
  • Comments