Home » Applications » Oracle Fusion Apps & E-Business Suite » Responsibility attached to a specific Operating Unit
Responsibility attached to a specific Operating Unit [message #307567] Wed, 19 March 2008 02:38 Go to next message
Lutchumaya
Messages: 9
Registered: March 2007
Junior Member
Hi everyone


I need to list responsibilities for which MO: Operating Unit system profile is set.

I am trying with these two tables
FND_PROFILE_OPTION_VALUES, FND_RESPONSIBILITY


Help me please

Regards
Lutchumaya
Re: Responsibility attached to a specific Operating Unit [message #307728 is a reply to message #307567] Wed, 19 March 2008 13:29 Go to previous message
SanthoshKumar_s
Messages: 28
Registered: March 2005
Location: Hyderabad
Junior Member

Im not sure about the exact solution you are looking for, but i hope the below given query may come handy.

select RES.RESPONSIBILITY_id
from apps.FND_USER_RESP_GROUPS_DIRECT dir,
apps.fnd_profile_option_values val,
apps.fnd_profile_options pro,
APPS.FND_RESPONSIBILITY_VL RES
where val.level_id = 10003
and val.level_value = dir.RESPONSIBILITY_ID
AND dir.RESPONSIBILITY_ID = RES.RESPONSIBILITY_ID
and val.profile_option_id = pro.profile_option_id
and pro.profile_option_name = 'GL_SET_OF_BKS_ID'
AND VAL.PROFILE_OPTION_VALUE = '1002' -- SET OF BOOKS ID
AND RES.APPLICATION_ID = 101 -- APPLICATION IS FOR GL
Previous Topic: UPK Remote Access
Next Topic: calling journal import program from plsql procedure
Goto Forum:
  


Current Time: Sun Dec 11 00:22:27 CST 2016

Total time taken to generate the page: 0.08635 seconds