Concurrent Program Last run details:
========================
SELECT to_char(MAX (fcr.REQUEST_DATE)
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcpt
WHERE fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.program_application_id = fcpt.application_id
-- AND fcr.actual_start_date > SYSDATE - 1
AND fcpt.user_concurrent_program_name LIKE '%Program Name%' ;
========================
SELECT to_char(MAX (fcr.REQUEST_DATE)
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcpt
WHERE fcr.concurrent_program_id = fcpt.concurrent_program_id
AND fcr.program_application_id = fcpt.application_id
-- AND fcr.actual_start_date > SYSDATE - 1
AND fcpt.user_concurrent_program_name LIKE '%Program Name%' ;
No comments:
Post a Comment