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_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_TXD_AR_LN_DTLS_B

Line 357: l_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;

353: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
354:
355: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
356: -- l_lsm_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;
357: l_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
358: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
359: l_total_rcpt_amt AR_RECEIVABLE_APPLICATIONS_ALL.amount_applied%TYPE;
360: l_total_bill_amt AR_PAYMENT_SCHEDULES_ALL.amount_due_original%TYPE;
361:

Line 833: from OKL_TXD_AR_LN_DTLS_B cnsld

829: ste.amount amount,
830: khr.sts_code sts_code
831: --ssiruvol Bug 5000886 start
832: ,(select id
833: from OKL_TXD_AR_LN_DTLS_B cnsld
834: where cnsld.khr_id=p_lk_khr_id
835: AND cnsld.sel_id =ste.sel_id
836: --AND cnsld.receivables_invoice_id IS NOT NULL
837: )

Line 887: from OKL_TXD_AR_LN_DTLS_B cnsld

883: ste.amount amount,
884: khr.sts_code sts_code
885: --ssiruvol Bug 5000886 start
886: ,(select id
887: from OKL_TXD_AR_LN_DTLS_B cnsld
888: where cnsld.khr_id=p_lk_khr_id
889: AND cnsld.sel_id =ste.sel_id
890: --AND cnsld.receivables_invoice_id IS NOT NULL
891: )

Line 1172: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1168: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1169: -- TYPE lsm_err_rec_type IS RECORD (
1170: TYPE tld_err_rec_type IS RECORD (
1171: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1172: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1173: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1174: tap_id okl_trx_ap_invoices_v.id%TYPE,
1175: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1176: -- xpi_id okl_ext_pay_invs_v.id%TYPE,

Line 1190: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1186: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1187: -- TYPE lsm_succ_rec_type IS RECORD (
1188: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1189: TYPE tld_succ_rec_type IS RECORD (
1190: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1191: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1192: tap_id okl_trx_ap_invoices_v.id%TYPE,
1193: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1194: -- xpi_id okl_ext_pay_invs_v.id%TYPE,

Line 1324: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;

1320: AND LSES.LTY_CODE = 'REVENUE_SHARE';
1321:
1322:
1323: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1324: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
1325: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1326:
1327: l_percent_stake okl_k_lines.percent_stake%TYPE;
1328:

Line 1409: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1405: l_billed VARCHAR2(1);
1406: --ssiruvol Bug 5000886 end
1407:
1408: TYPE lsm_succ_rec_type IS RECORD (
1409: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1410: tap_id okl_trx_ap_invoices_v.id%TYPE,
1411: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1412: xpi_id okl_ext_pay_invs_v.id%TYPE,
1413: xlp_id okl_xtl_pay_invs_v.id%TYPE,

Line 2347: UPDATE OKL_TXD_AR_LN_DTLS_B

2343: ,last_update_date = sysdate
2344: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2345: WHERE id = tld_succ_log_table(i).proc_sel_id;
2346:
2347: UPDATE OKL_TXD_AR_LN_DTLS_B
2348: SET investor_disb_status = 'PROCESSED'
2349: WHERE sel_id = inv_disb_rec.ref_sel_id;
2350:
2351: l_strm_ele_id_tbl(strm_ele_idx):=tld_succ_log_table(i).proc_sel_id;

Line 2371: UPDATE OKL_TXD_AR_LN_DTLS_B

2367: ,last_update_date = sysdate
2368: ,last_update_login = FND_GLOBAL.LOGIN_ID -- BUG:14742784 change end here
2369: WHERE id = tld_succ_log_table(i).proc_sel_id;
2370:
2371: UPDATE OKL_TXD_AR_LN_DTLS_B
2372: SET investor_disb_status = 'PROCESSED'
2373: WHERE sel_id = inv_disb_rec.ref_sel_id;
2374:
2375: l_strm_ele_id_tbl(strm_ele_idx):=tld_succ_log_table(i).proc_sel_id;

Line 2427: UPDATE OKL_TXD_AR_LN_DTLS_B

2423: END IF;
2424:
2425: IF l_inv_ele_id_tbl.COUNT > 0 THEN
2426: FORALL indx in l_inv_ele_id_tbl.FIRST .. l_inv_ele_id_tbl.LAST
2427: UPDATE OKL_TXD_AR_LN_DTLS_B
2428: SET investor_disb_status = 'PROCESSED'
2429: WHERE sel_id = l_inv_ele_id_tbl(indx)
2430: and khr_id =inv_lease_k_rec.khr_id;
2431: l_inv_ele_id_tbl:=l_temp_ele_id_tbl;

Line 2437: UPDATE OKL_TXD_AR_LN_DTLS_B

2433: END IF;
2434:
2435: IF l_inv_prtl_id_tbl.COUNT > 0 THEN
2436: FORALL indx in l_inv_prtl_id_tbl.FIRST .. l_inv_prtl_id_tbl.LAST
2437: UPDATE OKL_TXD_AR_LN_DTLS_B
2438: SET investor_disb_status = 'PARTIAL'
2439: WHERE sel_id = l_inv_prtl_id_tbl(indx)
2440: and khr_id =inv_lease_k_rec.khr_id;
2441: l_inv_prtl_id_tbl := l_temp_ele_id_tbl;

Line 2466: UPDATE OKL_TXD_AR_LN_DTLS_B

2462: END IF;
2463:
2464: IF l_inv_ele_id_tbl.COUNT > 0 THEN
2465: FORALL indx in l_inv_ele_id_tbl.FIRST .. l_inv_ele_id_tbl.LAST
2466: UPDATE OKL_TXD_AR_LN_DTLS_B
2467: SET investor_disb_status = 'PROCESSED'
2468: WHERE sel_id = l_inv_ele_id_tbl(indx)
2469: and khr_id = inv_lease_k_rec.khr_id;
2470: l_inv_ele_id_tbl:=l_temp_ele_id_tbl;

Line 2476: UPDATE OKL_TXD_AR_LN_DTLS_B

2472: END IF;
2473:
2474: IF l_inv_prtl_id_tbl.COUNT > 0 THEN
2475: FORALL indx in l_inv_prtl_id_tbl.FIRST .. l_inv_prtl_id_tbl.LAST
2476: UPDATE OKL_TXD_AR_LN_DTLS_B
2477: SET investor_disb_status = 'PARTIAL'
2478: WHERE sel_id = l_inv_prtl_id_tbl(indx)
2479: and khr_id =inv_lease_k_rec.khr_id;
2480: l_inv_prtl_id_tbl := l_temp_ele_id_tbl;