/* Lokanadham */
select distinct fcpl.user_concurrent_program_name,
frg.request_group_id,
fcp.concurrent_program_name,
fapp.application_name,
frg.request_group_name,
fnrtl.responsibility_name
from apps.fnd_request_groups frg,
apps.fnd_application_tl fapp,
apps.fnd_request_group_units frgu,
apps.fnd_concurrent_programs fcp,
apps.fnd_concurrent_programs_tl
fcpl,
apps.fnd_responsibility fnr,
apps.fnd_responsibility_tl fnrtl
where frg.application_id
= fapp.application_id
and frg.application_id = frgu.application_id
and frg.request_group_id = frgu.request_group_id
and frg.request_group_id = fnr.request_group_id
and frg.application_id = fnr.application_id
and fnr.responsibility_id = fnrtl.responsibility_id
and frgu.request_unit_id = fcp.concurrent_program_id
and frgu.unit_application_id = fcp.application_id
and fcp.concurrent_program_id = fcpl.concurrent_program_id
and fcpl.user_concurrent_program_name like '%Bursting%'
and fnrtl.language = 'US'
and fapp.language = 'US'
--and FRG.request_group_name ='All Reports';