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_INVOICES

Line 171: FROM ap_invoices aia

167: BEGIN
168: BEGIN
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

Line 204: AND xdl.applied_to_entity_code = 'AP_INVOICES'

200: AND xdl.ae_header_id = xal.ae_header_id
201: AND xal.application_id = 200
202: AND xdl.ae_line_num = xal.ae_line_num
203: AND xdl.accounting_line_code NOT IN ('AP_LIAB_AWT_PMT')
204: AND xdl.applied_to_entity_code = 'AP_INVOICES'
205: AND xal.ae_header_id = xah.ae_header_id
206: AND xah.application_id = 200
207: AND xah.ledger_id = LEDGER_ID_PARAM
208: AND xdl.rounding_class_code = 'LIABILITY'

Line 227: FROM ap_invoices ai

223: --for standard invoice
224: BEGIN
225: SELECT SUM(NVL(xal.accounted_cr,0)-NVL(xal.accounted_dr,0))
226: INTO gn_open_invoice_balance
227: FROM ap_invoices ai
228: ,xla_transaction_entities xte
229: ,xla_events xe
230: ,xla_ae_headers xah
231: ,xla_ae_lines xal

Line 245: AND xte.entity_code = 'AP_INVOICES'

241: AND xte.application_id = 200
242: AND xe.application_id = 200
243: AND xah.application_id = 200
244: AND xal.application_id = 200
245: AND xte.entity_code = 'AP_INVOICES'
246: AND xe.entity_id = xte.entity_id
247: AND xah.entity_id = xte.entity_id
248: AND xe.event_type_code NOT IN ('PREPAYMENT UNAPPLIED','PREPAYMENT APPLIED')
249: AND xah.event_id = xe.event_id