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_IL_TAX_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 156: FROM ap_invoice_distributions_all aid ,

152: SELECT xdln.event_id event,
153: xlah.ae_header_id ,
154: xlah.ledger_id ,
155: SUM(xdln.unrounded_accounted_dr) pay_amount
156: FROM ap_invoice_distributions_all aid ,
157: ap_payment_hist_dists payh ,
158: xla_distribution_links xdln ,
159: xla_ae_headers xlah ,
160: ap_invoice_payments_all aip

Line 195: FROM ap_invoice_distributions_all aid ,

191: SELECT xdln.event_id event,
192: xlah.ae_header_id ,
193: xlah.ledger_id ,
194: SUM(xdln.unrounded_accounted_dr) pay_amount
195: FROM ap_invoice_distributions_all aid ,
196: xla_distribution_links xdln,
197: xla_ae_headers xlah
198: WHERE aid.invoice_id = cn_invoice_id
199: AND aid.line_type_lookup_code = 'AWT'

Line 243: FROM ap_invoice_distributions_all aid ,

239: END LOOP;
240: ELSE
241: BEGIN
242: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
243: FROM ap_invoice_distributions_all aid ,
244: xla_distribution_links xdln,
245: xla_ae_headers xlah
246: WHERE aid.invoice_id = ln_invoice_id
247: AND aid.line_type_lookup_code <> 'AWT'