OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Find out responsibility name based on concurrent prg name

Home » Applications » Oracle Fusion Apps & E-Business Suite » Find out responsibility name based on concurrent prg name

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

Find out responsibility name based on concurrent prg name [message #207799]

Thu, 07 December 2006 01:22

kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India

Junior Member

Hi,

How can I find out responsibility name based on concurrent program name using back end?

Thanks in advance.

Regards,
Kanmani.

Report message to a moderator

Re: Find out responsibility name based on concurrent prg name [message #207821 is a reply to message #207799]

Thu, 07 December 2006 02:46

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

Senior Member

Use the following tables/views.
fnd_concurrent_programs_vl
fnd_request_group_units
fnd_responsibility_vl

By
Vamsi

Report message to a moderator

Re: Find out responsibility name based on concurrent prg name [message #218476 is a reply to message #207799]

Thu, 08 February 2007 06:23

kanmani_karuppannan
Messages: 23
Registered: November 2006
Location: India

Junior Member

Can you pls give the link b/w 3 tables or pls post the exact query.

Report message to a moderator

Re: Find out responsibility name based on concurrent prg name [message #218481 is a reply to message #218476]

Thu, 08 February 2007 06:39

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

Senior Member

select fcp.concurrent_program_name
      ,fcp.user_concurrent_program_name
      ,fcp.concurrent_program_id
      ,fcp.enabled_flag
      ,fcp.srs_flag
      ,frgu.request_group_id
      ,fr.responsibility_id
      ,fr.responsibility_name
  from fnd_concurrent_programs_vl fcp
      ,fnd_request_group_units frgu
      ,fnd_responsibility_vl fr
 where fcp.concurrent_program_id = frgu.request_unit_id
   and frgu.request_group_id = fr.request_group_id
   and fcp.concurrent_program_name = '&name';

The flow would be as follows:
Concurrent Program -> Request Group -> Responsibility -> User
By
Vamsi

[Updated on: Thu, 08 February 2007 06:41]

Report message to a moderator

Previous Topic:	iProcurement
Next Topic:	PAYMENT PROGRAM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 06:58:28 CDT 2024