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

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