EBS 常用sql

1）查看请求挂在哪个状态下

SELECT fcpv.concurrent_program_name
  FROM fnd_request_groups         frg, --请求组
       fnd_request_group_units    frgu, --请求单元
       fnd_responsibility_vl      frv, --职责
       fnd_concurrent_programs_vl fcpv --并发
 WHERE frg.request_group_id = frgu.request_group_id
   AND frg.request_group_id = frv.request_group_id
   AND frgu.request_unit_id = fcpv.concurrent_program_id
   AND fcpv.concurrent_program_name = 'CUXTEST' -- 并发简称