APPS.OKL_PRINT_CONS_BILL dependencies on OKL_CNSLD_AR_HDRS_V

Line 13: FROM okl_cnsld_ar_hdrs_v a

9: ) IS
10:
11: CURSOR cons_hdr IS
12: SELECT a.*
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,

Line 16: FROM okl_cnsld_ar_hdrs_v x,

12: SELECT a.*
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