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