9821: AND pod.line_location_id = pos.line_location_id
9822: AND pod.oke_contract_line_id IS NOT NULL
9823: AND NVL(pol.cancel_flag,'N') = 'N' --
9824: AND pod.oke_contract_line_id NOT IN (SELECT id
9825: FROM okc_k_lines_b
9826: WHERE dnz_chr_id = pol.oke_contract_header_id
9827: --
9828: -- Look for contract lines in oke_deliverables_b also (DTS flow)
9829: UNION