Sunday 2 February 2020

Find all responsibility of Form in Oracle EBS



--Responsibility on the base of Form
SELECT fr.*
  FROM FND_MENU_ENTRIES FME, FND_RESPONSIBILITY_VL fr
 WHERE     EXISTS
               (SELECT 'FUNCTION_ID'
                  FROM FND_FORM FF, FND_FORM_FUNCTIONS F3
                 WHERE     FF.FORM_NAME = 'FORM_NAME'
                       AND F3.FORM_ID = FF.FORM_ID
                       AND F3.APPLICATION_ID = FF.APPLICATION_ID
                       AND FME.FUNCTION_ID = F3.FUNCTION_ID)
       AND fr.MENU_ID = fme.menu_id

No comments:

Post a Comment

OADBTransactionImpl in Oracle Application Framework (OAF)

OADBTransactionImpl is a class in Oracle Application Framework (OAF), which is a framework for building Oracle E-Business Suite applications...