To find specific responsibility having by which users

SELECT fu.user_name "User Name",

  fu.description,

  frt.responsibility_name "Responsibility Name",

  furg.start_date "Start Date",

  furg.end_date "End Date",

  fr.responsibility_key "Responsibility Key",

  fa.application_short_name "Application Short Name"

FROM apps.fnd_user_resp_groups_direct furg,

  apps.fnd_user fu,

  apps.fnd_responsibility_tl frt,

  apps.fnd_responsibility fr,

  apps.fnd_application_tl fat,

  apps.fnd_application fa

WHERE furg.user_id           = fu.user_id

  AND furg.responsibility_id = frt.responsibility_id

  AND fr.responsibility_id   = frt.responsibility_id

  AND fa.application_id      = fat.application_id

  AND fr.application_id      = fat.application_id

  AND frt.language           = userenv('LANG')

  AND upper(fu.user_name)    = upper('JELU') -- <change it>

  AND

  (

    furg.end_date    IS NULL

    OR furg.end_date >= TRUNC(sysdate)

  )

  AND frt.responsibility_name = 'CRM Administrator';-- <change it>