[Home] [Help]
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
269: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND
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
291: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK
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:
362: BEGIN
363: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK
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
1004: TLD.TLD_ID = p_tld_id AND
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
1041: ARAPP.LINE_APPLIED > 0 AND