Apps Scripts

To get Log and out file location:

select
req.request_id,req.logfile_name LOG, req.outfile_name OUT
FROM v$process pid,
v$session ses,apps.fnd_concurrent_requests req, fnd_concurrent_programs_tl prg ,
fnd_user fu
WHERE req.request_id IN (SELECT request_id
FROM fnd_conc_req_summary_v
WHERE phase_code IN ('R')
AND status_code IN ('R'))
AND req.oracle_process_id = pid.spid(+)
AND pid.addr = ses.paddr(+)
AND req.concurrent_program_id = prg.concurrent_program_id
AND req.requested_by = fu.user_id
and req.request_id=&request_id
ORDER
BY SID ;