Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Design query to find the navigation of a concuurent program
Design query to find the navigation of a concuurent program [message #164027] Tue, 21 March 2006 06:44
Happyamitmca
Messages: 4
Registered: January 2006
Location: Hyderabad
Junior Member

Hi
all,
i am trying from 2 days to build a query so that if we know the concurrent program then it should return

1: Application name in which this program is registered.

2: Responsibility name in which it is

3: Request Groups in which it belongs

4: Excutable name of this concurrent program(optional)


Is it possible to write a query so that if we add a condition that concurrent_program_name like 'concurrent_program_name' then it shoud return only one row.

I tried lot but my query is returning more than one row.

select FCPT.USER_CONCURRENT_PROGRAM_NAME,
FA.APPLICATION_SHORT_NAME,
FAT.APPLICATION_NAME
from FND_CONCURRENT_PROGRAMS_TL FCPT,
fnd_application FA,
fnd_application_tl FAT
where FCPT.APPLICATION_ID=FA.APPLICATION_ID
and FA. APPLICATION_ID=FAt.APPLICATION_ID
and FCPT.USER_CONCURRENT_PROGRAM_NAME like 'OrderAmit';


this one is returning one row but only application name we can get. but when i m joining FND_REQUEST_GROUPS and FND_RESPONSIBILITY AND FND_EXECUTABLES tables then it is returning nearly 8000 rows.

So plz i need help.

Thanks && Regards.
Previous Topic: Application Server 10g time zone
Next Topic: single sign on account lock error
Goto Forum:
  


Current Time: Fri Mar 29 05:44:49 CDT 2024