学些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;