Find Concurrent Program Name

select A.CONCURRENT_PROGRAM_NAME,
A.USER_CONCURRENT_PROGRAM_NAME,
A.description,
B.executable_Name,
B.USER_EXECUTABLE_NAME,EXECUTION_FILE_NAME,B.description from FND_CONCURRENT_PROGRAMS_VL A, FND_EXECUTABLES_FORM_V B
where upper(A.User_concurrent_program_name) like '%%' and A.EXECUTION_METHOD_CODE = 'I'
AND A.EXECUTABLE_ID = B.EXECUTABLE_ID;
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 IN (select A.USER_CONCURRENT_PROGRAM_NAME from FND_CONCURRENT_PROGRAMS_VL A, FND_EXECUTABLES_FORM_V B
where upper(A.User_concurrent_program_name) like '%%' and A.EXECUTION_METHOD_CODE = 'I'
AND A.EXECUTABLE_ID = B.EXECUTABLE_ID)
AND FNRTL.LANGUAGE = 'US'
AND FAPP.LANGUAGE = 'US'