responsibility_prompt

/* Formatted on 1/31/2012 2:54:26 PM (QP5 v5.115.810.9015) */
  SELECT   a.responsibility_id,
           a.responsibility_name,
           k.application_name,
           y.responsibility_key,
           d.user_menu_name menu_name,
           c.request_group_name request_group,
           k.application_name requset_application_name,
           x.data_group_name,
           k.application_name AS data_application_name,
           DECODE (b.rule_type,
                   'F',
                   'Function',
                   'M',
                   'Menu')
              "Rule Type",
           Z.PROMPT,
           e.user_function_name,
           f.user_menu_name
    FROM   fnd_responsibility_vl a,
           fnd_application_tl k,
           fnd_resp_functions b,
           fnd_request_groups c,
           fnd_menus_vl d,
           fnd_form_functions_tl e,
           FND_MENU_ENTRIES_VL z,                            ---  FND_MENUS_VL
           fnd_menus_tl f,
           fnd_data_groups x,
           fnd_responsibility y
   WHERE       a.data_group_id = x.data_group_id
           AND a.application_id = k.application_id
           AND y.responsibility_id = a.responsibility_id
           AND Z.MENU_ID(+) = D.MENU_ID
           AND a.application_id = b.application_id(+)
           AND a.responsibility_id = b.responsibility_id(+)
           AND a.application_id = c.application_id(+)
           AND a.request_group_id = c.request_group_id(+)
           AND a.menu_id = d.menu_id(+)
           AND b.action_id = e.function_id(+)
           AND b.action_id = f.menu_id(+)
           AND a.responsibility_name IN
                    ('GL Centra User SGU')    
GROUP BY   a.responsibility_id,
           a.responsibility_name,
           k.application_name,
           d.user_menu_name,
           k.application_name,
           c.request_group_name,
           k.application_name,
           x.data_group_name,
           k.application_name,
           DECODE (b.rule_type,
                   'F',
                   'Function',
                   'M',
                   'Menu'),
           Z.PROMPT,
           e.user_function_name,
           f.user_menu_name,
           y.responsibility_key
ORDER BY   a.responsibility_id