根据报表文件名称关键字查找报表的执行文件名称等信息

SELECT   A.USER_CONCURRENT_PROGRAM_NAME,
         A.CONCURRENT_PROGRAM_NAME,
         A.OUTPUT_FILE_TYPE,
         B.EXECUTION_FILE_NAME,
         B.EXECUTABLE_NAME,
         FND_L.MEANING,
         B.USER_EXECUTABLE_NAME,
         B.DESCRIPTION
FROM  FND_CONCURRENT_PROGRAMS_VL A,
       fnd_executables_vl B, 
       FND_LOOKUPS FND_L
WHERE  A.APPLICATION_ID = B.APPLICATION_ID
    AND  A.EXECUTABLE_ID = B.EXECUTABLE_ID 
    AND  B.EXECUTION_METHOD_CODE =  FND_L.LOOKUP_CODE( + )
    AND  FND_L.LOOKUP_TYPE = ' CP_EXECUTION_METHOD_CODE '
    AND  A.USER_CONCURRENT_PROGRAM_NAME  LIKE   ' C%杂项出入库报表% '