学些sql话语 职责，用户，请求组，并发程序的关系

学些sql语句 职责，用户，请求组，并发程序的关系

select frv.DESCRIPTION
  from fnd_responsibility fr,-----------职责
       fnd_concurrent_programs fcp, -----并发程序
       fnd_responsibility_vl frv, ------------职责
       fnd_request_groups frg ,
       fnd_request_group_units frgu ----------- 请求组单元数据
      
 where fr.RESPONSIBILITY_ID     = frv.responsibility_id
       and frv.application_id   = fcp.application_id
       and frq.request_group_id = frqu.request_group_id
       and frq.application_id   = frv.application_id
       and frg.description     like '苏铝铝业销售客户化报表';
      
      
       and frg.
     
     
     
      and fnd_request_groupsfrv
     
      -- fnd_user fu
-- fnd_request_groups frg
-- 
--  fnd_concurrent_programs fcp
     
     
     
      frg
    

   
    select * from  fnd_request_groups g;
    select * from  fnd_request_group_units;
    select * from  fnd_user;
    select * from  fnd_concurrent_programs; where concurrent_program_name like 'CUX%';
    select * from  fnd_responsibility;
    select * from fnd_responsibility_vl;