Pages

Friday, January 31, 2014

To find responsibility for specific report

SELECT FRT.RESPONSIBILITY_NAME, FRG.REQUEST_GROUP_NAME, FRG.DESCRIPTION, FCPT.USER_CONCURRENT_PROGRAM_NAME
  FROM apps.FND_REQUEST_GROUPS FRG
      ,apps.FND_REQUEST_GROUP_UNITS FRGU
      ,apps.FND_CONCURRENT_PROGRAMS FCP
      ,apps.FND_CONCURRENT_PROGRAMS_TL FCPT
      ,apps.FND_RESPONSIBILITY_TL FRT
      ,apps.FND_RESPONSIBILITY FR
 WHERE     FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
       AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
       AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
       AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
       AND FCPT.SOURCE_LANG = USERENV('LANG')
       AND FCP.APPLICATION_ID = FCPT.APPLICATION_ID
       AND FCP.CONCURRENT_PROGRAM_ID = FCPT.CONCURRENT_PROGRAM_ID
       AND FR.APPLICATION_ID = FRT.APPLICATION_ID
       AND FR.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
       AND FRT.SOURCE_LANG = USERENV('LANG')
       AND FR.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID
       AND FR.APPLICATION_ID = FRG.APPLICATION_ID
--          AND FCP.CONCURRENT_PROGRAM_NAME = ''  --  YOU CAN PUT THE SHORTNAME HERE
       AND FCPT.USER_CONCURRENT_PROGRAM_NAME LIKE '' --OR THE USER CONC PROGRAM NAME HERE;

No comments:

Post a Comment