Tag: user

  • Concurrent requests / programs executed by a specific user

    Get details of concurrent requests / programs that are executed by a specific user from a specific responsibility between certain dates. SELECT fcp.user_concurrent_program_name, fcr.request_id, fcr.request_date, fu.user_name Requested_By , fr.responsibility_name FROM fnd_concurrent_requests fcr , fnd_concurrent_programs_tl fcp , fnd_user fu , fnd_responsibility_tl fr WHERE 1 =1 AND fcr.concurrent_program_id = fcp.concurrent_program_id AND fcr.requested_by = fu.user_id AND fcr.responsibility_id =…