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 OKC_LINE_STYLES_B

Line 310: okc_line_styles_b lse,

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
314: AND lse.lty_code = lnetype

Line 336: okc_line_styles_b LS,

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
340: AND cim.jtot_object1_code = obcode

Line 356: okc_line_styles_b ls

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
360: AND ls.id = kle.lse_id

Line 380: okc_line_styles_b ls

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
384: AND ls.lty_code = 'SOLD_SERVICE'

Line 413: okc_line_styles_b lse_ib,

409: FROM hz_locations hl,
410: hz_party_sites hps,
411: hz_party_site_uses hpsu,
412: okl_txl_itm_insts iti,
413: okc_line_styles_b lse_ib,
414: okc_k_lines_b cle_ib
415: WHERE cle_ib.dnz_chr_id = chrId
416: AND cle_ib.lse_id = lse_ib.id
417: AND lse_ib.lty_code = 'INST_ITEM'

Line 484: OKC_LINE_STYLES_B LSE,

480: AND (
481: STR.KLE_ID IN
482: (SELECT /*+ index(KLE OKC_K_LINES_B_U1 )*/ KLE.ID
483: FROM OKC_K_LINES_B KLE,
484: OKC_LINE_STYLES_B LSE,
485: OKC_STATUSES_B STS
486: WHERE KLE.LSE_ID = LSE.ID
487: AND KLE.DNZ_CHR_ID = chrId
488: AND STS.CODE = KLE.STS_CODE

Line 523: okc_line_styles_b lse,

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
527: AND lse.lty_code = 'FREE_FORM1'