SELECT fcp.concurrent_program_name \u5e76\u53d1\u4ee3\u7801,
\ndecode(fcre.description,
\nNULL,
\nfcpt.user_concurrent_program_name,
\nfcre.description || ‘ (‘ || fcpt.user_concurrent_program_name || ‘)’) \u8bf7\u6c42\u540d\u79f0,
\nfu.user_name \u7528\u6237\u540d,
\nconc.request_id \u8bf7\u6c42ID,
\nconc.root_request_id \u7236\u8bf7\u6c42ID,
\ndecode(fcre.status_code,
\n‘D’,
\n‘Cancelled’,
\n‘U’,
\n‘Disabled’,
\n‘E’,
\n‘Error’,
\n‘M’,
\n‘No Manager’,
\n‘R’,
\n‘Normal’,
\n‘H’,
\n‘On Hold’,
\n‘W’,
\n‘Paused’,
\n‘B’,
\n‘Resuming’,
\n‘I’,
\n‘Scheduled’,
\n‘Q’,
\n‘Standby’,
\n‘S’,
\n‘Suspended’,
\n‘X’,
\n‘Terminated’,
\n‘T’,
\n‘Terminating’,
\n‘A’,
\n‘Waiting’,
\n‘G’,
\n‘Warning’) \u8bf7\u6c42\u72b6\u6001,<\/p>\n
fcre.argument_text \u8bf7\u6c42\u53c2\u6570,
\nsche.job_class \u8ba1\u5212\u7c7b\u578b,
\nsche.class_info \u9891\u7387<\/p>\n
FROM apps.fnd_concurrent_programs fcp,
\napps.fnd_concurrent_programs_tl fcpt,
\napps.fnd_concurrent_requests fcre,
\napps.fnd_user fu,
\n(SELECT owner_req_id,
\ndate1 start_date,
\ndate2 end_date,
\ndecode(class_type, ‘S’, ‘Specific Days’, ‘P’, ‘Periodically’) job_class,
\ndecode(class_type,
\n‘P’,
\nsubstr(class_info, 1, instr(class_info, ‘:’) – 1) ||
\ndecode(substr(class_info, instr(class_info, ‘:’) + 1, 1),
\n‘D’,
\n‘Days’,
\n‘H’,
\n‘Hours’,
\n‘N’,
\n‘Minutes’,
\n‘M’,
\n‘Months’,
\n‘W’,
\n‘Weeks’),
\n‘S’,
\nclass_info) class_info
\nFROM apps.fnd_conc_release_classes fcr<\/p>\n
WHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
\nAND enabled_flag = ‘Y’
\nAND (date2 IS NULL OR date2 > SYSDATE)
\nAND owner_req_id IS NOT NULL) sche,<\/p>\n
(SELECT MAX(request_id) request_id, root_request_id
\nFROM apps.fnd_concurrent_requests
\nWHERE root_request_id IN
\n(SELECT nvl(root_request_id, request_id) request_id
\nFROM apps.fnd_concurrent_requests
\nWHERE request_id IN
\n(SELECT owner_req_id
\nFROM apps.fnd_conc_release_classes fcr
\nWHERE class_type IN (‘S’, ‘P’) –Periodically and Specific Concurrent
\nAND enabled_flag = ‘Y’
\nAND (date2 IS NULL OR date2 > SYSDATE)
\nAND owner_req_id IS NOT NULL)
\nAND status_code <> ‘D’)
\nGROUP BY root_request_id) concWHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
\nAND fcpt.language = ‘ZHS’
\nAND fcp.concurrent_program_id = fcre.concurrent_program_id
\nAND fcre.status_code NOT IN (‘D’, ‘X’, ‘U’) –Cancelled and Terminated and Disabled
\nAND fcre.request_id = conc.request_id
\nAND conc.request_id = sche.owner_req_id
\nAND fcre.requested_by = fu.user_id<\/p>\n","protected":false},"excerpt":{"rendered":"
SELECT fcp.concurrent_program_name \u5e76\u53d1\u4ee3\u7801, decode(fcre.de … \u7ee7\u7eed\u9605\u8bfbOracle\u8ba1\u5212\u8bf7\u6c42\u4fe1\u606f<\/span>