DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on OKC_K_LINES_TL

Line 5021: okc_k_lines_tl tl,

5017: tl.item_description,
5018: tl.name
5019: FROM okl_k_lines_full_v kle,
5020: okc_line_styles_b lse,
5021: okc_k_lines_tl tl,
5022: okc_statuses_b sts
5023: WHERE kle.lse_id = lse.id
5024: AND lse.lty_code in ( 'FREE_FORM1', 'FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET')--bug# 3343133 (ssiruvol)
5025: AND tl.id = kle.id

Line 10187: okc_k_lines_tl tl,

10183: tl.name ,
10184: kle.orig_contract_line_id --sechawla 15-jul-09 PRB ESG Enhancements : added orig_contract_line_id
10185: from okl_k_lines_full_v kle,
10186: okc_line_styles_b lse,
10187: okc_k_lines_tl tl,
10188: okc_statuses_b sts
10189: where KLE.LSE_ID = LSE.ID
10190: and lse.lty_code = lnetype
10191: and tl.id = kle.id

Line 11042: okc_k_lines_tl tl,

11038: kle.capitalize_down_payment_yn,
11039: kle.orig_contract_line_id --sechawla 15-jul-09 ESG PRB Enhancements : added orig_contract_line_id
11040: FROM okl_k_lines_full_v kle,
11041: okc_line_styles_b lse,
11042: okc_k_lines_tl tl,
11043: okc_statuses_b sts
11044: WHERE kle.lse_id = lse.id
11045: AND lse.lty_code = 'LINK_FEE_ASSET'
11046: AND tl.id = kle.id

Line 20277: okc_k_lines_tl tl,

20273: kle.orig_contract_line_id, --sechawla 10-jul-09 PRB ESG enhancements : added
20274: kle.capital_reduction_percent
20275: FROM okl_k_lines_full_v kle,
20276: okc_line_styles_b lse,
20277: okc_k_lines_tl tl,
20278: okc_statuses_b sts
20279: WHERE kle.lse_id = lse.id
20280: AND lse.lty_code = lnetype
20281: AND tl.id = kle.id

Line 24797: okc_k_lines_tl tl,

24793: tl.item_description,
24794: tl.name
24795: FROM okl_k_lines_full_v kle,
24796: okc_line_styles_b lse,
24797: okc_k_lines_tl tl,
24798: okc_statuses_b sts
24799: WHERE kle.lse_id = lse.id
24800: AND lse.lty_code = lnetype
24801: AND tl.id = kle.id

Line 24832: okc_k_lines_tl tl,

24828: tl.item_description,
24829: tl.name
24830: FROM okl_k_lines_full_v kle,
24831: okc_line_styles_b lse,
24832: okc_k_lines_tl tl,
24833: okc_statuses_b sts
24834: WHERE kle.lse_id = lse.id
24835: AND lse.lty_code = 'SO_PAYMENT'
24836: AND kle.id = p_cle_id