Query to retrive Concurrent Programs created or updated by User 2605.

"SELECT FCP.CONCURRENT_PROGRAM_NAME SHORT_NAME,
FCP.USER_CONCURRENT_PROGRAM_NAME ENGLISH,
FCPTL.USER_CONCURRENT_PROGRAM_NAME ARABIC,
decode(fe.EXECUTION_METHOD_CODE,'P','Oracle_Reports','I','PLSQL','')EXECUTION_METHOD,

FCP.CREATED_BY, FCP.LAST_UPDATED_BY, FCP.CREATION_DATE, FCP.LAST_UPDATE_DATE
,FCP.ENABLED_FLAG
FROM FND_CONCURRENT_PROGRAMS_VL FCP,
FND_CONCURRENT_PROGRAMS_TL FCPTL,
fnd_executables FE
WHERE 
(FCP.CREATED_BY = 2605 OR FCP.LAST_UPDATED_BY = 2605)  
AND FCP.ENABLED_FLAG = 'Y'
AND FCP.CONCURRENT_PROGRAM_ID = FCPTL.CONCURRENT_PROGRAM_ID
AND FCPTL.LANGUAGE = 'AR'
AND FE.EXECUTABLE_NAME = FCP.CONCURRENT_PROGRAM_NAME
ORDER BY 5,7"