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_TDS_PROCESSING_PKG dependencies on AP_CHECKS_ALL

Line 201: ap_checks_all aca ,

197: jattt.tds_authority_vendor_site_id tax_authority_site_id ,
198: jattt.vendor_id vendor_id ,
199: jattt.vendor_site_id vendor_site_id
200: from
201: ap_checks_all aca ,
202: ap_invoice_payments_all aipa ,
203: ap_invoices_all aia ,
204: jai_ap_tds_thhold_trxs jattt,
205: JAI_CMN_TAXES_ALL jitc

Line 272: ap_checks_all aca,

268: nvl(aia.attribute_category,
269: lv_attribute_category) context ,
270: aia.attribute1 parent_invoice_id
271: from
272: ap_checks_all aca,
273: ap_invoice_payments_all aipa,
274: ap_invoices_all aia
275: where aca.check_id = aipa.check_id
276: and aipa.invoice_id = aia.invoice_id

Line 474: ap_checks_all aca,

470: aca.check_date check_date,
471: aca.amount check_amount,
472: aipa.invoice_payment_id invoice_payment_id
473: from
474: ap_checks_all aca,
475: ap_invoice_payments_all aipa
476: where aca.check_id = aipa.check_id
477: and aipa.invoice_id = pn_invoice_id;
478:

Line 498: FROM ap_checks_all ac

494: having count(*) > 1
495: )
496: AND jatp.check_id NOT IN /* Filter out all voided and stop initiated checks*/
497: (SELECT check_id
498: FROM ap_checks_all ac
499: WHERE ac.check_id = jatp.check_id
500: AND status_lookup_code in ('VOIDED', 'STOP INITIATED')
501: )
502: AND TRUNC(jatp.creation_date) = TRUNC (sysdate)

Line 572: ap_checks_all aca ,

568: (
569: select
570: aca.check_id check_id
571: from
572: ap_checks_all aca ,
573: ap_invoice_payments_all aipa ,
574: ap_invoices_all aia ,
575: jai_ap_tds_thhold_trxs jattt,
576: JAI_CMN_TAXES_ALL jitc

Line 604: /* Get all payments from ap_checks_all */

600:
601: end if; /*if pv_regenerate_flag = 'Y' */
602:
603:
604: /* Get all payments from ap_checks_all */
605: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Payment **');
606: for cur_rec in
607: c_process_tds_payments
608: (

Line 1164: FROM ap_checks_all ac

1160: FROM jai_ap_tds_inv_payments jatp1
1161: WHERE jatp1.invoice_id = r_get_tds_inv_details(ind).invoice_id
1162: AND jatp1.check_id NOT IN
1163: (SELECT check_id
1164: FROM ap_checks_all ac
1165: WHERE ac.check_id = jatp.check_id
1166: AND status_lookup_code in ('VOIDED', 'STOP INITIATED')
1167: )
1168: )