add

About Me

My photo
Oracle Apps - Techno Functional consultant

Friday, November 15

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'
 ANDFAPP.LANGUAGE ='US';

No comments: