Oracle Ebs 请求运行情况查询

SELECT REQ.REQUEST_ID,
       FCP.USER_CONCURRENT_PROGRAM_NAME,
       USR.USER_NAME,
       REQ.REQUEST_DATE,
       REQ.ACTUAL_START_DATE,
       REQ.ACTUAL_COMPLETION_DATE,
       ROUND((NVL(REQ.ACTUAL_COMPLETION_DATE, SYSDATE) - REQ.ACTUAL_START_DATE)*24*60,2) DAYS,
       REQ.COMPLETION_TEXT,
       REQ.ARGUMENT_TEXT,
       REQ.LOGFILE_NAME,
       REQ.OUTFILE_NAME
  FROM APPLSYS.FND_CONCURRENT_REQUESTS REQ,
       APPS.FND_CONCURRENT_PROGRAMS_VL FCP,
       APPLSYS.FND_USER                USR
 WHERE REQ.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
   AND REQ.REQUESTED_BY = USR.USER_ID
      AND fcp.user_concurrent_program_name = 'Program Name'
      --AND (req.completion_text IS NOT NULL AND req.completion_text <> '正常完成')
   AND REQ.REQUEST_DATE > SYSDATE - 1
   --AND REQ.REQUEST_ID = 66987088
 ORDER BY REQ.REQUEST_DATE DESC

Oracle Ebs 请求运行情况查询
http://localhost:8091//archives/oracleebs%E8%AF%B7%E6%B1%82%E8%BF%90%E8%A1%8C%E6%83%85%E5%86%B5%E6%9F%A5%E8%AF%A2
作者
Administrator
发布于
2021年05月21日
许可协议