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 AR_PAYMENT_SCHEDULES_ALL

Line 249: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

245: CURSOR total_rcpts_csr ( p_lsm_id NUMBER ) IS
246: SELECT NVL(SUM(ARAPP.amount_applied),0)
247: FROM
248: OKL_CNSLD_AR_STRMS_V LSM,
249: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
250: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
251: WHERE
252: LSM.ID = p_lsm_id AND
253: PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND

Line 271: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

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
275: -- LSM.ID = p_lsm_id AND

Line 295: AR_PAYMENT_SCHEDULES_ALL PMTSCH

291: /*
292: CURSOR total_bill_amt_csr ( p_lsm_id NUMBER ) IS
293: SELECT PMTSCH.amount_due_original
294: FROM OKL_CNSLD_AR_STRMS_V LSM,
295: AR_PAYMENT_SCHEDULES_ALL PMTSCH
296: WHERE LSM.ID = p_lsm_id AND
297: PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND
298: PMTSCH.class = 'INV';
299:

Line 308: AR_PAYMENT_SCHEDULES_ALL PMTSCH

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
312: WHERE TLD.TLD_ID = p_tld_id AND

Line 345: l_total_bill_amt AR_PAYMENT_SCHEDULES_ALL.amount_due_original%TYPE;

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:
347: BEGIN
348: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
349: -- OPEN get_lsm_id ( p_ref_sel_id );

Line 984: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

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
988: WHERE

Line 1021: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

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
1025: PMTSCH.customer_trx_id = TLD.customer_trx_id AND

Line 1053: AR_PAYMENT_SCHEDULES_ALL PMTSCH

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
1057: PMTSCH.class = 'INV';