DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_LINES_TL

Line 3922: okc_k_lines_tl tl,

3918: tl.item_description,
3919: tl.name
3920: FROM okl_k_lines_full_v kle,
3921: okc_line_styles_b lse,
3922: okc_k_lines_tl tl,
3923: okc_statuses_b sts
3924: WHERE kle.lse_id = lse.id
3925: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
3926: AND tl.id = kle.id

Line 8665: okc_k_lines_tl tl,

8661: tl.item_description,
8662: tl.name
8663: from okl_k_lines_full_v kle,
8664: okc_line_styles_b lse,
8665: okc_k_lines_tl tl,
8666: okc_statuses_b sts
8667: where KLE.LSE_ID = LSE.ID
8668: and lse.lty_code = lnetype
8669: and tl.id = kle.id

Line 9456: okc_k_lines_tl tl,

9452: kle.capital_reduction,
9453: kle.capitalize_down_payment_yn
9454: FROM okl_k_lines_full_v kle,
9455: okc_line_styles_b lse,
9456: okc_k_lines_tl tl,
9457: okc_statuses_b sts
9458: WHERE kle.lse_id = lse.id
9459: AND lse.lty_code = 'LINK_FEE_ASSET'
9460: AND tl.id = kle.id

Line 17639: okc_k_lines_tl tl,

17635: kle.capital_reduction,
17636: kle.capitalize_down_payment_yn
17637: FROM okl_k_lines_full_v kle,
17638: okc_line_styles_b lse,
17639: okc_k_lines_tl tl,
17640: okc_statuses_b sts
17641: WHERE kle.lse_id = lse.id
17642: AND lse.lty_code = lnetype
17643: AND tl.id = kle.id

Line 21954: okc_k_lines_tl tl,

21950: tl.item_description,
21951: tl.name
21952: FROM okl_k_lines_full_v kle,
21953: okc_line_styles_b lse,
21954: okc_k_lines_tl tl,
21955: okc_statuses_b sts
21956: WHERE kle.lse_id = lse.id
21957: AND lse.lty_code = lnetype
21958: AND tl.id = kle.id

Line 21989: okc_k_lines_tl tl,

21985: tl.item_description,
21986: tl.name
21987: FROM okl_k_lines_full_v kle,
21988: okc_line_styles_b lse,
21989: okc_k_lines_tl tl,
21990: okc_statuses_b sts
21991: WHERE kle.lse_id = lse.id
21992: AND lse.lty_code = 'SO_PAYMENT'
21993: AND kle.id = p_cle_id