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_RPT_APCR_PKG dependencies on AP_INVOICE_LINES_ALL

Line 255: AND Exists ( Select '1' from ap_invoice_distributions_all apd , ap_invoice_lines_all apil where apd.invoice_id = api.invoice_id

251: AND api.vendor_id = p_vendor_id
252: AND api.vendor_site_id = v_vendor_site_id
253: AND app.accounting_date < trunc(p_bal_date)
254: AND ( api.org_id = p_org_id or api.org_id is null )
255: AND Exists ( Select '1' from ap_invoice_distributions_all apd , ap_invoice_lines_all apil where apd.invoice_id = api.invoice_id
256: and apil.invoice_id = apd.invoice_id
257: and apd.match_status_flag ='A'
258: and apil.line_number = apd.invoice_line_number) /*Added by nprashar for bug 12651044 */
259: AND api.invoice_currency_code =nvl( p_currency_code,api.invoice_currency_code) /* Added by vumaasha for bug 8310720 */

Line 726: AND Exists ( Select '1' from ap_invoice_distributions_all apd , ap_invoice_lines_all apil where apd.invoice_id = api.invoice_id

722: AND api.vendor_id = p_vendor_id
723: AND api.vendor_site_id = v_vendor_site_id
724: AND app.accounting_date < p_bal_date
725: AND ( api.org_id = p_org_id or api.org_id is null ) -- added by Aparajita on 26-sep-2002 for bug # 2574262
726: AND Exists ( Select '1' from ap_invoice_distributions_all apd , ap_invoice_lines_all apil where apd.invoice_id = api.invoice_id
727: and apil.invoice_id = apd.invoice_id
728: and apd.match_status_flag ='A'
729: and apil.line_number = apd.invoice_line_number) --Added by nprashar for bug # 12651044
730: AND api.invoice_currency_code =nvl( p_currency_code,api.invoice_currency_code) /* Added by vumaasha for bug 8310720 */