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 OKL_TXD_AR_LN_DTLS_B

Line 436: FROM okl_txd_ar_ln_dtls_b tld,

432: p_start_date DATE,
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,

Line 468: FROM okl_txd_ar_ln_dtls_b tld,

464: GROUP BY receipt_date
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,

Line 502: FROM okl_txd_ar_ln_dtls_b tld,

498: GROUP BY receipt_date
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,

Line 534: FROM okl_txd_ar_ln_dtls_b tld,

530: GROUP BY cm.trx_date
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,

Line 568: FROM okl_txd_ar_ln_dtls_b tld,

564: GROUP BY cm.trx_date
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,

Line 602: FROM okl_txd_ar_ln_dtls_b tld,

598: p_start_date DATE,
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,

Line 630: FROM okl_txd_ar_ln_dtls_b tld,

626: GROUP BY receipt_date
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,

Line 658: FROM okl_txd_ar_ln_dtls_b tld,

654: GROUP BY cm.trx_date
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,