Saturday, 10 September 2016

Query to get the Responsiblity Name when User Form Function Name is passed as parameter

SELECT DISTINCT fft.USER_FUNCTION_NAME,
  fft.FUNCTION_ID,
  fme.menu_id,
  fr.RESPONSIBILITY_ID,
  frt.RESPONSIBILITY_name
FROM FND_FORM_FUNCTIONS_TL FFT,
  FND_MENU_ENTRIES FME,
  FND_MENU_ENTRIES_TL FMET,
  FND_RESPONSIBILITY FR,
  FND_RESPONSIBILITY_TL frt
WHERE FFT.FUNCTION_ID     =FME.FUNCTION_ID
AND FMET.MENU_ID          =FME.MENU_ID
AND FR.MENU_ID            =FME.MENU_ID
AND FFT.USER_FUNCTION_NAME=:USER_FORM_FUNCTION--Name of the user form function
AND frt.RESPONSIBILITY_ID =fr.RESPONSIBILITY_ID
AND fft.language          ='US';

No comments:

Post a Comment