Wednesday 19 June 2013

Oracle Form finding querie

  select form_name          
     ,      u1.user_name      
     ,      to_char(f.creation_date)  
     ,      u2.user_name     
     ,      to_char(f.last_update_date)
     from   fnd_form             f
     ,      fnd_user             u1
     ,      fnd_user             u2
     where  (  f.created_by not  in (1,-1,0,2,120)
         or    f.last_updated_by not in (1,-1,0,2,120))
     and    u1.user_id(+)         = f.created_by
     and    u2.user_id(+)         = f.last_updated_by

No comments:

Post a Comment