ap_selected_invoice_checks obsolete in R12
Ap_selected_invoice_checks is obsolete in R12. I have this 11i query and need to rewrite it for release 12 and don't know where to begin. Any clues? SELECT a.selected_check_id, a.check_number, a.vendor_id, a.vendor_site_id, a.payment_date, a.check_id, a.check_amount, b.invoice_id, b.original_invoice_id, (select invoice_type_lookup_code from ap_invoices_all where invoice_id = b.invoice_id) invoice_type_lookup_code FROM ap_selected_invoice_checks a, ap_selected_invoices_all b WHERE a.checkrun_name = g_checkrun_name AND (a.selected_check_id = b.print_selected_check_id or a.selected_check_id = b.pay_selected_check_id) |
0