APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_LINES_FULL_V

Line 309: FROM okl_k_lines_full_v kle,

305: kle.capital_reduction,
306: kle.capitalize_down_payment_yn,
307: kle.orig_contract_line_id, --sechawla 10-jul-09 PRB ESg enhancements : added
308: kle.capital_reduction_percent
309: FROM okl_k_lines_full_v kle,
310: okc_line_styles_b lse,
311: okc_k_lines_tl tl,
312: okc_statuses_b sts
313: WHERE kle.lse_id = lse.id

Line 335: FROM okl_k_lines_full_v kle,

331: kle.amount,
332: kle.price_negotiated,
333: kle.start_date,
334: kle.capital_amount
335: FROM okl_k_lines_full_v kle,
336: okc_line_styles_b LS,
337: okc_k_items cim
338: WHERE ls.id = kle.lse_id
339: AND ls.lty_code = lnetype

Line 355: okl_k_lines_full_v kle,

351: sty.stream_type_class stream_type_class
352: FROM okl_strm_type_tl tl,
353: okl_strm_type_v sty,
354: okc_k_items cim,
355: okl_k_lines_full_v kle,
356: okc_line_styles_b ls
357: WHERE tl.id = sty.id
358: AND tl.language = 'US'
359: AND cim.cle_id = kle.id

Line 379: okl_k_lines_full_v kle,

375: sty.stream_type_class stream_type_class
376: FROM okl_strm_type_tl tl,
377: okl_strm_type_v sty,
378: okl_party_payment_hdr pph,
379: okl_k_lines_full_v kle,
380: okc_line_styles_b ls
381: WHERE tl.id = sty.id
382: AND tl.language = 'US'
383: AND ls.id = kle.lse_id

Line 522: FROM okl_k_lines_full_v kle,

518: --Cursor to fetch the OEC of all assets put together in the Contract
519: CURSOR total_oec_csr(p_chr_id NUMBER)
520: IS
521: SELECT sum(kle.oec) total_oec
522: FROM okl_k_lines_full_v kle,
523: okc_line_styles_b lse,
524: okc_k_lines_tl tl,
525: okc_statuses_b sts
526: WHERE kle.lse_id = lse.id