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_CHECKS_ALL

Line 209: ap_checks_all apc

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'
213: )

Line 232: ap_checks_all apc

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
236: and invoice_id=apd.invoice_id

Line 339: ap_checks_all ac ,

335: from xla_ae_lines xal,
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

Line 380: ap_checks_all ac ,

376: from xla_ae_lines xal,
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

Line 658: ap_checks_all apc

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'
662: )

Line 682: ap_checks_all apc

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
686: and invoice_id=apd.invoice_id

Line 789: ap_checks_all ac ,

785: from xla_ae_lines xal,
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

Line 831: ap_checks_all ac ,

827: from xla_ae_lines xal,
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