AP Manual Invoice Approval Workflow (APINVAPR) customization

Hi Everyone,

This is related to AP Manual Invoice Approval Workflow (APINVAPR)

In existing process, users are creating manual AP Invoices from work bench.

Once AP Invoice is validated, users are initiating the approval workflow using  initiate workflow radio button in AP Invoice Screen.

So that every invoice goes for Invoice approval at Invoice level.

As per new requirement,users will not initiate the approval workflow after creating manual AP Invoices.

I need to developed a program to send approval notification at supplier level (consolidated invoices and amount w.r.t Supplier.

In this program, I need to select all AP Manual Invoices in the system which are validated and pending with invoice approval(WFAPPROVAL_STATUS= 'REQUIRED')