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.JAI_AP_RPT_APCR_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 213: from ap_invoice_payments_all app,

209: (api.invoice_type_lookup_code = lv_debit) --rchandan for bug#4428980
210: and
211: ( not exists
212: (Select '1'
213: from ap_invoice_payments_all app,
214: ap_checks_all apc
215: where app.check_id = apc.check_id
216: and app.invoice_id = api.invoice_id
217: and apc.payment_type_flag = 'R'

Line 239: ap_invoice_payments_all app,

235: api.payment_currency_code invoice_currency_code,
236: apc.exchange_date exchange_date
237: FROM ap_invoices_all api,
238: --ap_invoice_distributions_all apd,Commented by nprashar for bug 8307469
239: ap_invoice_payments_all app,
240: ap_checks_all apc
241: WHERE /*api.invoice_id = apd.invoice_id
242: AND apd.distribution_line_number = (select distribution_line_number from ap_invoice_distributions_all
243: where rownum=1

Line 358: ap_invoice_payments_all app

354: xla_ae_headers xah,
355: xla_transaction_entities xte,
356: ap_invoices_all api,
357: ap_checks_all ac ,
358: ap_invoice_payments_all app
359: where xal.application_id = 200 AND
360: xal.ae_header_id = xah.ae_header_id AND
361: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
362: xah.application_id = 200 AND

Line 402: ap_invoice_payments_all app

398: xla_ae_headers xah,
399: xla_transaction_entities xte,
400: ap_invoices_all api,
401: ap_checks_all ac ,
402: ap_invoice_payments_all app
403: where xal.application_id = 200 AND
404: xal.ae_header_id = xah.ae_header_id AND
405: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
406: xah.application_id = 200 AND

Line 682: from ap_invoice_payments_all app,

678: (api.invoice_type_lookup_code = lv_debit)
679: and
680: ( not exists
681: (Select '1'
682: from ap_invoice_payments_all app,
683: ap_checks_all apc
684: where app.check_id = apc.check_id
685: and app.invoice_id = api.invoice_id
686: and apc.payment_type_flag = 'R'

Line 710: ap_invoice_payments_all app,

706: api.payment_currency_code invoice_currency_code,
707: apc.exchange_date exchange_date
708: FROM ap_invoices_all api,
709: --ap_invoice_distributions_all apd, Commented by nprashar for bug # 8307469
710: ap_invoice_payments_all app,
711: ap_checks_all apc
712: WHERE /*api.invoice_id = apd.invoice_id
713: AND apd.distribution_line_number = (select distribution_line_number from ap_invoice_distributions_all
714: where rownum=1

Line 829: ap_invoice_payments_all app

825: xla_ae_headers xah,
826: xla_transaction_entities xte,
827: ap_invoices_all api,
828: ap_checks_all ac ,
829: ap_invoice_payments_all app
830: where xal.application_id = 200 AND
831: xal.ae_header_id = xah.ae_header_id AND
832: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
833: xah.application_id = 200 AND

Line 874: ap_invoice_payments_all app

870: xla_ae_headers xah,
871: xla_transaction_entities xte,
872: ap_invoices_all api,
873: ap_checks_all ac ,
874: ap_invoice_payments_all app
875: where xal.application_id = 200 AND
876: xal.ae_header_id = xah.ae_header_id AND
877: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
878: xah.application_id = 200 AND