NM.Mathan Oracle Apps DBA
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment