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