We are in need of reporting all of our invoices that are currently on hold. Our AP team placed invoices on hold by placing the installment on hold.
I have been searching through the tables trying to create a report to show these invoices, but they do not reside in AP_HOLDS_ALL. I've been playing with IBY_PAYMENTS_ALL and a few other tables trying to see if it might possibly be a status, but I think I am looking in the wrong areas.
Does anyone have an idea of where I might be able to find where installment holds are stored?
Thank you.