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[@more@]
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/81023/viewspace-799850/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81023/viewspace-799850/