Page 1 of 1
how to get request group name
Posted: Thu Oct 05, 2006 6:43 am
by keshavkovela
Hi gurus,
Report registeration in apps, i know only inforation about executable name. from this executable , i got program name . Then how to know request group name.
Any help on this highly appreciated
thanks
keshav
Posted: Thu Oct 05, 2006 7:10 am
by Atif
Request groups are associated with responsibility.Query the responsibility on which u want the report to be avaialble.from the Request group block copy the name of request group.Then go to
Security->Responsibility->Request.Paste the name of Request group copied from responsibility,Add the name of report under request.
Atif
Posted: Fri Oct 06, 2006 2:27 am
by keshavkovela
Atif,
The report is already added to request group. I know only the module name . I need to know the request group. Is there any way to get the request group?
thanks
keshav
Posted: Fri Oct 06, 2006 4:24 am
by admin
May be the following query will help you, (modify it as per your requirements)
topic.asp?TOPIC_ID=334
Posted: Wed Oct 11, 2006 6:50 am
by seenujanu
Hai Fri
Another way to get the Request Group Name is
If u Know the Module Name we can get the Request GroupName
Through FrontEnd
Goto Security ->Resposibility ->Define
Query it .u will get the RGName
Regards
seenu
Posted: Fri Oct 13, 2006 2:22 am
by ahmadbilal
Check It Out this show you request groupn name APPLICATION NAME
Select G.REQUEST_GROUP_NAME, C.USER_CONCURRENT_PROGRAM_NAME, A.APPLICATION_NAME,
G.APPLICATION_ID, G.REQUEST_GROUP_ID, U.UNIT_APPLICATION_ID, U.REQUEST_UNIT_ID
From FND_REQUEST_GROUPS G, FND_REQUEST_GROUP_UNITS U,
FND_APPLICATION_TL A, FND_CONCURRENT_PROGRAMS_TL C
Where G.REQUEST_GROUP_ID = U.REQUEST_GROUP_ID
And U.UNIT_APPLICATION_ID = A.APPLICATION_ID
And U.REQUEST_UNIT_ID = C.CONCURRENT_PROGRAM_ID
--And G.REQUEST_GROUP_ID=1146
Order By C.USER_CONCURRENT_PROGRAM_NAME,A.APPLICATION_NAME, G.REQUEST_GROUP_ID