SELECT DISTINCT FRT.RESPONSIBILITY_NAME,
FMT.USER_MENU_NAME,
FAT.APPLICATION_NAME,
(SELECT REQUEST_GROUP_NAME
FROM APPS.FND_REQUEST_GROUPS FRG
WHERE Frg.Application_Id = Fr.Application_Id
AND FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
) REQUET_GROUP
FROM APPS.FND_RESPONSIBILITY_TL FRT,
APPS.FND_RESPONSIBILITY FR,
APPS.FND_MENUS_TL FMT,
APPS.FND_MENUS FM,
APPS.FND_APPLICATION_TL FAT,
APPS.FND_APPLICATION FA
WHERE Frt.Responsibility_Id(+) = Fr.Responsibility_Id
AND FRT.RESPONSIBILITY_NAME LIKE '<Responsibility Name>'
AND FR.MENU_ID = FMT.MENU_ID
AND FR.MENU_ID = FM.MENU_ID
AND FAT.APPLICATION_ID = FA.APPLICATION_ID
AND FA.APPLICATION_ID = FR.APPLICATION_ID
AND FRT.LANGUAGE = '<Language>'
AND FAT.LANGUAGE = '<Language>';
FMT.USER_MENU_NAME,
FAT.APPLICATION_NAME,
(SELECT REQUEST_GROUP_NAME
FROM APPS.FND_REQUEST_GROUPS FRG
WHERE Frg.Application_Id = Fr.Application_Id
AND FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID
) REQUET_GROUP
FROM APPS.FND_RESPONSIBILITY_TL FRT,
APPS.FND_RESPONSIBILITY FR,
APPS.FND_MENUS_TL FMT,
APPS.FND_MENUS FM,
APPS.FND_APPLICATION_TL FAT,
APPS.FND_APPLICATION FA
WHERE Frt.Responsibility_Id(+) = Fr.Responsibility_Id
AND FRT.RESPONSIBILITY_NAME LIKE '<Responsibility Name>'
AND FR.MENU_ID = FMT.MENU_ID
AND FR.MENU_ID = FM.MENU_ID
AND FAT.APPLICATION_ID = FA.APPLICATION_ID
AND FA.APPLICATION_ID = FR.APPLICATION_ID
AND FRT.LANGUAGE = '<Language>'
AND FAT.LANGUAGE = '<Language>';
No comments:
Post a Comment