13: FROM okl_cnsld_ar_hdrs_v a
14: WHERE EXISTS (SELECT 1 FROM
15: (SELECT x.id
16: FROM okl_cnsld_ar_hdrs_v x,
17: okl_cnsld_ar_lines_v y,
18: okl_cnsld_ar_strms_v z
19: WHERE x.trx_status_code like 'PROCESSED%' AND
20: x.id = y.cnr_id AND
21: y.id = z.lln_id AND
31: nvl(amount, 0) + nvl(tax_amount, 0) amount,
32: ilt_id,
33: khr_id,
34: kle_id
35: FROM okl_cnsld_ar_lines_v
36: WHERE cnr_id = p_cnr_id;
37:
38: CURSOR invoice_line_type(p_ilt_id NUMBER) IS
39: SELECT name