select full_name employee

      ,ltrim(rtrim(employee_number,'N'),'0') Position

      ,supervisor_name supervisor

      ,ltrim(rtrim(supervisor_employee_number,'N'),'0') ReportTo

      ,org_name organization

      ,job_name title

      ,card_type type

      from org_plus_people opp

      where opp.JOB_NAME in ('Director, Laboratory')

     UNION ALL

       select full_name employee

      ,ltrim(rtrim(employee_number,'N'),'0') Position

      ,supervisor_name supervisor

      ,ltrim(rtrim(supervisor_employee_number,'N'),'0') ReportTo

      ,org_name organization

      ,job_name title

      ,card_type type

      from org_plus_people opp

      where card_type IN ('FT','PT','TP','JA')

      and opp.employee_number NOT IN ('10093N')

      and org_name not like ('F.R.A.%')

      and (opp.JOB_NAME not in ('Director, Laboratory')

            or opp.job_name is null)

     UNION ALL

       select full_name employee

      ,ltrim(rtrim(employee_number,'N'),'0') Position

      ,supervisor_name supervisor

      ,ltrim(rtrim(supervisor_employee_number,'N'),'0') ReportTo

      ,org_name organization

      ,job_name title

      ,card_type type

      from org_plus_people opp

      where opp.employee_number IN ('14877N')

     UNION ALL

       select full_name employee

      ,ltrim(rtrim(employee_number,'N'),'0') Position

      ,supervisor_name supervisor

      ,ltrim(rtrim(supervisor_employee_number,'N'),'0') ReportTo

      ,org_name organization

      ,job_name title

      ,card_type type

      from org_plus_people opp

      where opp.employee_number IN ('06155N')

     UNION ALL

      select

      full_name employee

      ,ltrim(rtrim(employee_number,'N'),'0') Position

      ,decode (employee_number,

                '10093N', 'ODDONE, PIERMARIA J',

                null) supervisor

      ,decode (employee_number,

                '10093N', '14265',

                null) ReportTo

      ,org_name organization

      ,job_name title

      ,card_type type

        from org_plus_people

        where employee_number in ('10093N')