Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to Fetch Logfile and Outfile for the each request of a Request Set
Need to Fetch Logfile and Outfile for the each request of a Request Set [message #277546] Tue, 30 October 2007 08:59 Go to next message
bholaimmu
Messages: 35
Registered: October 2007
Member
Hi,

Can anyone give me the query to fetch Logfile and Outfile from (Oracle Applications ) for each request of a request set.

For example: Request Set is having 2 child request and again that 2 child request is having each 1 request. It means all-together there are 5 request which will run one after another and I want to fetch request_id,logfile,outfile of those 5 request in 3 columns only.




Thx a Lot,
Khan.
Re: Need to Fetch Logfile and Outfile for the each request of a Request Set [message #277588 is a reply to message #277546] Tue, 30 October 2007 13:00 Go to previous message
ggr88
Messages: 31
Registered: October 2007
Location: Wellington, New Zealand
Member
Hi,

Try this:

select lpad(' ',2*(level-1)) || fcr.request_id request_id
, fcr.logfile_name
, fcr.outfile_name
from fnd_concurrent_requests fcr
start with request_id = &request_set_request_id
connect by prior request_id = parent_request_id;

Gareth
http://garethroberts.blogspot.com
Previous Topic: Default Segment Values
Next Topic: iprocurement
Goto Forum:
  


Current Time: Sun Dec 04 23:03:49 CST 2016

Total time taken to generate the page: 0.14424 seconds