Script to find the responsibilities from which a concurrent program can be submitted

SELECT DISTINCT FCPL.USER_CONCURRENT_PROGRAM_NAME,
                FCP.CONCURRENT_PROGRAM_NAME,
                FAPP.APPLICATION_NAME,
                FRG.REQUEST_GROUP_NAME,
                FNRTL.RESPONSIBILITY_NAME
  FROM APPS.FND_REQUEST_GROUPS FRG,
       APPS.FND_APPLICATION_TL FAPP,
       APPS.FND_REQUEST_GROUP_UNITS FRGU,
       APPS.FND_CONCURRENT_PROGRAMS FCP,
       APPS.FND_CONCURRENT_PROGRAMS_TL FCPL,
       APPS.FND_RESPONSIBILITY FNR,
       APPS.FND_RESPONSIBILITY_TL FNRTL
 WHERE     FRG.APPLICATION_ID = FAPP.APPLICATION_ID
       AND FRG.APPLICATION_ID = FRGU.APPLICATION_ID
       AND FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
       AND FRG.REQUEST_GROUP_ID = FNR.REQUEST_GROUP_ID
       AND FRG.APPLICATION_ID = FNR.APPLICATION_ID
       AND FNR.RESPONSIBILITY_ID = FNRTL.RESPONSIBILITY_ID
       AND FRGU.REQUEST_UNIT_ID = FCP.CONCURRENT_PROGRAM_ID
       AND FRGU.UNIT_APPLICATION_ID = FCP.APPLICATION_ID
       AND FCP.CONCURRENT_PROGRAM_ID = FCPL.CONCURRENT_PROGRAM_ID
       AND FCPL.USER_CONCURRENT_PROGRAM_NAME LIKE '%OM%Order%' -- Concurrent Program Name Here
       AND FNRTL.LANGUAGE = 'US'
       AND FAPP.LANGUAGE = 'US'

No comments:

Post a Comment