APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 439: okl_trx_ar_invoices_b tai,

435: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount --4884843, 4872370
436: FROM okl_txd_ar_ln_dtls_b tld,
437: ra_customer_trx_lines_all ractrl,
438: okl_txl_ar_inv_lns_b til,
439: okl_trx_ar_invoices_b tai,
440: ar_payment_schedules_all aps,
441: ar_receivable_applications_all raa,
442: ar_cash_receipts_all cra,
443: okl_strm_type_b sty_ln_pmt,

Line 471: okl_trx_ar_invoices_b tai,

467: ,SUM(raa.line_applied) receipt_amount --4884843, 4872370
468: FROM okl_txd_ar_ln_dtls_b tld,
469: ra_customer_trx_lines_all ractrl,
470: okl_txl_ar_inv_lns_b til,
471: okl_trx_ar_invoices_b tai,
472: ar_payment_schedules_all aps,
473: ar_receivable_applications_all raa,
474: ar_cash_receipts_all cra,
475: okl_strm_type_b sty_ln_pmt

Line 505: okl_trx_ar_invoices_b tai,

501: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount
502: FROM okl_txd_ar_ln_dtls_b tld,
503: ra_customer_trx_lines_all ractrl,
504: okl_txl_ar_inv_lns_b til,
505: okl_trx_ar_invoices_b tai,
506: ar_payment_schedules_all aps,
507: ar_receivable_applications_all raa,
508: ra_customer_trx_all cm,
509: okl_strm_type_b sty_ln_pmt,

Line 537: okl_trx_ar_invoices_b tai,

533: ,SUM(raa.line_applied) receipt_amount
534: FROM okl_txd_ar_ln_dtls_b tld,
535: ra_customer_trx_lines_all ractrl,
536: okl_txl_ar_inv_lns_b til,
537: okl_trx_ar_invoices_b tai,
538: ar_payment_schedules_all aps,
539: ar_receivable_applications_all raa,
540: ra_customer_trx_all cm,
541: okl_strm_type_b sty_ln_pmt

Line 571: okl_trx_ar_invoices_b tai,

567: ,SUM(nvl(ad.amount_dr,0))- SUM(nvl(ad.amount_cr,0)) receipt_amount
568: FROM okl_txd_ar_ln_dtls_b tld,
569: ra_customer_trx_lines_all ractrl,
570: okl_txl_ar_inv_lns_b til,
571: okl_trx_ar_invoices_b tai,
572: ar_payment_schedules_all aps,
573: ar_adjustments_all adj,
574: okl_strm_type_b sty,
575: ar_distributions_all ad

Line 605: okl_trx_ar_invoices_b tai,

601: ,SUM(line_applied) receipt_amount --4884843, 4872370
602: FROM okl_txd_ar_ln_dtls_b tld,
603: ra_customer_trx_lines_all ractrl,
604: okl_txl_ar_inv_lns_b til,
605: okl_trx_ar_invoices_b tai,
606: ar_payment_schedules_all aps,
607: ar_receivable_applications_all raa,
608: ar_cash_receipts_all cra,
609: okl_strm_type_b sty

Line 633: okl_trx_ar_invoices_b tai,

629: ,SUM(line_applied) receipt_amount
630: FROM okl_txd_ar_ln_dtls_b tld,
631: ra_customer_trx_lines_all ractrl,
632: okl_txl_ar_inv_lns_b til,
633: okl_trx_ar_invoices_b tai,
634: ar_payment_schedules_all aps,
635: ar_receivable_applications_all raa,
636: ra_customer_trx_all cm,
637: okl_strm_type_b sty

Line 661: okl_trx_ar_invoices_b tai,

657: ,SUM(-1 * NVL(adj.amount,0)) receipt_amount
658: FROM okl_txd_ar_ln_dtls_b tld,
659: ra_customer_trx_lines_all ractrl,
660: okl_txl_ar_inv_lns_b til,
661: okl_trx_ar_invoices_b tai,
662: ar_payment_schedules_all aps,
663: ar_adjustments_all adj,
664: okl_strm_type_b sty
665: WHERE tai.trx_status_code = 'PROCESSED'