DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 441: ar_distributions_all ad

437: ar_payment_schedules_all aps,
438: ar_receivable_applications_all raa,
439: ar_cash_receipts_all cra,
440: okl_strm_type_b sty_ln_pmt,
441: ar_distributions_all ad
442: WHERE tai.trx_status_code = 'PROCESSED'
443: AND tai.khr_id = p_contract_id
444: AND tld.khr_id = p_contract_id
445: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 490: FROM ar_distributions_all ad

486: AND to_char(tld.id) = ractrl.interface_line_attribute14
487: AND tld.til_id_details = til.id
488: AND til.tai_id = tai.id
489: AND EXISTS (SELECT 1
490: FROM ar_distributions_all ad
491: WHERE raa.receivable_application_id = ad.source_id
492: AND ad.source_table = 'RA'
493: AND ad.source_type = 'REC'
494: AND ad.ref_customer_trx_Line_Id IS NULL)