concurrent_programs & executables that are created by a user

Tables used
1)FND_USER--Holds user Information.
2)FND_CONCURRENT_PROGRAMS_VL-Holds the concurrent programs defined in the system.

3)FND_EXECUTABLES_VL-Holds the concurrent executables information.

 

SELECT FU.USER_NAME,
       FCPL.USER_CONCURRENT_PROGRAM_NAME,                                                          FCPL.DESCRIPTION,
       FEV.USER_EXECUTABLE_NAME,
       FEV.EXECUTABLE_NAME,
       FEV.EXECUTION_FILE_NAME 
  FROM FND_USER FU,  
       FND_CONCURRENT_PROGRAMS_VL FCPL,
       FND_EXECUTABLES_VL FEV 
 WHERE FCPL.EXECUTABLE_ID=FEV.EXECUTABLE_ID 
   AND FEV.CREATED_BY=FU.USER_ID 
   AND FU.USER_NAME='Enter User_name'