eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_CNSLD_AR_HDRS_B

Line 2727: from okl_cnsld_ar_hdrs_b

2723: ----------------------------------------------------------
2724: CURSOR c_overdue_hdr(c_khr_id NUMBER)
2725: IS
2726: select consolidated_invoice_number,id
2727: from okl_cnsld_ar_hdrs_b
2728: where id in
2729: (select distinct(cnr_id)
2730: from okl_cnsld_ar_lines_b
2731: where id in

Line 2751: okl_cnsld_ar_hdrs_b a,

2747: select trunc(sysdate) - trunc(d.due_date) days,
2748: sum(amount_due_remaining) total_amount,
2749: c.khr_id
2750: from
2751: okl_cnsld_ar_hdrs_b a,
2752: okl_cnsld_ar_lines_b b,
2753: okl_cnsld_ar_strms_b c,
2754: ar_payment_schedules_all d
2755: where