Query to find Pending Requests Against Output Post Processor

Below query can be used to find the pending requests again OPP.

Query:

select REQUEST_ID,PHASE_CODE,STATUS_CODE from fnd_concurrent_requests
where request_id in (
select concurrent_request_id
from fnd_conc_pp_actions
where action_type >= 6
and processor_id is null)
and PHASE_CODE!='C';