DBA Data[Home] [Help]

APPS.OKL_VERSION_PVT dependencies on OKC_LINE_STYLES_B

Line 73: okc_line_styles_b lse2,

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

Line 74: okc_line_styles_b lse1,

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

Line 298: okc_line_styles_b lse3,

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

Line 299: okc_line_styles_b lse2,

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

Line 300: okc_line_styles_b lse1,

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

Line 315: okc_line_styles_b lse2,

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

Line 316: okc_line_styles_b lse1,

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