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_VARIABLE_INTEREST_PVT dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 1323: -- invoice id joined to the ap_invoices table. fts on ap_payment_schedules_all

1319: l_funding_req NUMBER := 0;
1320:
1321: -- sjalasut, modified the cursor to change khr_id references from hdr to line
1322: -- also introduced okl_cnsld_ap_invs_all table to have consolidated ap
1323: -- invoice id joined to the ap_invoices table. fts on ap_payment_schedules_all
1324: Cursor Amount_Funded_Cur (p_chr_id IN NUMBER, p_date IN DATE) IS
1325: select nvl(sum(ap_inv.payment_amount_total), 0) AMOUNT
1326: from ap_invoices_all ap_inv,
1327: okl_trx_ap_invoices_b okl_inv,

Line 1328: ap_payment_schedules_all pay_sche

1324: Cursor Amount_Funded_Cur (p_chr_id IN NUMBER, p_date IN DATE) IS
1325: select nvl(sum(ap_inv.payment_amount_total), 0) AMOUNT
1326: from ap_invoices_all ap_inv,
1327: okl_trx_ap_invoices_b okl_inv,
1328: ap_payment_schedules_all pay_sche
1329: ,okl_cnsld_ap_invs_all cnsld
1330: ,okl_txl_ap_inv_lns_all_b okl_inv_ln
1331: ,fnd_application fnd_app
1332: where okl_inv.id = okl_inv_ln.tap_id