Oracle EBS 统计我们客制的报表

 ---EBS 统计特定开头的请求

 

select t.user_concurrent_program_name, b.concurrent_program_name
  from fnd_concurrent_programs_tl t, fnd_concurrent_programs b
 where b.application_id = t.application_id
   and b.concurrent_program_id = t.concurrent_program_id
   and b.concurrent_program_name like 'CUX%' --报表的缩写以"AG"开头的
 order by t.user_concurrent_program_name;