如何查看非自己提交的请求的结果代码,OracleEBS代码库,德仔网

代码语言

代码分类

【OracleEBS】如何查看非自己提交的请求的结果

作者:专注Oracle EBS / 发布于2012/11/29/ 1008

SELECT fcrv.PHASE_CODE                 阶段,
       fcrv.STATUS_CODE                状态,
       fcrv.PRIORITY                   优先级,
       fcrv.REQUEST_DATE               请求日期,
       fcrv.REQUESTED_START_DATE       请求开始时间,
       fcrv.PROGRAM                    请求名称,
       fcrv.REQUESTOR                  请求人,
       fcr.resubmit_interval           请求间隔时间,
       fcr.resubmit_interval_unit_code 请求间隔单位,
       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 = 'I' --已计划
   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'

试试其它关键字

　提交的请求的结果　

同语言下

可能有用的

专注Oracle EBS贡献的其它代码(66)