3216: l.copies_required,
3217: l.cdrl_category,
3218: l.data_item_name,
3219: l.export_flag
3220: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3221: where h.id = p_id
3222: and l.header_id = p_id
3223: and h.id = k.k_header_id
3224: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)
3260: l.copies_required,
3261: l.cdrl_category,
3262: l.data_item_name,
3263: l.export_flag
3264: from oke_k_lines_v l, okc_k_headers_b h, oke_k_headers k
3265: where h.id = p_id
3266: and l.header_id = p_id
3267: and h.id = k.k_header_id
3268: and not exists (select 'x' from okc_k_lines_b s where s.cle_id = l.k_line_id)