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