查询请求历史记录信息

SELECT fcr.request_id,
fcr.parent_request_id,
fcpv.user_concurrent_program_name,
fcpv.concurrent_program_name,
fl1.meaning || ‘(’ || fcr.status_code || ‘)’ status,
fl2.meaning || ‘(’ || fcr.phase_code || ‘)’ phase,
fcr.actual_start_date,
fcr.actual_completion_date,
(nvl(fcr.actual_completion_date,
SYSDATE) - fcr.actual_start_date) * 24 * 60 “TIME(Minute)”,
–(nvl(fcr.actual_completion_date, SYSDATE) - fcr.actual_start_date) * 86400 / 60 / 60 “TIME(H)”,
fcr.argument_text,
fcr.description,
frv.responsibility_name,
fu.user_name,
per.full_name,
fcr.output_file_type,
fcr.ofile_size,
fcr.priority,
fcr.completion_text,
fcr.logfile_name, –add
fcr.outfile_name –add
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_vl fcpv,
fnd_lookups fl1,
fnd_lookups fl2,
fnd_responsibility_vl frv,
fnd_user fu,
per_people_f per
WHERE fcr.concurrent_program_id = fcpv.concurrent_program_id
AND fcr.program_application_id = fcpv.application_id
AND fl1.lookup_type = ‘CP_STATUS_CODE’ –C Normal,D Cancelled,P Scheduled, G Warning, E Error,…
AND fl1.lookup_code = fcr.status_code
AND fl2.lookup_type = ‘CP_PHASE_CODE’ –C Completed,I Inactive, P pending,R Running
AND fl2.lookup_code = fcr.phase_code
AND frv.responsibility_id = fcr.responsibility_id
AND fu.user_id = fcr.requested_by
AND per.person_id(+) = fu.employee_id
AND SYSDATE BETWEEN per.effective_start_date(+) AND
per.effective_end_date(+)
– AND fcpv.concurrent_program_name = ‘APPMPOCOM’ –并发简称
AND fcpv.user_concurrent_program_name = ‘采购合同打印’–并发名称
ORDER BY fcr.request_id DESC;