/* Formatted on 7/17/2014 1:17:36 PM (QP5 v5.115.810.9015) */
SELECT prog.concurrent_program_id,
prog.concurrent_program_name,
prog.user_concurrent_program_name,
req.request_id,
TO_CHAR (req.actual_start_date, 'DD-MON-YYYY HH24:MI:SS')
actual_start_date,
TO_CHAR (req.actual_completion_date, 'DD-MON-YYYY HH24:MI:SS')
actual_completion_date,
FLOOR ( (actual_completion_date - actual_start_date) * 24) || ':'
|| FLOOR( ( (actual_completion_date - actual_start_date) * 24
- FLOOR ( (actual_completion_date - actual_start_date) * 24))
* 60)
|| ':'
|| FLOOR( ( (actual_completion_date - actual_start_date) * 24 * 60
- FLOOR( (actual_completion_date - actual_start_date)
* 24
* 60))
* 60)
duration,
argument_text,
usr.user_name,
resp.responsibility_name
FROM apps.fnd_concurrent_programs_vl prog,
apps.fnd_concurrent_requests req,
apps.fnd_responsibility_vl resp,
apps.fnd_user usr
WHERE (prog.user_concurrent_program_name = 'Workflow Background Process'
OR prog.user_concurrent_program_name LIKE
'Workflow Background Process'
OR prog.concurrent_program_name LIKE 'APPBCF')
AND prog.concurrent_program_id = req.concurrent_program_id
AND prog.application_id = req.program_application_id
AND req.responsibility_id = resp.responsibility_id
AND req.responsibility_application_id = resp.application_id
AND req.requested_by = usr.user_id
/* AND argument_text like '%OEO%' */
AND req.actual_start_date > SYSDATE - 10
ORDER BY prog.user_concurrent_program_name, req.actual_start_date DESC
SELECT prog.concurrent_program_id,
prog.concurrent_program_name,
prog.user_concurrent_program_name,
req.request_id,
TO_CHAR (req.actual_start_date, 'DD-MON-YYYY HH24:MI:SS')
actual_start_date,
TO_CHAR (req.actual_completion_date, 'DD-MON-YYYY HH24:MI:SS')
actual_completion_date,
FLOOR ( (actual_completion_date - actual_start_date) * 24) || ':'
|| FLOOR( ( (actual_completion_date - actual_start_date) * 24
- FLOOR ( (actual_completion_date - actual_start_date) * 24))
* 60)
|| ':'
|| FLOOR( ( (actual_completion_date - actual_start_date) * 24 * 60
- FLOOR( (actual_completion_date - actual_start_date)
* 24
* 60))
* 60)
duration,
argument_text,
usr.user_name,
resp.responsibility_name
FROM apps.fnd_concurrent_programs_vl prog,
apps.fnd_concurrent_requests req,
apps.fnd_responsibility_vl resp,
apps.fnd_user usr
WHERE (prog.user_concurrent_program_name = 'Workflow Background Process'
OR prog.user_concurrent_program_name LIKE
'Workflow Background Process'
OR prog.concurrent_program_name LIKE 'APPBCF')
AND prog.concurrent_program_id = req.concurrent_program_id
AND prog.application_id = req.program_application_id
AND req.responsibility_id = resp.responsibility_id
AND req.responsibility_application_id = resp.application_id
AND req.requested_by = usr.user_id
/* AND argument_text like '%OEO%' */
AND req.actual_start_date > SYSDATE - 10
ORDER BY prog.user_concurrent_program_name, req.actual_start_date DESC
No comments:
Post a Comment