EBS 系统当前完成请求时间监测

/* Formatted on 2018/3/14 23:32:17 (QP5 v5.256.13226.35538) */

  SELECT REQUEST_ID

       , PROGRAM

       , ROUND ( (TO_NUMBER (LAST_UPDATE_DATE - REQUESTED_START_DATE) * 24 * 60) / 60, 2) 待定时间

       , ROUND ( (TO_NUMBER (ACTUAL_COMPLETION_DATE - LAST_UPDATE_DATE) * 24 * 60) / 60, 2) 运行时间

       , '小时' 单位

       , REQUESTED_START_DATE 提交日期

       , LAST_UPDATE_DATE 起始日期

       , ACTUAL_COMPLETION_DATE 完成日期

       , PROGRAM_SHORT_NAME

       , ARGUMENT_TEXT

       , COMPLETION_TEXT

       , RESPONSIBILITY_APPLICATION_ID

       , STATUS_CODE

       , PRIORITY_REQUEST_ID

       , REQUESTOR

    FROM FND_CONC_REQ_SUMMARY_V

   WHERE 1 = 1

     AND PHASE_CODE = 'C'

     AND (NVL (request_type, 'X') != 'S')

     AND (TRUNC (request_date) >= TRUNC (SYSDATE - 7))

     AND ROUND ( (TO_NUMBER (ACTUAL_COMPLETION_DATE - LAST_UPDATE_DATE) * 24 * 60) / 60, 2) > 0.1                                            --6分钟以上程序

ORDER BY 运行时间 DESC, PROGRAM_SHORT_NAME, REQUEST_ID DESC