OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » MODULE AND RESPONSIBILTY (ORACLE REPORTS (apps))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MODULE AND RESPONSIBILTY [message #579549]

Wed, 13 March 2013 02:29

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

If i know the module name ,assume Application Object Library and i want to know the responsibilites in that particular module.How can i get it.

Thanks in advance for your valuable time in answering my query.

Report message to a moderator

Re: MODULE AND RESPONSIBILTY [message #579646 is a reply to message #579549]

Wed, 13 March 2013 15:40

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Check fnd_application_vl to get the application_id of the needed module.
Filter fnd_responsibility_vl by application_id, which you got above.

By
Vamsi

Report message to a moderator

Re: MODULE AND RESPONSIBILTY [message #579676 is a reply to message #579646]

Wed, 13 March 2013 23:10

bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi

Member

thanks i got it.
if any one wants query then go for it.

SELECT UNIQUE frt.responsibility_name,APP.APPLICATION_NAME
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt,
FND_APPLICATION_ALL_VIEW APP
WHERE fr.responsibility_id = frt.responsibility_id
AND fr.request_group_id = frg.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND frgu.request_unit_id = fcpt.concurrent_program_id
AND fcpt.LANGUAGE = 'US'
AND frt.LANGUAGE = 'US'
AND FRT.APPLICATION_ID=APP.APPLICATION_ID
AND APP.APPLICATION_NAME ='Application Object Library

Report message to a moderator

Re: MODULE AND RESPONSIBILTY [message #579705 is a reply to message #579676]

Thu, 14 March 2013 02:35

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Thanks for sharing the query.

But as I said before you need only those two views.
All the following are not necessary.

fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt,

By
Vamsi

Report message to a moderator

Previous Topic:	ORACLE DEVELOPER
Next Topic:	Fixed Assets Trial Balance report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:54:39 CST 2024