scalar subquery

Hi Experts,

Our database version 19.17

We need your guidance if the attached sql query can be tuned furthur. Currently,it takes 5 minutes to complete. Attached tkprof output and execution plan along with index stats.

Problem is with high CPU consumption. Query executed 11985 times for each and every record. Is there any option to reduce the number of executions.

SQL> select count(*) from AP_INVOICES_ALL;

 COUNT(*)

----------

  1123264

SQL> select count(*) from AP_BATCHES_ALL;

 COUNT(*)

----------

  307099

Thanks,

SG