Queries ORACLE APPS

QUERY for finding the concurrent program's request group

select
frt.responsibility_name "Responsibility",
fcpt.user_concurrent_program_name,
frg.request_group_name "Request Group",
frg.description
from
fnd_concurrent_programs_tl fcpt,
fnd_request_group_units frgu,
fnd_request_groups frg,
fnd_responsibility fr,
fnd_responsibility_tl frt
where
UPPER(fcpt.user_concurrent_program_name) LIKEUPPER('%GHP%CSR%PACKAGE%')
and frgu.request_unit_id = fcpt.concurrent_program_id
and frgu.unit_application_id = fcpt.application_id
and frg.request_group_id = frgu.request_group_id
and frg.application_id = frgu.application_id
and fr.request_group_id = frg.request_group_id
and fr.responsibility_id = frt.responsibility_idorder by 1