SELECT fcr.request_id
,fcr.argument_text
,fcr.phase_code
,fcr.status_code
,fcr.oracle_process_id
,fcr.os_process_id
,f.user_name
FROM fnd_concurrent_requests fcr
,fnd_user f
WHERE fcr.request_id = :p_request_id
AND fcr.requested_by=f.user_id
No comments:
Post a Comment