Oracle 请求运行查询 

 1 SELECT request_id 请求id,
 2        program 请求名称,
 3        argument_text 请求参数,
 4        (SELECT fl.meaning
 5           FROM cux_fnd_lookups fl
 6          WHERE fl.lookup_code = phase_code
 7            AND fl.enabled_flag = 'Y'
 8            AND fl.lookup_type = 'CP_PHASE_CODE') 阶段,
 9        (SELECT fl.meaning
10           FROM cux_fnd_lookups fl
11          WHERE fl.lookup_code = status_code
12            AND fl.enabled_flag = 'Y'
13            AND fl.lookup_type = 'CP_STATUS_CODE') 状态,
14        requestor 提交人账号,
15        (SELECT fu.description
16           FROM fnd_user fu
17          WHERE fu.user_name = requestor) 提交人姓名,
18        requested_start_date 请求提交时间,
19        actual_start_date 请求起始时间,
20        actual_completion_date 请求完成时间,
21        decode(phase_code,
22               'C',
23               substr(CAST(actual_completion_date AS TIMESTAMP) -
24                      CAST(actual_start_date AS TIMESTAMP),
25                      12,
26                      8),
27               'P',
28               substr(CAST(SYSDATE AS TIMESTAMP) -
29                      CAST(requested_start_date AS TIMESTAMP),
30                      12,
31                      8),
32               'R',
33               substr(CAST(SYSDATE AS TIMESTAMP) -
34                      CAST(actual_start_date AS TIMESTAMP),
35                      12,
36                      8)) 请求运行时间,
37        program_short_name 请求可执行名称,
38        hold_flag,
39        queue_method_code
40   FROM fnd_conc_req_summary_v
41  WHERE (decode(implicit_code, 'N', status_code, 'E', 'E', 'W', 'G') =
42        status_code OR decode(implicit_code, 'W', 'E') = status_code OR
43        decode(implicit_code, 'Y', status_code) = status_code)
44    AND (nvl(request_type, 'X') != 'S')
45    AND trunc(requested_start_date) BETWEEN trunc(SYSDATE) AND
46        trunc(SYSDATE)

 

posted @ 2020-09-28 15:19  kiko_0926  阅读(340)  评论(0)    收藏  举报