Way to success...

--"Running Away From Any PROBLEM Only Increases The DISTANCE From The SOLUTION"--.....--"Your Thoughts Create Your FUTURE"--.....--"EXCELLENCE is not ACT but a HABIT"--.....--"EXPECT nothing and APPRECIATE everything"--.....

Tuesday, December 22, 2015

Query to list all responsibilities with their excluded functions and menus



SELECT frv.responsibility_name,
       DECODE (frf.rule_type,
               'F', 'Function',
               'M', 'Menu',
               rule_type
              ) exclusion_type,
       DECODE (frf.rule_type,
               'F', (SELECT function_name || ',' || description
                       FROM fnd_form_functions_vl fnc
                      WHERE fnc.function_id = frf.action_id),
               'M', (SELECT menu_name || ',' || description
                       FROM fnd_menus_vl imn
                      WHERE imn.menu_id = frf.action_id),
               TO_CHAR (frf.action_id)
              ) excluded_menu_or_func
  FROM apps.fnd_resp_functions frf,
       apps.fnd_responsibility_vl frv
WHERE frf.responsibility_id = frv.responsibility_id
--and frv.responsibility_id = '64186';

No comments:

Post a Comment