Thursday, 10 May 2012

Total Request by user


select fu.user_name,COUNT(*) COUNT from APPLSYS.fnd_Concurrent_requests a,apps.fnd_user fu
where  a.requested_by = fu.user_id
AND a.phase_code = 'C'
AND a.status_code = 'C'
AND a.actual_start_date  like ('%09-MAY-12%')
group by user_name;

No comments:

Post a Comment