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_AM_CREATE_QUOTE_PVT dependencies on OKC_K_LINES_B

Line 287: okc_k_lines_b cle_fin,

283: AND stl.LANGUAGE = userenv('LANG')
284: AND chr.id IN (SELECT DISTINCT cle_fin.dnz_chr_id chr_id
285: FROM okc_line_styles_b lse_fin,
286: okc_k_lines_tl clet_fin,
287: okc_k_lines_b cle_fin,
288: okc_k_headers_b chr
289: WHERE cle_fin.cle_id IS NULL
290: AND cle_fin.chr_id = cle_fin.dnz_chr_id
291: AND cle_fin.dnz_chr_id = chr.id

Line 352: okc_k_lines_b cle_ib,

348: AND chr.id IN (SELECT DISTINCT cim_ib.dnz_chr_id chr_id
349: FROM csi_item_instances csi,
350: okc_k_items cim_ib,
351: okc_line_styles_b lse_ib,
352: okc_k_lines_b cle_ib,
353: okc_k_headers_b chr
354: WHERE cle_ib.lse_id = lse_ib.id
355: AND lse_ib.lty_code = 'INST_ITEM'
356: AND cim_ib.cle_id = cle_ib.id

Line 418: okc_k_lines_b cle_ib,

414: AND chr.id IN (SELECT DISTINCT cle_fin.dnz_chr_id chr_id
415: FROM csi_item_instances csi,
416: okc_k_items cim_ib,
417: okc_line_styles_b lse_ib,
418: okc_k_lines_b cle_ib,
419: okc_line_styles_b lse_inst,
420: okc_k_lines_b cle_inst,
421: okc_line_styles_b lse_fin,
422: okc_k_lines_tl clet_fin,

Line 420: okc_k_lines_b cle_inst,

416: okc_k_items cim_ib,
417: okc_line_styles_b lse_ib,
418: okc_k_lines_b cle_ib,
419: okc_line_styles_b lse_inst,
420: okc_k_lines_b cle_inst,
421: okc_line_styles_b lse_fin,
422: okc_k_lines_tl clet_fin,
423: okc_k_lines_b cle_fin,
424: okc_k_headers_b chr

Line 423: okc_k_lines_b cle_fin,

419: okc_line_styles_b lse_inst,
420: okc_k_lines_b cle_inst,
421: okc_line_styles_b lse_fin,
422: okc_k_lines_tl clet_fin,
423: okc_k_lines_b cle_fin,
424: okc_k_headers_b chr
425: WHERE cle_fin.cle_id IS NULL
426: AND cle_fin.chr_id = cle_fin.dnz_chr_id
427: AND cle_fin.dnz_chr_id = chr.id

Line 1537: FROM OKC_K_LINES_B KLE,

1533: -- RMUNJULU -- 11-DEC-02 Bug # 2484327 -- Changed cursor to also check for
1534: -- sts_code of line match with sts_code of contract
1535: CURSOR l_clines_csr (p_kle_id NUMBER ) IS
1536: SELECT KLE.chr_id, KLE.start_date -- rmunjulu EDAT
1537: FROM OKC_K_LINES_B KLE,
1538: OKC_K_HEADERS_B KHR
1539: WHERE KLE.id = p_kle_id
1540: AND KLE.chr_id = KHR.id
1541: AND KLE.sts_code = KHR.sts_code;

Line 1560: okc_k_lines_b oks_cov_pd_cleb,

1556: FROM dual WHERE EXISTS (
1557: SELECT '1'
1558: FROM okc_k_headers_b oks_chrb,
1559: okc_line_styles_b oks_cov_pd_lse,
1560: okc_k_lines_b oks_cov_pd_cleb,
1561: okc_k_rel_objs krel,
1562: okc_line_styles_b lnk_srv_lse,
1563: okc_statuses_b lnk_srv_sts,
1564: okc_k_lines_b lnk_srv_cleb,

Line 1564: okc_k_lines_b lnk_srv_cleb,

1560: okc_k_lines_b oks_cov_pd_cleb,
1561: okc_k_rel_objs krel,
1562: okc_line_styles_b lnk_srv_lse,
1563: okc_statuses_b lnk_srv_sts,
1564: okc_k_lines_b lnk_srv_cleb,
1565: okc_k_items lnk_srv_cim
1566: WHERE oks_chrb.scs_code = 'SERVICE'
1567: AND oks_chrb.id = oks_cov_pd_cleb.dnz_chr_id
1568: AND oks_cov_pd_cleb.lse_id = oks_cov_pd_lse.id