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.OKL_CREATE_DISB_TRANS_PVT dependencies on AP_INVOICES_ALL

Line 1380: FROM ap_invoices_all ap

1376: */
1377: --start: cklee 08/31/07 fixed for the migration
1378: CURSOR l_khr_line_amt_csr(cp_invoice_id NUMBER, cp_khr_id NUMBER) IS
1379: SELECT sum(tpl.amount) khr_line_amount
1380: FROM ap_invoices_all ap
1381: ,okl_txl_ap_inv_lns_all_b tpl
1382: ,okl_cnsld_ap_invs_all cin
1383: where ap.product_table = 'OKL_CNSLD_AP_INVS_ALL'
1384: AND cin.cnsld_ap_inv_id = TO_NUMBER(ap.reference_key1)