Oracle计划请求信息

SELECT fcp.concurrent_program_name 并发代码,
decode(fcre.description,
NULL,
fcpt.user_concurrent_program_name,
fcre.description || ‘ (‘ || fcpt.user_concurrent_program_name || ‘)’) 请求名称,
fu.user_name 用户名,
conc.request_id 请求ID,
conc.root_request_id 父请求ID,
decode(fcre.status_code,
‘D’,
‘Cancelled’,
‘U’,
‘Disabled’,
‘E’,
‘Error’,
‘M’,
‘No Manager’,
‘R’,
‘Normal’,
‘H’,
‘On Hold’,
‘W’,
‘Paused’,
‘B’,
‘Resuming’,
‘I’,
‘Scheduled’,
‘Q’,
‘Standby’,
‘S’,
‘Suspended’,
‘X’,
‘Terminated’,
‘T’,
‘Terminating’,
‘A’,
‘Waiting’,
‘G’,
‘Warning’) 请求状态,

fcre.argument_text 请求参数,
sche.job_class 计划类型,
sche.class_info 频率

FROM apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl fcpt,
apps.fnd_concurrent_requests fcre,
apps.fnd_user fu,
(SELECT owner_req_id,
date1 start_date,
date2 end_date,
decode(class_type, ‘S’, ‘Specific Days’, ‘P’, ‘Periodically’) job_class,
decode(class_type,
‘P’,
substr(class_info, 1, instr(class_info, ‘:’) – 1) ||
decode(substr(class_info, instr(class_info, ‘:’) + 1, 1),
‘D’,
‘Days’,
‘H’,
‘Hours’,
‘N’,
‘Minutes’,
‘M’,
‘Months’,
‘W’,
‘Weeks’),
‘S’,
class_info) class_info
FROM apps.fnd_conc_release_classes fcr

WHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
AND enabled_flag = ‘Y’
AND (date2 IS NULL OR date2 > SYSDATE)
AND owner_req_id IS NOT NULL) sche,

(SELECT MAX(request_id) request_id, root_request_id
FROM apps.fnd_concurrent_requests
WHERE root_request_id IN
(SELECT nvl(root_request_id, request_id) request_id
FROM apps.fnd_concurrent_requests
WHERE request_id IN
(SELECT owner_req_id
FROM apps.fnd_conc_release_classes fcr
WHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
AND enabled_flag = ‘Y’
AND (date2 IS NULL OR date2 > SYSDATE)
AND owner_req_id IS NOT NULL)
AND status_code <> ‘D’)
GROUP BY root_request_id) concWHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.language = ‘ZHS’
AND fcp.concurrent_program_id = fcre.concurrent_program_id
AND fcre.status_code NOT IN (‘D’, ‘X’, ‘U’) –Cancelled and Terminated and Disabled
AND fcre.request_id = conc.request_id
AND conc.request_id = sche.owner_req_id
AND fcre.requested_by = fu.user_id

发表评论

邮箱地址不会被公开。 必填项已用*标注