APPS.AP_R11_PREPAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 742: -- Go to base tables AP_INVIOCES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL ( only for D2 )

738:
739: debug_info := 'Get orig_amount, dist_item_amount, and dist_tax_amount';
740:
741: -- Perf bug 5058989
742: -- Go to base tables AP_INVIOCES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL ( only for D2 )
743: -- to eliminate MJC and reduce shared memory usage
744:
745: SELECT nvl(I.original_prepayment_amount,0),
746: ap_utilities_pkg.ap_round_precision(

Line 761: ap_invoice_distributions_all D2

757: INTO X_orig_amount,
758: X_dist_item_amount,
759: X_dist_tax_amount
760: FROM ap_invoices_all I, ap_invoice_distributions D1,
761: ap_invoice_distributions_all D2
762: WHERE I.invoice_id = X_prepay_id
763: AND D1.invoice_id = I.invoice_id
764: AND D1.distribution_line_number = 1
765: AND D2.invoice_id(+) = D1.invoice_id -- Perf bug 5058989 -- replace I. with D1.