select fu.user_name 用户名,

       fu.description 描述,

       (select ppf.FULL_NAME

          from per_people_f ppf

         where ppf.PERSON_ID = fu.employee_id

           and trunc(sysdate) between trunc(ppf.EFFECTIVE_START_DATE) and

               trunc(ppf.EFFECTIVE_END_DATE)) 人员姓名

  from fnd_user fu

 --where fu.description like '%制造%'