Oracle Applications :Responsibility Menu Query

Oracle Applications :Responsibility Menu Query

SELECT   fu.user_name,
           fu.description,
           furg.start_date,
           frvl.responsibility_name,
           fff.function_name,
           fff.USER_FUNCTION_NAME,
           ff.form_name,
           ff.USER_FORM_NAME
    FROM   fnd_user fu,
           fnd_user_resp_groups furg,
           fnd_responsibility_vl frvl,
           fnd_compiled_menu_functions fcmf,
           fnd_form_functions_vl fff,
           fnd_form_vl ff
   WHERE       fu.user_id = furg.user_id
           AND furg.responsibility_id = frvl.responsibility_id
           AND frvl.menu_id = fcmf.menu_id
           AND fff.function_id = fcmf.function_id
           AND fff.form_id = ff.form_id(+)
           and fcmf.GRANT_FLAG='Y'
           AND (frvl.responsibility_name LIKE '%AP%SUPER%') 

           AND (fu.end_date IS NULL OR fu.end_date >= SYSDATE)
           AND (furg.end_date IS NULL OR furg.end_date >= SYSDATE)
           AND (frvl.end_date IS NULL OR frvl.end_date >= SYSDATE)
          ORDER BY   frvl.responsibility_name;