FND Basic Tables- Concurret Request

SQL for find the lately run of the specific concurrent programs:

select b.user_concurrent_program_name, a.*
  from fnd_concurrent_requests a, fnd_concurrent_programs_tl b
 where a.concurrent_program_id = b.concurrent_program_id
   and b.language = 'US'
   and a.request_date > to_date('2010-11-08', 'YYYY-MM-DD')
   and b.user_concurrent_program_name <> 'Workflow Background Process'
   AND upper(b.user_concurrent_program_name) like 'FTP%COMPASS'
 ORDER BY a.request_date DESC;

1.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17087603/viewspace-687512/，如需转载，请注明出处，否则将追究法律责任。