Tabele powiązane z zleceniami współbieżnymi (CM)

SELECT logfile_name FROM fnd_concurrent_requests WHERE request_id = <request_id>;
</request_id>

select logfile_name from fnd_concurrent_requests where request_id = <request_id>; </request_id>

SELECT outfile_name FROM fnd_concurrent_requests WHERE request_id = <request_id>;
</request_id>

select outfile_name from fnd_concurrent_requests where request_id = <request_id>; </request_id>

SELECT logfile_name FROM fnd_concurrent_processes WHERE concurrent_process_id=(SELECT controlling_manager
FROM fnd_concurrent_requests WHERE request_id=<reqid>);
</reqid>

select logfile_name from fnd_concurrent_processes where concurrent_process_id=(select controlling_manager from fnd_concurrent_requests where request_id=<reqid>); </reqid>

SELECT concurrent_queue_name, user_concurrent_queue_name FROM fnd_concurrent_queues_tl
WHERE concurrent_queue_id = (SELECT concurrent_queue_id FROM fnd_concurrent_processes
WHERE concurrent_process_id=(SELECT controlling_manager FROM fnd_concurrent_requests WHERE request_id= <request id>));
</request>

select concurrent_queue_name, user_concurrent_queue_name from fnd_concurrent_queues_tl where concurrent_queue_id = (select concurrent_queue_id from fnd_concurrent_processes where concurrent_process_id=(select controlling_manager from fnd_concurrent_requests where request_id= <request id>)); </request>

SELECT * FROM  fnd_conc_req_outputs

select * from fnd_conc_req_outputs

$APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML

$APPLCSF/$APPLOUT/{REPORTNAME}_{REQUEST_ID}_{COUNT}.PDF|RTF|EXCEL|HTML