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:
Post a Comment