DBA Data[Home] [Help]

APPS.OKL_CO_WF dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1460: ,ar_payment_schedules_all aps

1456: SELECT sum(nvl(aps.amount_due_remaining, 0)) past_due_amount
1457: FROM iex_cases_all_b ica
1458: ,iex_case_objects ico
1459: ,okl_cnsld_ar_strms_b ocas
1460: ,ar_payment_schedules_all aps
1461: WHERE ica.case_number = cp_case_number
1462: AND ica.cas_id = ico.cas_id
1463: AND ico.object_id = ocas.khr_id
1464: AND ocas.receivables_invoice_id = aps.customer_trx_id