用什么sql语句可以查询出concurrent programs在哪个职责哪个菜单下？

wulinxia

最初由 sunnly 发布
[B]select frg.request_group_name,
       fcp.concurrent_program_name,
       frt.responsibility_name
  from FND_REQUEST_GROUPS      frg,
       FND_REQUEST_GROUP_UNITS frgu,
       fnd_concurrent_programs fcp,
       FND_RESPONSIBILITY_TL   frt,
       FND_RESPONSIBILITY      fr
where frg.application_id = frgu.application_id
   and frg.request_group_id = frgu.request_group_id
   and frgu.unit_application_id = fcp.application_id
   and frgu.request_unit_id = fcp.concurrent_program_id
   and fr.RESPONSIBILITY_ID = frt.RESPONSIBILITY_ID
   AND fr.APPLICATION_ID = frt.APPLICATION_ID
   and frg.application_id = fr.group_application_id
   and frg.request_group_id = fr.request_group_id
   and fcp.concurrent_program_name = 'CUX_TEST
   AND frt.LANGUAGE = USERENV('LANG') [/B]

seal.zhou

谢谢了

Harry_shan

最初由 sunnly 发布
[B]select frg.request_group_name,
       fcp.concurrent_program_name,
       frt.responsibility_name
  from FND_REQUEST_GROUPS      frg,
       FND_REQUEST_GROUP_UNITS frgu,
       fnd_concurrent_programs fcp,
       FND_RESPONSIBILITY_TL   frt,
       FND_RESPONSIBILITY      fr
where frg.application_id = frgu.application_id
   and frg.request_group_id = frgu.request_group_id
   and frgu.unit_application_id = fcp.application_id
   and frgu.request_unit_id = fcp.concurrent_program_id
   and fr.RESPONSIBILITY_ID = frt.RESPONSIBILITY_ID
   AND fr.APPLICATION_ID = frt.APPLICATION_ID
   and frg.application_id = fr.group_application_id
   and frg.request_group_id = fr.request_group_id
   and fcp.concurrent_program_name = 'CUX_TEST
   AND frt.LANGUAGE = USERENV('LANG') [/B]

还是马儿厉害，一下就搞出来了