PAY_PAYMT_SEARCH_RESULTS_VL Issue

Summary:

Issue with PAY_PAYMT_SEARCH_RESULTS_VL usage

Content (required):

Hi Team

Greetings!

This issue is about the usage of PAY_PAYMT_SEARCH_RESULTS_VL table ( it is a view actually) to get the status value for check (Void/ Paid/Canceled and cannot be reissued) used in the positive pay file.

When we just try to query on this view PAY_PAYMT_SEARCH_RESULTS_VL - it just times out and keep running for long time.

And when we run it in separate query along with the status check -that ends up in subquery returns more than one row.