Friday, October 14, 2016

Find the Completed Concurrent Program for more than 1 Hour


SELECT b.request_id, a.user_concurrent_program_name, b.cancel_or_hold,
           TO_CHAR (b.actual_start_date, 'MM/DD/YY HH24:MI:SS') starttime,
           TO_CHAR (b.actual_completion_date, 'MM/DD/YY HH24:MI:SS') endtime,
           ROUND ((b.actual_completion_date - b.actual_start_date) * (60 * 24),
                  2
                 ) runtime,
           b.outcome_code, b.completion_text
      FROM fnd_concurrent_programs_tl a, fnd_concurrent_requests b
     WHERE A.CONCURRENT_PROGRAM_ID = B.CONCURRENT_PROGRAM_ID
   AND B.ACTUAL_START_DATE > SYSDATE - 1
   AND ROUND ((actual_completion_date - actual_start_date) * (60 * 24), 2) > 60
      AND a.LANGUAGE = 'US';

No comments:

Post a Comment