eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_TURNOVER_RPT_PKG dependencies on AP_CHECKS

Line 87: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,ap_checks ac';

83: gc_prepay_invoice_select := gc_prepay_invoice_select ||' AND asps.when_to_account_pmt=''ALWAYS''';
84: gc_prepay_invoice_select := gc_prepay_invoice_select ||' THEN ac.check_date END) ';
85:
86: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ap_invoice_payments aip';
87: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,ap_checks ac';
88: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,ap_system_parameters asps';
89: gc_prepay_invoice_from := gc_prepay_invoice_from ||' ,gl_code_combinations gcc';
90: --************************
91: --WHERE Clause

Line 173: ,ap_checks ac

169: SELECT SUM(NVL(xdl.unrounded_accounted_dr,0)-NVL(xdl.unrounded_accounted_cr,0))
170: INTO gn_open_payment_balance
171: FROM ap_invoices aia
172: ,ap_invoice_payments aip
173: ,ap_checks ac
174: ,ap_payment_history aph
175: ,ap_lookup_codes alc
176: ,ap_system_parameters asps
177: ,xla_events xe