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_PAYMENT_HIST_DISTS

Line 100: ap_payment_hist_dists payh ,

96: SUM(xdln.unrounded_accounted_dr) gross_amount,
97: MIN(aip.invoice_id) invoice_id
98: FROM ap_invoice_distributions aid ,
99: ap_invoice_payments aip ,
100: ap_payment_hist_dists payh ,
101: xla_distribution_links xdln ,
102: xla_ae_headers xlah
103: WHERE aip.invoice_id = pn_invoice_id
104: AND aip.check_id = pn_check_id

Line 129: ap_payment_hist_dists payh ,

125: SUM(xdln.unrounded_accounted_dr) gross_amount,
126: MIN(aip.invoice_id) invoice_id
127: FROM ap_invoice_distributions aid ,
128: ap_invoice_payments aip ,
129: ap_payment_hist_dists payh ,
130: xla_distribution_links xdln ,
131: xla_ae_headers xlah
132: WHERE aip.invoice_id = pn_invoice_id
133: AND aip.check_id = pn_check_id

Line 157: ap_payment_hist_dists payh ,

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
161: WHERE aid.invoice_id = cn_invoice_id