Functions assigned to User and Responsibility PLSQL Query - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/12/function-assigned-to-user-and.html

Functions assigned to User and Responsibility PLSQL Query

select fu.USER_NAME, rr.RESPONSIBILITY_NAME, kk.DESCRIPTION, tt.MENU_NAME
  from FND_MENU_ENTRIES_VL   kk,
       FND_MENUS_VL          tt,
       FND_RESPONSIBILITY_VL rr
     
      ,
       FND_USER_RESP_GROUPS_DIRECT ee,
       fnd_user                    fu

 where kk.MENU_ID = tt.MENU_ID
   
   and rr.MENU_ID = kk.MENU_ID
   
   and kk.MENU_ID = rr.MENU_ID
   
   and ee.RESPONSIBILITY_ID = rr.RESPONSIBILITY_ID
   
   and fu.USER_ID = ee.user_id
   
   and kk.FUNCTION_ID = 2850
   
   and ee.END_DATE is null
   
   and fu.END_DATE is null

 order by fu.USER_NAME

Unable to Select Trading Partner Legal Entities From Trading Partner LOV While Defining Intercompany

http://generalledger-gl.blogspot.com/2016/12/i-had-same-issue-i-was-able-to-use-lov.html

I had the same issue , I was able to use the LOV by entering first character of Legal Entity and LOV worked. Ex: N% and LOV showed the legal entity name for our setup.