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 214: ap_checks_all apc

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

Line 240: ap_checks_all apc

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

Line 357: ap_checks_all ac ,

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

Line 401: ap_checks_all ac ,

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

Line 683: ap_checks_all apc

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

Line 711: ap_checks_all apc

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

Line 828: ap_checks_all ac ,

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

Line 873: ap_checks_all ac ,

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