sql for PO receipt accruals & voucher in exception

Hi,

Is there any delivered query or if anyone has a sql to identify projects with potential of accrued liabilities (PO receipt accruals & vouchers in exception)? We are trying to identify this potential activity for grants projects before closing them out in Grants / Projects so we don't face the situation where we need to re-open them in order to allow for accruals to flow in and also we can alert departments to work with Purchasing/AP to close out POs and reconcile on their end.

Thank you,

Sar