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 188: ap_checks_all aca ,

184: jattt.tds_authority_vendor_site_id tax_authority_site_id ,
185: jattt.vendor_id vendor_id ,
186: jattt.vendor_site_id vendor_site_id
187: from
188: ap_checks_all aca ,
189: ap_invoice_payments_all aipa ,
190: ap_invoices_all aia ,
191: jai_ap_tds_thhold_trxs jattt,
192: JAI_CMN_TAXES_ALL jitc

Line 259: ap_checks_all aca,

255: nvl(aia.attribute_category,
256: lv_attribute_category) context ,
257: aia.attribute1 parent_invoice_id
258: from
259: ap_checks_all aca,
260: ap_invoice_payments_all aipa,
261: ap_invoices_all aia
262: where aca.check_id = aipa.check_id
263: and aipa.invoice_id = aia.invoice_id

Line 461: ap_checks_all aca,

457: aca.check_date check_date,
458: aca.amount check_amount,
459: aipa.invoice_payment_id invoice_payment_id
460: from
461: ap_checks_all aca,
462: ap_invoice_payments_all aipa
463: where aca.check_id = aipa.check_id
464: and aipa.invoice_id = pn_invoice_id;
465:

Line 485: FROM ap_checks_all ac

481: having count(*) > 1
482: )
483: AND jatp.check_id NOT IN /* Filter out all voided and stop initiated checks*/
484: (SELECT check_id
485: FROM ap_checks_all ac
486: WHERE ac.check_id = jatp.check_id
487: AND status_lookup_code in ('VOIDED', 'STOP INITIATED')
488: )
489: AND TRUNC(jatp.creation_date) = TRUNC (sysdate)

Line 559: ap_checks_all aca ,

555: (
556: select
557: aca.check_id check_id
558: from
559: ap_checks_all aca ,
560: ap_invoice_payments_all aipa ,
561: ap_invoices_all aia ,
562: jai_ap_tds_thhold_trxs jattt,
563: JAI_CMN_TAXES_ALL jitc

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

587:
588: end if; /*if pv_regenerate_flag = 'Y' */
589:
590:
591: /* Get all payments from ap_checks_all */
592: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Payment **');
593: for cur_rec in
594: c_process_tds_payments
595: (

Line 1151: FROM ap_checks_all ac

1147: FROM jai_ap_tds_inv_payments jatp1
1148: WHERE jatp1.invoice_id = r_get_tds_inv_details(ind).invoice_id
1149: AND jatp1.check_id NOT IN
1150: (SELECT check_id
1151: FROM ap_checks_all ac
1152: WHERE ac.check_id = jatp.check_id
1153: AND status_lookup_code in ('VOIDED', 'STOP INITIATED')
1154: )
1155: )