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 OKL_TXL_AP_INV_LNS_ALL_B

Line 1368: ,okl_txl_ap_inv_lns_all_b tpl

1364: /*
1365: CURSOR l_khr_line_amt_csr(cp_invoice_id NUMBER, cp_khr_id NUMBER) IS
1366: SELECT sum(lin.amount) khr_line_amount
1367: FROM ap_invoice_lines_all lin
1368: ,okl_txl_ap_inv_lns_all_b tpl
1369: ,fnd_application app
1370: WHERE lin.application_id = app.application_id
1371: AND app.application_short_name = 'OKL'
1372: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

Line 1372: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'

1368: ,okl_txl_ap_inv_lns_all_b tpl
1369: ,fnd_application app
1370: WHERE lin.application_id = app.application_id
1371: AND app.application_short_name = 'OKL'
1372: AND lin.product_table = 'OKL_TXL_AP_INV_LNS_ALL_B'
1373: AND tpl.id = TO_NUMBER(lin.reference_key1)
1374: AND lin.invoice_id = cp_invoice_id
1375: AND tpl.khr_id = cp_khr_id;
1376: */

Line 1381: ,okl_txl_ap_inv_lns_all_b tpl

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)
1385: AND tpl.cnsld_ap_inv_id = cin.cnsld_ap_inv_id