Posts

Showing posts from April, 2024

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.responsi...