/* 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