Query to find Sub menu, Menu, userS attached to a responsibility in Oracle EBS R12.2
SELECT fu.user_name, frtl.responsibility_name, FFL.USER_FUNCTION_NAME,FF.FUNCTION_NAME, CASE WHEN frtl.responsibility_name LIKE '%KBNA%' THEN 'KBNA' WHEN frtl.responsibility_name LIKE '%JATM%' THEN 'JATM' WHEN frtl.responsibility_name LIKE '%JNA%' THEN 'JNA' WHEN frtl.responsibility_name LIKE '%KCI%' THEN 'KCI' WHEN frtl.responsibility_name LIKE '%JATX%' THEN 'JATX' WHEN frtl.responsibility_name LIKE '%JASC%' THEN 'JASC' WHEN frtl.responsibility_name LIKE '%KBCA%' THEN 'KBCA' WHEN frtl.responsibility_name LIKE '%JAMX%' THEN 'JAMX' WHEN frtl.responsibility_name LIKE '%KMX%' THEN 'KMX' WHEN frtl.responsibility_name LIKE '%JANA%' THEN 'JANA' WHEN frtl.responsibility_name LIKE '%JATV%