SELECT fu.user_name user_code,
       fu.description user_name,
       decode(fu.end_date,
              '',
              '在職',
              '離職') status,
       fs.security_group_key security_group,
       fa.application_name applocation,
       fr.responsibility_name,
       fu.start_date,
       fu.end_date
FROM   fnd_user                    fu,
       fnd_user_resp_groups_direct fur,
       fnd_responsibility_vl       fr,
       fnd_application_vl          fa,
       fnd_security_groups   fs
WHERE  fu.user_id = fur.user_id
AND    (fur.end_date IS NULL or trunc(fur.end_date) > trunc(sysdate))
AND    fur.responsibility_id = fr.responsibility_id
AND    fur.responsibility_application_id = fr.application_id
AND    fr.application_id = fa.application_id
and    fur.security_group_id = fs.security_group_id
AND    (fr.end_date IS NULL or trunc(fr.end_date) > trunc(sysdate))
AND    fu.user_name LIKE 'SZ%'
order by 1,5,6;