Saturday, August 16, 2008

Identify concurrent requests using a specific printer.

select
to_char(fcr.actual_completion_date,'dd-mon-yyyy:hh24:mi')||' '||
fcr.request_id||' '||
fu.user_name||' '||
fcp.user_concurrent_program_name
from fnd_concurrent_requests fcr, fnd_concurrent_programs_tl fcp, fnd_user fu
where fcr.concurrent_program_id = fcp.concurrent_program_id
and fcr.requested_by = fu.user_id
and fcp.language = 'US'
and fcr.number_of_copies > 0
and upper('hkfinp09') like upper(fcr.printer)
and sysdate - fcr.actual_completion_date < 30
order by fcr.actual_completion_date;