Useful queries

Fnd concurrent requests for request set

select fc.* from fnd_amp_requests_v fc start with parent_request_id = 39432608 connect by prior request_id = parent_request_id and level = 2;