Payables and Cash Management - EBS (MOSC)

MOSC Banner

ap_selected_invoice_checks obsolete in R12

edited Jul 1, 2018 5:00AM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered
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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center