Work Requests

SELECT *

  FROM wip.wip_eam_work_requests wewr;

 

  SELECT fu.user_name

       , fu.description

       , wewr.*

    FROM wip.wip_eam_work_requests wewr

       , applsys.fnd_user fu

   WHERE wewr.created_by = fu.user_id

     AND wewr.creation_date > '19-JUL-2013'

ORDER BY wewr.creation_date DESC;