select req.request_id 请求编号,
fcp.user_concurrent_program_name 请求名,
usr.user_name 提交人,
(select f.full_name
from per_all_people_f f
where f.person_id = usr.employee_id
and rownum = 1) 提交人全称,
(select req.status_code || ' ' || flv1.meaning
from fnd_lookup_values flv1
where 1 = 1
and flv1.lookup_type = 'CP_STATUS_CODE'
and flv1.language = 'ZHS'
and flv1.lookup_code = req.status_code
and flv1.view_application_id = 0) 请求状态,
decode(req.phase_code,
'C',
'已完成',
'I',
'无效',
'P',
'待定',
'R',
'运行中') 请求阶段,
req.argument_text 请求参数,
req.request_date 请求日期,
req.actual_completion_date 实际编译日期,
round((24 * 60 * 60 *
(nvl(req.actual_completion_date, req.actual_start_date) -
req.actual_start_date)),
2) || '秒' 运行时间,
fcp.concurrent_program_name 并发程序简称,
--- trunc(sysdate) - trunc(request_date) days,
req.logfile_name 日志文件,
req.outfile_name 输出文件,
(select fl.meaning
from fnd_lookups fl
where fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'
and fl.lookup_code = fe.execution_method_code) 执行方法,
fcp.output_file_type 样式,
fe.execution_file_name 可执行,
fcp.concurrent_program_id
from applsys.fnd_concurrent_requests req,
apps.fnd_concurrent_programs_vl fcp,
applsys.fnd_user usr,
fnd_executables fe
where req.concurrent_program_id = fcp.concurrent_program_id
and req.requested_by = usr.user_id
and fe.executable_id = fcp.executable_id
and fcp.user_concurrent_program_name = 'CUXGCCPAY'
and req.argument_text like 'b2e003%'
and to_char(req.request_date, 'yyyy-mm-dd') = to_char(sysdate,'yyyy-mm-dd')
order by req.request_date desc;
SELECT req.request_id 请求编号
,fcp.user_concurrent_program_name 请求名
,(SELECT req.status_code || ' ' || flv1.meaning
FROM fnd_lookup_values flv1
WHERE 1 = 1
AND flv1.lookup_type = 'CP_STATUS_CODE'
AND flv1.language = 'ZHS'
AND flv1.lookup_code = req.status_code
AND flv1.view_application_id = 0) 请求状态
,decode(req.phase_code, 'C', '已完成', 'I', '无效', 'P', '待定', 'R', '运行中') 请求阶段
,req.argument_text 请求参数
,req.request_date 请求日期
,req.actual_completion_date 实际编译日期
,round((24 * 60 * 60 * (nvl(nvl(req.actual_completion_date,sysdate), req.actual_start_date) - req.actual_start_date)), 2) || '秒' 运行时间
,usr.user_id
,usr.user_name 提交人
,(SELECT f.full_name
FROM per_all_people_f f
WHERE f.person_id = usr.employee_id
AND SYSDATE BETWEEN f.effective_start_date AND f.effective_end_date) 提交人全称
,ft.responsibility_name 提交职责
,fcp.concurrent_program_name 并发程序简称
,req.logfile_name 日志文件
,req.outfile_name 输出文件
,(SELECT fl.meaning
FROM fnd_lookups fl
WHERE fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'
AND fl.lookup_code = fe.execution_method_code) 执行方法
,fcp.output_file_type 样式
,fe.execution_file_name 可执行
,fcp.concurrent_program_id
FROM applsys.fnd_concurrent_requests req
,apps.fnd_concurrent_programs_vl fcp
,applsys.fnd_user usr
,apps.fnd_responsibility_tl ft
,fnd_executables fe
WHERE req.concurrent_program_id = fcp.concurrent_program_id
AND req.requested_by = usr.user_id
AND fe.executable_id = fcp.executable_id
AND req.responsibility_application_id = ft.application_id
AND req.responsibility_id = ft.responsibility_id
AND ft.language = 'ZHS'
--AND req.request_id = 58018620
AND fcp.user_concurrent_program_name LIKE 'CUX%事务处理导入%'
ORDER BY req.request_id DESC;
--select 70000/3600 from dual