select fcp.concurrent_program_name, fcp.USER_CONCURRENT_PROGRAM_NAME, fcp.DESCRIPTION, fcr.argument_text, fcr.actual_start_date
from fnd_concurrent_requests fcr,fnd_concurrent_programs_vl fcp
where fcr.concurrent_program_id=fcp.concurrent_program_id
and to_char(fcr.actual_start_date,'YYYY-MM-DD')>= to_char(sysdate-&last_n_days,'YYYY-MM-DD')
and (fcp.concurrent_program_name='&your_program_name'
orfcp.USER_CONCURRENT_PROGRAM_NAME='&your_program_user_name');
报表的程序简称自己会找吧?
&last_n_days统计最近多少天
&your_program_name你要统计的报表程序简称
&your_program_user_name你要统计的报表程序的全称(提交请求时看到的名字)
|