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_TXL_AR_INV_LNS_B

Line 438: okl_txl_ar_inv_lns_b til,

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,
442: ar_cash_receipts_all cra,

Line 470: okl_txl_ar_inv_lns_b til,

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,
474: ar_cash_receipts_all cra,

Line 504: okl_txl_ar_inv_lns_b til,

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,
508: ra_customer_trx_all cm,

Line 536: okl_txl_ar_inv_lns_b til,

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,
540: ra_customer_trx_all cm,

Line 570: okl_txl_ar_inv_lns_b til,

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,
574: okl_strm_type_b sty,

Line 604: okl_txl_ar_inv_lns_b til,

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,
608: ar_cash_receipts_all cra,

Line 632: okl_txl_ar_inv_lns_b til,

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,
636: ra_customer_trx_all cm,

Line 660: okl_txl_ar_inv_lns_b til,

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,
664: okl_strm_type_b sty