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)
