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_DAILY_INTEREST_CALC_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 437: ra_customer_trx_lines_all ractrl,

433: p_due_date DATE) IS
434: SELECT cra.receipt_date receipt_date
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,

Line 469: ra_customer_trx_lines_all ractrl,

465: UNION ALL
466: SELECT cra.receipt_date receipt_date
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,

Line 503: ra_customer_trx_lines_all ractrl,

499: UNION ALL
500: SELECT cm.trx_date receipt_date
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,

Line 535: ra_customer_trx_lines_all ractrl,

531: UNION ALL
532: SELECT cm.trx_date receipt_date
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,

Line 569: ra_customer_trx_lines_all ractrl,

565: UNION ALL
566: SELECT adj.apply_date receipt_date
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,

Line 603: ra_customer_trx_lines_all ractrl,

599: p_due_date DATE) IS
600: SELECT cra.receipt_date receipt_date
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,

Line 631: ra_customer_trx_lines_all ractrl,

627: UNION ALL
628: SELECT cm.trx_date receipt_date
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,

Line 659: ra_customer_trx_lines_all ractrl,

655: UNION ALL
656: SELECT adj.apply_date receipt_date
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,