Tuesday, 5 May 2015

Query To Find The Request Group And Menu Assigned To Responsibility

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

No comments:

Post a Comment