User Accounts – Basic Details

-- ##############################################################################
--      BASIC USER ACCOUNTS
-- ##############################################################################

     select fu.user_id
          , fu.user_name
          , fu.description
          , fu.email_address
          , fu.employee_id
          , fu.last_logon_date
          , to_char(fu.start_date, 'DD-MON-YYYY') start_date
          , to_char(fu.end_date, 'DD-MON-YYYY') end_date
          , fu.password_lifespan_days pwd_days
          , fu.password_date
          , ppx.full_name hr_full_name
       from fnd_user fu
  left join per_people_x ppx on fu.employee_id = ppx.person_id
      where 1 = 1
--        and lower(fu.email_address) like '%bob%'
        and fu.user_name = 'BOBHOPE'
   order by fu.user_name;

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*