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_BPD_TLD_AR_LINES_V

Line 198: FROM okl_bpd_tld_ar_lines_v

194: -- CURSOR lsm_csr ( p_ref_sel_id NUMBER ) IS
195: CURSOR tld_csr ( p_ref_sel_id NUMBER ) IS
196: --end:| 14-Mar-2007 cklee Bug fixed for billing impact |
197: SELECT customer_trx_id
198: FROM okl_bpd_tld_ar_lines_v
199: WHERE sel_id = p_ref_sel_id AND
200: customer_trx_id IS NOT NULL;
201:
202: --start:| 14-Mar-2007 cklee Bug fixed for billing impact |

Line 204: l_recv_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;

200: customer_trx_id IS NOT NULL;
201:
202: --start:| 14-Mar-2007 cklee Bug fixed for billing impact |
203: -- l_recv_id okl_cnsld_ar_strms_b.receivables_invoice_id%TYPE;
204: l_recv_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;
205: --end:| 14-Mar-2007 cklee Bug fixed for billing impact |
206:
207: BEGIN
208:

Line 270: okl_bpd_tld_ar_lines_v TLD,

266: FROM
267: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
268: -- OKL_CNSLD_AR_STRMS_V LSM,
269: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
270: okl_bpd_tld_ar_lines_v TLD,
271: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
272: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
273: WHERE
274: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 307: FROM okl_bpd_tld_ar_lines_v TLD,

303: SELECT PMTSCH.amount_due_original
304: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
305: -- FROM OKL_CNSLD_AR_STRMS_V LSM,
306: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
307: FROM okl_bpd_tld_ar_lines_v TLD,
308: AR_PAYMENT_SCHEDULES_ALL PMTSCH
309: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
310: -- WHERE LSM.ID = p_lsm_id AND
311: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 318: FROM okl_bpd_tld_ar_lines_v

314: PMTSCH.class = 'INV';
315: /*
316: CURSOR get_tld_id ( p_ref_sel_id NUMBER ) IS
317: SELECT TLD_ID
318: FROM okl_bpd_tld_ar_lines_v
319: WHERE sel_id = p_ref_sel_id;
320: */
321:
322: /*

Line 335: FROM okl_bpd_tld_ar_lines_v

331: -- CURSOR get_lsm_id ( p_ref_sel_id NUMBER ) IS
332: CURSOR get_tld_id ( p_ref_sel_id NUMBER ) IS
333: -- SELECT customer_trx_id
334: SELECT tld_id
335: FROM okl_bpd_tld_ar_lines_v
336: -- WHERE tld_id = p_ref_sel_id;
337: WHERE sel_id = p_ref_sel_id;
338: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
339:

Line 341: -- l_lsm_id okl_bpd_tld_ar_lines_v.customer_trx_id%TYPE;

337: WHERE sel_id = p_ref_sel_id;
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;

Line 983: okl_bpd_tld_ar_lines_v TLD,

979: PMTSCH.amount_due_remaining,
980: TLD.TLD_ID TLD_ID,
981: TLD.LINE_amount AMOUNT
982: FROM
983: okl_bpd_tld_ar_lines_v TLD,
984: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
985: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,
986: ra_Customer_trx_Lines_All cUst_trx_Lines ,
987: ar_Activity_Details arl

Line 1020: okl_bpd_tld_ar_lines_v TLD,

1016: PMTSCH.amount_due_remaining,
1017: TLD.TLD_ID TLD_ID,
1018: TLD.LINE_amount AMOUNT
1019: FROM
1020: okl_bpd_tld_ar_lines_v TLD,
1021: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1022: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
1023: WHERE
1024: TLD.TLD_ID = p_tld_id AND

Line 1052: FROM okl_bpd_tld_ar_lines_v TLD,

1048:
1049: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1050: CURSOR total_bill_amt_csr ( p_tld_id NUMBER ) IS
1051: SELECT PMTSCH.amount_due_original
1052: FROM okl_bpd_tld_ar_lines_v TLD,
1053: AR_PAYMENT_SCHEDULES_ALL PMTSCH
1054: WHERE TLD.TLD_ID = p_tld_id AND
1055: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1056: PMTSCH.customer_trx_id = TLD.customer_trx_id AND

Line 1223: FROM okl_bpd_tld_ar_lines_v

1219:
1220: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1221: CURSOR get_ref_tld_id ( p_ref_sel_id NUMBER ) IS
1222: SELECT tld_Id
1223: FROM okl_bpd_tld_ar_lines_v
1224: WHERE sel_id = p_ref_sel_id
1225: AND CUSTOMER_TRX_ID IS NOT NULL;
1226: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1227: