oracle计划请求,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