查询并发请求

SELECT CP.USER_CONCURRENT_PROGRAM_NAME 程序,
      CP.ENABLED_FLAG 启用,
      CP.CONCURRENT_PROGRAM_NAME 简称,
      EF.EXECUTABLE_NAME 可执行,
       EF.EXECUTION_FILE_NAME 可执行文件,
       F.MEANING 执行方法,
      CP.EXECUTABLE_ID,
       EF.APPLICATION_NAME 应用,
       CP.DESCRIPTION 说明,
       CP.OUTPUT_FILE_TYPE 输出格式
FROM FND_CONCURRENT_PROGRAMS_VL CP
               ,FND_EXECUTABLES_FORM_V EF
               ,fnd_lookup_values  f
 WHERE CP.queue_control_flag = 'N'
 and UPPER(CP.USER_CONCURRENT_PROGRAM_NAME） LIKE '%&PROGRAM_NAME%'
   AND CP.EXECUTABLE_ID=EF.EXECUTABLE_ID
   and cp.EXECUTION_METHOD_CODE=ef.EXECUTION_METHOD_CODE
   AND EF.EXECUTION_METHOD_CODE=F.LOOKUP_CODE
   AND f.lookup_type='CP_EXECUTION_METHOD_CODE'
  and f.language='ZHS'
 order by CP.user_concurrent_program_name;