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 264: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

260: CURSOR total_rcpts_csr ( p_lsm_id NUMBER ) IS
261: SELECT NVL(SUM(ARAPP.amount_applied),0)
262: FROM
263: OKL_CNSLD_AR_STRMS_V LSM,
264: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
265: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
266: WHERE
267: LSM.ID = p_lsm_id AND
268: PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND

Line 286: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

282: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
283: -- OKL_CNSLD_AR_STRMS_V LSM,
284: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
285: okl_bpd_tld_ar_lines_v TLD,
286: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
287: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
288: WHERE
289: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
290: -- LSM.ID = p_lsm_id AND

Line 310: AR_PAYMENT_SCHEDULES_ALL PMTSCH

306: /*
307: CURSOR total_bill_amt_csr ( p_lsm_id NUMBER ) IS
308: SELECT PMTSCH.amount_due_original
309: FROM OKL_CNSLD_AR_STRMS_V LSM,
310: AR_PAYMENT_SCHEDULES_ALL PMTSCH
311: WHERE LSM.ID = p_lsm_id AND
312: PMTSCH.customer_trx_id = LSM.receivables_invoice_id AND
313: PMTSCH.class = 'INV';
314:

Line 323: AR_PAYMENT_SCHEDULES_ALL PMTSCH

319: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
320: -- FROM OKL_CNSLD_AR_STRMS_V LSM,
321: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
322: FROM okl_bpd_tld_ar_lines_v TLD,
323: AR_PAYMENT_SCHEDULES_ALL PMTSCH
324: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
325: -- WHERE LSM.ID = p_lsm_id AND
326: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
327: WHERE TLD.TLD_ID = p_tld_id AND

Line 360: l_total_bill_amt AR_PAYMENT_SCHEDULES_ALL.amount_due_original%TYPE;

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

Line 999: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

995: TLD.TLD_ID TLD_ID,
996: TLD.LINE_amount AMOUNT
997: FROM
998: okl_bpd_tld_ar_lines_v TLD,
999: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1000: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,
1001: ra_Customer_trx_Lines_All cUst_trx_Lines ,
1002: ar_Activity_Details arl
1003: WHERE

Line 1036: AR_PAYMENT_SCHEDULES_ALL PMTSCH,

1032: TLD.TLD_ID TLD_ID,
1033: TLD.LINE_amount AMOUNT
1034: FROM
1035: okl_bpd_tld_ar_lines_v TLD,
1036: AR_PAYMENT_SCHEDULES_ALL PMTSCH,
1037: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP
1038: WHERE
1039: TLD.TLD_ID = p_tld_id AND
1040: PMTSCH.customer_trx_id = TLD.customer_trx_id AND

Line 1123: AR_PAYMENT_SCHEDULES_ALL PMTSCH

1119: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
1120: CURSOR total_bill_amt_csr ( p_tld_id NUMBER ) IS
1121: SELECT PMTSCH.amount_due_original
1122: FROM okl_bpd_tld_ar_lines_v TLD,
1123: AR_PAYMENT_SCHEDULES_ALL PMTSCH
1124: WHERE TLD.TLD_ID = p_tld_id AND
1125: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
1126: PMTSCH.customer_trx_id = TLD.customer_trx_id AND
1127: PMTSCH.class = 'INV';