EBS query that pulls more details works slow

Hi team,

I know that this question is not related to performance query part but because it is related to pulling data from EBS back end i need some guide how to best manage this.

I have select query which uses subquery to produce results:

SELECT 
  fu.user_name       "User name",  frt.responsibility_name "Responsibility Name" ,
  furg.start_date     "Start Date" ,  furg.end_date      "End Date" ,
  fu.last_logon_date    "Last Logon Date",  fr.responsibility_key  "Responsibility key",
  fu.email_address     "Email Address",  fu.description      "Description" ,
  m.MANAGER_NAME, m.MANAGER_EMAIL   
FROM
  fnd_user_resp_groups_direct   furg,  fnd_user        fu,
  applsys.fnd_responsibility_tl  frt,  applsys.fnd_responsibility   fr, 
 (select distinct e.employee_number