SELECT fu.user_name,
fu.description,
request_id,
fcp.user_concurrent_program_name,
actual_start_date,
TRUNC ( (SYSDATE - actual_start_date) * 24, 2) time_in_hours
FROM apps.fnd_concurrent_requests fcr,
apps.fnd_concurrent_programs_vl fcp,
apps.fnd_user fu
WHERE actual_start_date LIKE SYSDATE
AND fcr.request_date > TRUNC (SYSDATE)
AND status_code = 'R'
AND phase_code = 'R'
AND fcr.concurrent_program_id = fcp.concurrent_program_id
AND fu.user_id(+) = fcr.requested_by
AND TRUNC ( (SYSDATE - actual_start_date) * 24, 2) > 1
-- AND fcp.concurrent_program_id = 750966
ORDER BY time_in_hours DESC
No comments:
Post a Comment