OraFAQ Forum: Weblogic & Application Server » Design query to find the navigation of a concuurent program

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Design query to find the navigation of a concuurent program

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

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.

Report message to a moderator

Previous Topic:	Application Server 10g time zone
Next Topic:	single sign on account lock error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 22:33:54 CST 2025