Find responsibilities that can run the specific concurrent program
SELECT fcp.concurrent_program_name, fr.responsibility_name, frg.request_group_name, fcp.user_concurrent_program_name FROM fnd_request_group_units frgup, fnd_concurrent_programs_vl fcp, fnd_request_groups frg, fnd_responsibility_vl fr WHERE 1 = 1 AND fr.request_group_id = frg.request_group_id AND frg.request_group_id = frgup.request_group_id AND frgup.request_unit_type = 'P' AND frgup.request_unit_id = fcp.concurrent_program_id AND fcp.user_concurrent_program_name LIKE '%&concurrent_program_name%';
Latest posts by Brijesh Gogia (see all)
- Building a Scalable and Secure AI Infrastructure in the Cloud - May 12, 2024
- Harnessing the Power of AI in the Cloud for Business Transformation - March 2, 2024
- Building a Resilient Cybersecurity Framework in the Oracle Cloud - January 16, 2024