69: cle.dnz_chr_id,
70: cim.object1_id1,
71: cim.object1_id2
72: FROM okc_subclass_top_line stl,
73: okc_line_styles_b lse2,
74: okc_line_styles_b lse1,
75: okc_k_items_v cim,
76: okc_k_lines_v cle
77: WHERE cle.dnz_chr_id = p_dnz_chr_id
70: cim.object1_id1,
71: cim.object1_id2
72: FROM okc_subclass_top_line stl,
73: okc_line_styles_b lse2,
74: okc_line_styles_b lse1,
75: okc_k_items_v cim,
76: okc_k_lines_v cle
77: WHERE cle.dnz_chr_id = p_dnz_chr_id
78: AND cle.id = cim.cle_id
294: cle.dnz_chr_id,
295: cim.object1_id1,
296: cim.object1_id2
297: FROM okc_subclass_top_line stl,
298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,
302: okc_k_lines_b cle
295: cim.object1_id1,
296: cim.object1_id2
297: FROM okc_subclass_top_line stl,
298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,
302: okc_k_lines_b cle
303: WHERE cle.lse_id = lse1.id
296: cim.object1_id2
297: FROM okc_subclass_top_line stl,
298: okc_line_styles_b lse3,
299: okc_line_styles_b lse2,
300: okc_line_styles_b lse1,
301: okc_k_items_v cim,
302: okc_k_lines_b cle
303: WHERE cle.lse_id = lse1.id
304: AND cle.id = cim.cle_id
311: AND lse3.id = stl.lse_id
312: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
313: AND cle.cle_id in (SELECT cle.id
314: FROM okc_subclass_top_line stl,
315: okc_line_styles_b lse2,
316: okc_line_styles_b lse1,
317: okc_k_lines_b cle
318: WHERE cle.dnz_chr_id = p_dnz_chr_id
319: AND cle.lse_id = lse1.id
312: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
313: AND cle.cle_id in (SELECT cle.id
314: FROM okc_subclass_top_line stl,
315: okc_line_styles_b lse2,
316: okc_line_styles_b lse1,
317: okc_k_lines_b cle
318: WHERE cle.dnz_chr_id = p_dnz_chr_id
319: AND cle.lse_id = lse1.id
320: AND lse1.lty_code = G_INST_LINE_LTY_CODE