EBS系统计划已请求

直接贴代码

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'