DBA Data[Home] [Help]

APPS.OKL_DAILY_INTEREST_CALC_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 444: ar_distributions_all ad

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

Line 493: FROM ar_distributions_all ad

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

Line 510: ar_distributions_all ad

506: ar_payment_schedules_all aps,
507: ar_receivable_applications_all raa,
508: ra_customer_trx_all cm,
509: okl_strm_type_b sty_ln_pmt,
510: ar_distributions_all ad
511: WHERE tai.trx_status_code = 'PROCESSED'
512: AND tai.khr_id = p_contract_id
513: AND tld.khr_id = p_contract_id
514: AND ractrl.customer_trx_id = aps.customer_trx_id

Line 559: FROM ar_distributions_all ad

555: AND to_char(tld.id) = ractrl.interface_line_attribute14
556: AND tld.til_id_details = til.id
557: AND til.tai_id = tai.id
558: AND EXISTS (SELECT 1
559: FROM ar_distributions_all ad
560: WHERE raa.receivable_application_id = ad.source_id
561: AND ad.source_table = 'RA'
562: AND ad.source_type = 'REC'
563: AND ad.ref_customer_trx_Line_Id IS NULL)

Line 575: ar_distributions_all ad

571: okl_trx_ar_invoices_b tai,
572: ar_payment_schedules_all aps,
573: ar_adjustments_all adj,
574: okl_strm_type_b sty,
575: ar_distributions_all ad
576: WHERE tai.trx_status_code = 'PROCESSED'
577: AND tai.khr_id = p_contract_id
578: AND tld.khr_id = p_contract_id
579: AND ractrl.customer_trx_id = aps.customer_trx_id