Replacement/Alternative for ap_selected_invoice_checks_all in R12.1.3
I wanted to know what is the replacement/alternative for the table "ap_selected_invoice_checks_all" in R12.1.3?
in 11i we have outsourced check-printing to a third party, so along with the payment file, we will have to send a report listing the checks which are paying more than 11 invoices each (i.e. check would be printed in more than one page and need to handled manually)
for this after payment batch was built, we were querying the tables ap_inv_selection_criteria_all, ap_selected_invoice_checks_all & ap_selected_invoices_all
and displaying the check number, number of invoices, check amount & payment batch name etc.