APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 250: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP

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
254: ARAPP.applied_payment_schedule_id = PMTSCH.payment_schedule_id AND

Line 272: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP

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
276: --end:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 344: l_total_rcpt_amt AR_RECEIVABLE_APPLICATIONS_ALL.amount_applied%TYPE;

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:
347: BEGIN
348: --start:| 09-Mar-2007 cklee code fixed to refer to proper FK

Line 985: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP,

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

Line 1022: AR_RECEIVABLE_APPLICATIONS_ALL ARAPP

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
1026: ARAPP.LINE_APPLIED > 0 AND