0 Replies Latest reply on Nov 23, 2015 3:46 PM by 2986524

    Manage Proxy - how to get type of access


      I am able to see from_user and to_user for worklist access using below query.

      select menu_name from fnd_menus fndm, fnd_grants fndg

      where grantee_key = 'USER_B'

      and fndg.menu_id in (1015915,1017383)

      and fndg.menu_id = fndm.menu_id

      and program_name = 'PROXY'

      and start_date <= sysdate

      and (end_date is null OR end_date >= sysdate);

      I need to know what type of acces is provided like requisition approval or expense approval, etc.