DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 435: okl_txl_ar_inv_lns_b til,

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

Line 467: okl_txl_ar_inv_lns_b til,

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

Line 505: okl_txl_ar_inv_lns_b til,

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