Learn SQL statement responsibilities, user, request group, and concurrent program relationships

Learn SQL statement responsibilities, users, request groups, and concurrent programs. select frv. DESCRIPTION from fnd_responsibility fr, ----------- responsibility fnd_concurrent_programs fcp, ----- concurrent program limit frv, ------------ responsibility fnd_request_groups frg, limit frgu ----------- request group unit data 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 'customized report for sale of Aluminum Company '; and frg. and queue -- fnd_user fu -- fnd_request_groups frg -- fnd_concurrent_programs fcp frg select * from fnd_request_groups g; select * from queue; select * from fnd_user; select * from queue; where concurrent_program_name like 'cux % '; select * from fnd_responsibility; select * from fnd_responsibility_vl;