DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_CNSLD_AR_HDRS_B

Line 2736: from okl_cnsld_ar_hdrs_b

2732: ----------------------------------------------------------
2733: CURSOR c_overdue_hdr(c_khr_id NUMBER)
2734: IS
2735: select consolidated_invoice_number,id
2736: from okl_cnsld_ar_hdrs_b
2737: where id in
2738: (select distinct(cnr_id)
2739: from okl_cnsld_ar_lines_b
2740: where id in

Line 2760: okl_cnsld_ar_hdrs_b a,

2756: select trunc(sysdate) - trunc(d.due_date) days,
2757: sum(amount_due_remaining) total_amount,
2758: c.khr_id
2759: from
2760: okl_cnsld_ar_hdrs_b a,
2761: okl_cnsld_ar_lines_b b,
2762: okl_cnsld_ar_strms_b c,
2763: ar_payment_schedules_all d
2764: where