OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Responsibility without MO: Operating Unit set

Home » Applications » Oracle Fusion Apps & E-Business Suite » Responsibility without MO: Operating Unit set

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

Responsibility without MO: Operating Unit set [message #175238]

Thu, 01 June 2006 06:51

patelhemantg
Messages: 25
Registered: May 2006

Junior Member

Hi all,

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

I am trying to find data with these tables: FND_PROFILE_OPTION_VALUES, FND_RESPONSIBILITY

11i version => 11.5.5.

TIA,

Hemant Patel.

Report message to a moderator

Re: Responsibility without MO: Operating Unit set [message #175250 is a reply to message #175238]

Thu, 01 June 2006 07:17

manwadkar
Messages: 104
Registered: September 2005
Location: Washington DC

Senior Member

You can fine tune this query....

select * from fnd_responsibility_vl D
where
D.RESPONSIBILITY_NAME ='Application Developer'
AND D.responsibility_id NOT IN
(
select c.level_value
from
fnd_profile_options A,
fnd_profile_options_tl B,
fnd_profile_option_values C
where
a.PROFILE_OPTION_NAME=b.PROFILE_OPTION_NAME
and b.user_profile_option_name = 'MO: Operating Unit'
and b.LANGUAGE='US'
and a.PROFILE_OPTION_ID = c.PROFILE_OPTION_ID
and c.level_value = D.RESPONSIBILITY_ID
and level_id=10003
)

Report message to a moderator

Re: Responsibility without MO: Operating Unit set [message #175252 is a reply to message #175250]

Thu, 01 June 2006 07:23

patelhemantg
Messages: 25
Registered: May 2006

Junior Member

Hi Manwadkar,

That really works.

Thanks a LOT...

Regards,
Hemant Patel.
(patelhemantg@yahoo.com)

Report message to a moderator

Previous Topic:	What are all the DFF in AP and AR?
Next Topic:	regarding query_only=yes in oracle cash management

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 14:05:15 CST 2024