Saturday 25 August 2012

Find Responsibility name and Request group name attached to a concurrent program


Select Frvl.Responsibility_Name,
fe.executable_name,
frg.request_group_name,
User_Concurrent_Program_Name
From Apps.Fnd_Concurrent_Programs_Tl fcpt,
APPS.FND_REQUEST_GROUP_UNITS frgu,
Apps.Fnd_Request_Groups Frg,
Apps.Fnd_Responsibility_Vl frvl,
Apps.Fnd_Application_Vl fav,
Apps.Fnd_Executables fe,
Apps.Fnd_Concurrent_Programs fcp
Where frvl.Request_Group_Id=frgu.Request_Group_Id
And frgu.Request_Unit_Id = fcpt.Concurrent_Program_Id
and executable_name like '&EXECUTABLE_NAME'  /*optional*/
and fcp.executable_id = fe.executable_id
And User_Concurrent_Program_Name Like '&PROGRAM_NAME'
And fcp.Concurrent_Program_Id = fcpt.Concurrent_Program_Id
And Frg.Request_Group_Id = Frgu.Request_Group_Id
and frvl.request_group_id = frg.request_group_id
and frg.application_id = fav.application_id

No comments: