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.JE_ITWHYE_AP_PKG dependencies on AP_TAX_CODES

Line 463: FROM ap_tax_codes_all atc_sub,

459: WHERE dist.invoice_id = cur_withholding_extract_rec.invoice_id
460: AND dist.line_type_lookup_code in ('ITEM', 'ACCRUAL') --bug14369763
461: AND nvl(dist.pay_awt_group_id, nvl(dist.awt_group_id,dist.awt_origin_group_id)) IN ( --bug14369763
462: SELECT awgt_sub.GROUP_ID
463: FROM ap_tax_codes_all atc_sub,
464: ap_awt_tax_rates_all awt_sub,
465: ap_awt_group_taxes_all awgt_sub
466: WHERE awgt_sub.tax_name = awt_sub.tax_name
467: AND atc_sub.NAME = awt_sub.tax_name

Line 511: FROM ap_tax_codes_all atc_sub,

507: AND dist.invoice_id = cur_withholding_extract_rec.invoice_id
508: AND dist.line_type_lookup_code in ('ITEM','ACCRUAL') --bug14369763
509: AND NVL(dist.pay_awt_group_id, nvl(dist.awt_group_id, dist.awt_origin_group_id)) NOT IN ( --bug14369763
510: SELECT awgt_sub.GROUP_ID
511: FROM ap_tax_codes_all atc_sub,
512: ap_awt_tax_rates_all awt_sub,
513: ap_awt_group_taxes_all awgt_sub
514: WHERE awgt_sub.tax_name = awt_sub.tax_name
515: AND atc_sub.NAME = awt_sub.tax_name

Line 693: ap_tax_codes atc,

689: INTO ln_irpef_rate, lc_irpef_taxname,
690: ln_irpef_wthamount,
691: lc_irpef_vendor_name
692: FROM ap_invoice_distributions dist,
693: ap_tax_codes atc,
694: ap_invoices inv1,
695: ap_awt_tax_rates awt,
696: ap_suppliers aps
697: WHERE dist.invoice_id = inv1.invoice_id

Line 745: ap_tax_codes atc,

741: INTO ln_inps_rate, lc_inps_taxname,
742: ln_inps_wthamount,
743: lc_inps_vendor_name
744: FROM ap_invoice_distributions dist,
745: ap_tax_codes atc,
746: ap_invoices inv1,
747: ap_awt_tax_rates awt,
748: ap_suppliers aps
749: WHERE dist.invoice_id = inv1.invoice_id