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 208: from ap_invoice_payments_all app,

204: (api.invoice_type_lookup_code = lv_debit) --rchandan for bug#4428980
205: and
206: ( not exists
207: (Select '1'
208: from ap_invoice_payments_all app,
209: ap_checks_all apc
210: where app.check_id = apc.check_id
211: and app.invoice_id = api.invoice_id
212: and apc.payment_type_flag = 'R'

Line 231: ap_invoice_payments_all app,

227: api.payment_currency_code invoice_currency_code,
228: apc.exchange_date exchange_date
229: FROM ap_invoices_all api,
230: ap_invoice_distributions_all apd,
231: ap_invoice_payments_all app,
232: ap_checks_all apc
233: WHERE api.invoice_id = apd.invoice_id
234: AND apd.distribution_line_number = (select distribution_line_number from ap_invoice_distributions_all
235: where rownum=1

Line 340: ap_invoice_payments_all app

336: xla_ae_headers xah,
337: xla_transaction_entities xte,
338: ap_invoices_all api,
339: ap_checks_all ac ,
340: ap_invoice_payments_all app
341: where xal.application_id = 200 AND
342: xal.ae_header_id = xah.ae_header_id AND
343: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
344: xah.application_id = 200 AND

Line 381: ap_invoice_payments_all app

377: xla_ae_headers xah,
378: xla_transaction_entities xte,
379: ap_invoices_all api,
380: ap_checks_all ac ,
381: ap_invoice_payments_all app
382: where xal.application_id = 200 AND
383: xal.ae_header_id = xah.ae_header_id AND
384: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
385: xah.application_id = 200 AND

Line 657: from ap_invoice_payments_all app,

653: (api.invoice_type_lookup_code = lv_debit)
654: and
655: ( not exists
656: (Select '1'
657: from ap_invoice_payments_all app,
658: ap_checks_all apc
659: where app.check_id = apc.check_id
660: and app.invoice_id = api.invoice_id
661: and apc.payment_type_flag = 'R'

Line 681: ap_invoice_payments_all app,

677: api.payment_currency_code invoice_currency_code,
678: apc.exchange_date exchange_date
679: FROM ap_invoices_all api,
680: ap_invoice_distributions_all apd,
681: ap_invoice_payments_all app,
682: ap_checks_all apc
683: WHERE api.invoice_id = apd.invoice_id
684: AND apd.distribution_line_number = (select distribution_line_number from ap_invoice_distributions_all
685: where rownum=1

Line 790: ap_invoice_payments_all app

786: xla_ae_headers xah,
787: xla_transaction_entities xte,
788: ap_invoices_all api,
789: ap_checks_all ac ,
790: ap_invoice_payments_all app
791: where xal.application_id = 200 AND
792: xal.ae_header_id = xah.ae_header_id AND
793: xal.accounting_class_code in ( p_gain,p_loss) AND --rchandan for bug#4428980
794: xah.application_id = 200 AND

Line 832: ap_invoice_payments_all app

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