Query to find Concurrent Program attached to Which Responsibility

Concurrent Program in Which Responsibility

Query to find Concurrent Program attached to  Which Responsibility



SELECT responsibility_name ,
Frg.Request_Group_Name,
Fcpv.User_Concurrent_Program_Name,
Fcpv.Description
FROM fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv
Where Frgu.Request_Unit_Type = 'P'
AND frgu.request_group_id = frg.request_group_id
And Frgu.Request_Unit_Id = Fcpv.Concurrent_Program_Id
And Frv.Request_Group_Id = Frg.Request_Group_Id
--And Frv.Responsibility_Name Like %XXXX%'
and Fcpv.User_Concurrent_Program_Name like 'Complete Multiperiod Accounting'
Order By Responsibility_Name;