1 Reply Latest reply on Aug 12, 2014 9:17 PM by Hussein Sawwan-Oracle

    Sql Query to select menu name, function name of a particular responsibility.

    2679929

      Hai,

      I need sql Query to select RESPONSIBILITY_NAME, MENU_NAME, FUNCTION_NAME, FUNCTION DESCRIPTION for a particular responsibility "TPC GL Accountant".

      Can anyone help me out please.

       

      1. select RESPONSIBILITY_ID, RESPONSIBILITY_KEY, RESPONSIBILITY_NAME ,MENU_ID from FND_RESPONSIBILITY_VL;
      2. select MENU_ID, SUB_MENU_ID, FUNCTION_ID from FND_MENU_ENTRIES_VL
      3. 3. select MENU_ID, MENU_NAME from FND_MENUS
      4. select FUNCTION_ID, FUNCTION_NAME, DESCRIPTION from FND_FORM_FUNCTIONS_VL;

       

      Using the above 4 commands I want output of 4 columns

      1. Responsibility name (RESPONSIBILITY_NAME from 1st query)
      2. MENU_NAME ( from 3rd query)
      3. FUNCTION_NAME ( 4th query)
      4. Function Description. (DESCRIPTION from 4th Query).

       

      Please Respond.

       

      Thank you,

      Srikanth.