DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 434: ra_customer_trx_lines_all ractrl,

430: p_due_date DATE) IS
431: SELECT cra.receipt_date receipt_date
432: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount --4884843, 4872370
433: FROM okl_txd_ar_ln_dtls_b tld,
434: ra_customer_trx_lines_all ractrl,
435: okl_txl_ar_inv_lns_b til,
436: okl_trx_ar_invoices_b tai,
437: ar_payment_schedules_all aps,
438: ar_receivable_applications_all raa,

Line 466: ra_customer_trx_lines_all ractrl,

462: UNION ALL
463: SELECT cra.receipt_date receipt_date
464: ,SUM(raa.line_applied) receipt_amount --4884843, 4872370
465: FROM okl_txd_ar_ln_dtls_b tld,
466: ra_customer_trx_lines_all ractrl,
467: okl_txl_ar_inv_lns_b til,
468: okl_trx_ar_invoices_b tai,
469: ar_payment_schedules_all aps,
470: ar_receivable_applications_all raa,

Line 504: ra_customer_trx_lines_all ractrl,

500: p_due_date DATE) IS
501: SELECT cra.receipt_date receipt_date
502: ,SUM(line_applied) receipt_amount --4884843, 4872370
503: FROM okl_txd_ar_ln_dtls_b tld,
504: ra_customer_trx_lines_all ractrl,
505: okl_txl_ar_inv_lns_b til,
506: okl_trx_ar_invoices_b tai,
507: ar_payment_schedules_all aps,
508: ar_receivable_applications_all raa,