Query to know request attached to which responsibility
SELECT fc.user_concurrent_program_name, fr.request_group_name , frv.APPLICATION_ID , fc.CONCURRENT_PROGRAM_NAME , frv.responsibility_name FROM fnd_request_groups fr , fnd_request_group_units frg , fnd_concurrent_programs_vl fc, fnd_responsibility_vl frv WHERE fr.request_group_id = frg.request_group_id AND frg.request_unit_id = fc.concurrent_program_id AND fr.request_group_id = frv.request_group_id AND fc.user_concurrent_program_name = 'REQUEST NAME'
No comments:
Post a Comment