Thursday, 26 December 2013

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;

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete