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 342: l_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;

338: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
339:
340: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
341: -- l_lsm_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;
342: l_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
343: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
344: l_total_rcpt_amt AR_RECEIVABLE_APPLICATIONS_ALL.amount_applied%TYPE;
345: l_total_bill_amt AR_PAYMENT_SCHEDULES_ALL.amount_due_original%TYPE;
346:

Line 818: from OKL_TXD_AR_LN_DTLS_B cnsld

814: ste.amount amount,
815: khr.sts_code sts_code
816: --ssiruvol Bug 5000886 start
817: ,(select id
818: from OKL_TXD_AR_LN_DTLS_B cnsld
819: where cnsld.khr_id=p_lk_khr_id
820: AND cnsld.sel_id =ste.sel_id
821: --AND cnsld.receivables_invoice_id IS NOT NULL
822: )

Line 872: from OKL_TXD_AR_LN_DTLS_B cnsld

868: ste.amount amount,
869: khr.sts_code sts_code
870: --ssiruvol Bug 5000886 start
871: ,(select id
872: from OKL_TXD_AR_LN_DTLS_B cnsld
873: where cnsld.khr_id=p_lk_khr_id
874: AND cnsld.sel_id =ste.sel_id
875: --AND cnsld.receivables_invoice_id IS NOT NULL
876: )

Line 1102: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1098: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1099: -- TYPE lsm_err_rec_type IS RECORD (
1100: TYPE tld_err_rec_type IS RECORD (
1101: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1102: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1103: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1104: tap_id okl_trx_ap_invoices_v.id%TYPE,
1105: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1106: -- xpi_id okl_ext_pay_invs_v.id%TYPE,

Line 1120: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1116: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1117: -- TYPE lsm_succ_rec_type IS RECORD (
1118: -- lsm_id okl_cnsld_ar_strms_v.id%TYPE,
1119: TYPE tld_succ_rec_type IS RECORD (
1120: tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1121: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1122: tap_id okl_trx_ap_invoices_v.id%TYPE,
1123: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1124: -- xpi_id okl_ext_pay_invs_v.id%TYPE,

Line 1254: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;

1250: AND LSES.LTY_CODE = 'REVENUE_SHARE';
1251:
1252:
1253: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1254: l_ref_tld_id OKL_TXD_AR_LN_DTLS_B.id%TYPE;
1255: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1256:
1257: l_percent_stake okl_k_lines.percent_stake%TYPE;
1258:

Line 1339: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,

1335: l_billed VARCHAR2(1);
1336: --ssiruvol Bug 5000886 end
1337:
1338: TYPE lsm_succ_rec_type IS RECORD (
1339: lsm_id OKL_TXD_AR_LN_DTLS_B.id%TYPE,
1340: tap_id okl_trx_ap_invoices_v.id%TYPE,
1341: tpl_id okl_txl_ap_inv_lns_v.id%TYPE,
1342: xpi_id okl_ext_pay_invs_v.id%TYPE,
1343: xlp_id okl_xtl_pay_invs_v.id%TYPE,

Line 2256: UPDATE OKL_TXD_AR_LN_DTLS_B

2252: UPDATE okl_strm_elements
2253: SET date_billed = SYSDATE
2254: WHERE id = tld_succ_log_table(i).proc_sel_id;
2255:
2256: UPDATE OKL_TXD_AR_LN_DTLS_B
2257: SET investor_disb_status = 'PROCESSED'
2258: WHERE sel_id = inv_disb_rec.ref_sel_id;
2259:
2260: l_strm_ele_id_tbl(strm_ele_idx):=tld_succ_log_table(i).proc_sel_id;

Line 2277: UPDATE OKL_TXD_AR_LN_DTLS_B

2273: UPDATE okl_strm_elements
2274: SET date_billed = SYSDATE
2275: WHERE id = tld_succ_log_table(i).proc_sel_id;
2276:
2277: UPDATE OKL_TXD_AR_LN_DTLS_B
2278: SET investor_disb_status = 'PROCESSED'
2279: WHERE sel_id = inv_disb_rec.ref_sel_id;
2280:
2281: l_strm_ele_id_tbl(strm_ele_idx):=tld_succ_log_table(i).proc_sel_id;

Line 2330: UPDATE OKL_TXD_AR_LN_DTLS_B

2326: END IF;
2327:
2328: IF l_inv_ele_id_tbl.COUNT > 0 THEN
2329: FORALL indx in l_inv_ele_id_tbl.FIRST .. l_inv_ele_id_tbl.LAST
2330: UPDATE OKL_TXD_AR_LN_DTLS_B
2331: SET investor_disb_status = 'PROCESSED'
2332: WHERE sel_id = l_inv_ele_id_tbl(indx)
2333: and khr_id =inv_lease_k_rec.khr_id;
2334: l_inv_ele_id_tbl:=l_temp_ele_id_tbl;

Line 2340: UPDATE OKL_TXD_AR_LN_DTLS_B

2336: END IF;
2337:
2338: IF l_inv_prtl_id_tbl.COUNT > 0 THEN
2339: FORALL indx in l_inv_prtl_id_tbl.FIRST .. l_inv_prtl_id_tbl.LAST
2340: UPDATE OKL_TXD_AR_LN_DTLS_B
2341: SET investor_disb_status = 'PARTIAL'
2342: WHERE sel_id = l_inv_prtl_id_tbl(indx)
2343: and khr_id =inv_lease_k_rec.khr_id;
2344: l_inv_prtl_id_tbl := l_temp_ele_id_tbl;

Line 2366: UPDATE OKL_TXD_AR_LN_DTLS_B

2362: END IF;
2363:
2364: IF l_inv_ele_id_tbl.COUNT > 0 THEN
2365: FORALL indx in l_inv_ele_id_tbl.FIRST .. l_inv_ele_id_tbl.LAST
2366: UPDATE OKL_TXD_AR_LN_DTLS_B
2367: SET investor_disb_status = 'PROCESSED'
2368: WHERE sel_id = l_inv_ele_id_tbl(indx)
2369: and khr_id = inv_lease_k_rec.khr_id;
2370: l_inv_ele_id_tbl:=l_temp_ele_id_tbl;

Line 2376: UPDATE OKL_TXD_AR_LN_DTLS_B

2372: END IF;
2373:
2374: IF l_inv_prtl_id_tbl.COUNT > 0 THEN
2375: FORALL indx in l_inv_prtl_id_tbl.FIRST .. l_inv_prtl_id_tbl.LAST
2376: UPDATE OKL_TXD_AR_LN_DTLS_B
2377: SET investor_disb_status = 'PARTIAL'
2378: WHERE sel_id = l_inv_prtl_id_tbl(indx)
2379: and khr_id =inv_lease_k_rec.khr_id;
2380: l_inv_prtl_id_tbl := l_temp_ele_id_tbl;