直接贴代码
select fcrv.PHASE_CODE 阶段,
fcrv.STATUS_CODE 状态,
fcrv.PRIORITY 优先级,
fcrv.REQUEST_ID 请求编号,
fcrv.REQUEST_DATE 请求日期,
fcrv.REQUESTED_START_DATE 请求开始时间,
fcrv.PROGRAM 请求名称,
fcrv.REQUESTOR 请求人,
fcr.resubmit_interval 请求间隔时间,
fcr.resubmit_interval_unit_code 请求间隔单位,
fcrv.ARGUMENT_TEXT,
fcr.logfile_name 日志文件,
fcr.logfile_node_name 日志节点名称,
fcr.outfile_name 输出文件,
fcr.output_file_type 输出文件类型,
frt.responsibility_name 职责
from FND_CONC_REQ_SUMMARY_V fcrv,
fnd_concurrent_requests fcr,
fnd_responsibility_tl frt
where fcrv.STATUS_CODE IN ('I', 'Q') --已计划
and fcrv.REQUEST_ID = fcr.request_id
and fcrv.CONCURRENT_PROGRAM_ID = fcr.concurrent_program_id
and fcrv.RESPONSIBILITY_APPLICATION_ID =
fcr.responsibility_application_id
and fcrv.RESPONSIBILITY_ID = fcr.responsibility_id
and fcrv.RESPONSIBILITY_ID = frt.responsibility_id
and frt.language = 'ZHS'