eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_STREAM_PVT dependencies on OKL_K_LINES_FULL_V

Line 305: FROM okl_k_lines_full_v kle,

301: kle.date_funding_expected,
302: -- Added by RGOOTY: ESG Down Payment
303: kle.capital_reduction,
304: kle.capitalize_down_payment_yn
305: FROM okl_k_lines_full_v kle,
306: okc_line_styles_b lse,
307: okc_k_lines_tl tl,
308: okc_statuses_b sts
309: WHERE kle.lse_id = lse.id

Line 331: FROM okl_k_lines_full_v kle,

327: kle.amount,
328: kle.price_negotiated,
329: kle.start_date,
330: kle.capital_amount
331: FROM okl_k_lines_full_v kle,
332: okc_line_styles_b LS,
333: okc_k_items cim
334: WHERE ls.id = kle.lse_id
335: AND ls.lty_code = lnetype

Line 351: okl_k_lines_full_v kle,

347: sty.stream_type_class stream_type_class
348: FROM okl_strm_type_tl tl,
349: okl_strm_type_v sty,
350: okc_k_items cim,
351: okl_k_lines_full_v kle,
352: okc_line_styles_b ls
353: WHERE tl.id = sty.id
354: AND tl.language = 'US'
355: AND cim.cle_id = kle.id

Line 451: FROM okl_k_lines_full_v kle,

447: AND NVL(str.purpose_code,'ORIGIN') = pp
448: AND str.khr_id = chrId
449: AND (NVL( str.kle_id, -1) = -1 OR
450: str.kle_id IN (SELECT kle.id
451: FROM okl_k_lines_full_v kle,
452: okc_line_styles_b lse,
453: okc_statuses_b sts
454: WHERE KLE.LSE_ID = LSE.ID
455: AND kle.dnz_chr_id = chrId

Line 474: FROM okl_k_lines_full_v kle,

470: --Cursor to fetch the OEC of all assets put together in the Contract
471: CURSOR total_oec_csr(p_chr_id NUMBER)
472: IS
473: SELECT sum(kle.oec) total_oec
474: FROM okl_k_lines_full_v kle,
475: okc_line_styles_b lse,
476: okc_k_lines_tl tl,
477: okc_statuses_b sts
478: WHERE kle.lse_id = lse.id