How to desactivate a list of suppliers

Hello Team:

I want to create a processing in Oracle EBS that allows you to disable the providers automatically with the following conditions:

. no PO (Purchasing Order) more than 2 years.

. no open PO.

. no unpaid or specially paid invoices.

. no invoices whose status is invalid.

. no advances available.

. no settlement for more than 2 years.

which query can I execute, which database tables and which fields to extract.

Thank you in advance,