首页 > 数据库 > Oracle > EBS查找运行请求时间,参数等
--查找运行请求时间,参数等(可以是某用户的,某个报表) select c.user_name, papf.full_name, b.user_concurrent_program_name, a.request_date, a.argument_text, (a.actual_completion_date - a.actual_start_date) * 24 * 60 minutes, a.actual_start_date, a.actual_completion_date, a.request_id, a.outfile_name from fnd_concurrent_requests a, fnd_concurrent_programs_vl b, fnd_user c, per_all_people_f papf where a.concurrent_program_id = b.concurrent_program_id and a.requested_by = c.user_id and c.user_name = papf.employee_number(+) and a.actual_completion_date is not null and b.user_concurrent_program_name = '你的程序名称' --- like '%XXX%' and c.user_name = ' 你要找的用户的' and a.request_date <= to_date('2005-03-01 23:59:59', 'yyyy-mm-dd hh24:mi:ss') and a.request_date >= to_date('2005-03-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') and a.request_id > 2254198 ---为了提高速度,选一个合适时间点的ID
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31558081/viewspace-2216398/,如需转载,请注明出处,否则将追究法律责任。