To Get Concurrent Program Responsibility and Request Group

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 1=1

 AND 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 = 'Workflow Definitions Loader'

 AND FNRTL.LANGUAGE = 'US'

 AND FAPP.LANGUAGE = 'US';