SELECT fcp.concurrent_program_name, fcpt.user_concurrent_program_name
FROM fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt
WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND fcp.concurrent_program_id IN
(SELECT concurrent_program_id
FROM fnd_concurrent_requests
WHERE status_code NOT IN ('D', 'X')
AND request_id IN
(SELECT DISTINCT owner_req_id
FROM applsys.fnd_conc_release_classes fcr
WHERE class_type IN ('S', 'P')
AND (date2 IS NULL OR date2 > SYSDATE)))
FROM fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt
WHERE fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND fcp.concurrent_program_id IN
(SELECT concurrent_program_id
FROM fnd_concurrent_requests
WHERE status_code NOT IN ('D', 'X')
AND request_id IN
(SELECT DISTINCT owner_req_id
FROM applsys.fnd_conc_release_classes fcr
WHERE class_type IN ('S', 'P')
AND (date2 IS NULL OR date2 > SYSDATE)))
PS: Concurrent Status:
Cancelled: D
Disabled: U
Error: E
No Manager: M
Normal: R
On Hold: H
Paused: W
Resuming: B
Scheduled: I
Standby: Q
Suspended: S
Terminated: X
Terminating: T
Waiting: A
Warning: G
Disabled: U
Error: E
No Manager: M
Normal: R
On Hold: H
Paused: W
Resuming: B
Scheduled: I
Standby: Q
Suspended: S
Terminated: X
Terminating: T
Waiting: A
Warning: G
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10359218/viewspace-677427/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
