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';
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