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_IT_INVOICES_ABOVE_THRESHOLD dependencies on ZX_RATES_B

Line 668: zx_rates_b zx

664: AND ai.vendor_site_id = pvs.vendor_site_id
665: /* --Changed for performance
666: AND repent.tax_regime_code = (select zx.tax_regime_code
667: From ap_invoice_distributions_all aida1,
668: zx_rates_b zx
669: Where aida1.invoice_id = Ai.invoice_id
670: And ( aida1.charge_applicable_to_dist_id= aid.invoice_distribution_id or
671: aida1.invoice_distribution_id = aid.invoice_distribution_id )
672: And zx.Tax_Rate_Id = aida1.tax_code_id

Line 680: zx_rates_b zx

676: (
677: repent.tax_regime_code =
678: (SELECT zx.tax_regime_code
679: FROM ap_invoice_distributions_all aida1a,
680: zx_rates_b zx
681: WHERE aida1a.invoice_id = ai.invoice_id
682: AND aida1a.charge_applicable_to_dist_id = aid.invoice_distribution_id
683: AND zx.tax_rate_id = aida1a.tax_code_id
684: AND rownum = 1)

Line 689: zx_rates_b zx

685: OR
686: repent.tax_regime_code =
687: (SELECT zx.tax_regime_code
688: FROM ap_invoice_distributions_all aida1b,
689: zx_rates_b zx
690: WHERE aida1b.invoice_id = ai.invoice_id
691: AND aida1b.invoice_distribution_id = aid.invoice_distribution_id
692: AND zx.tax_rate_id = aida1b.tax_code_id
693: AND rownum = 1)

Line 698: zx_rates_b zx

694: OR
695: repent.tax_regime_code =
696: (SELECT zx.tax_regime_code
697: FROM ap_invoice_distributions_all aida1c,
698: zx_rates_b zx
699: WHERE aida1c.invoice_id = ai.invoice_id
700: AND aida1c.charge_applicable_to_dist_id = aid.related_id
701: AND zx.tax_rate_id = aida1c.tax_code_id
702: AND rownum = 1)