Home » Applications » Oracle Fusion Apps & E-Business Suite » Find out responsibility name based on concurrent prg name
Find out responsibility name based on concurrent prg name [message #207799] Thu, 07 December 2006 01:22 Go to next message
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.
Re: Find out responsibility name based on concurrent prg name [message #207821 is a reply to message #207799] Thu, 07 December 2006 02:46 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Use the following tables/views.
fnd_concurrent_programs_vl
fnd_request_group_units
fnd_responsibility_vl

By
Vamsi
Re: Find out responsibility name based on concurrent prg name [message #218476 is a reply to message #207799] Thu, 08 February 2007 06:23 Go to previous messageGo to next message
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.
Re: Find out responsibility name based on concurrent prg name [message #218481 is a reply to message #218476] Thu, 08 February 2007 06:39 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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:
  


Current Time: Tue Dec 06 00:10:14 CST 2016

Total time taken to generate the page: 0.08674 seconds