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_LINE_STYLES_B

Line 58: okc_line_styles_b lse

54: -- by excluding UPPER function to do Index scan
55: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS
56: SELECT 'Y' a
57: FROM okc_k_lines_v kle,
58: okc_line_styles_b lse
59: WHERE kle.lse_id = lse.id
60: AND lse.lty_code = 'FREE_FORM1'
61: AND UPPER(kle.NAME) = p_asset_number -- RMUNJULU 3241502
62: AND ( kle.NAME like Initcap(substr(p_asset_number,1,2))||'%'

Line 285: FROM okc_line_styles_b lse_fin,

281: AND hp.party_type IN ( 'PERSON','ORGANIZATION')
282: AND chr.sts_code = stl.code
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

Line 351: okc_line_styles_b lse_ib,

347: AND stl.LANGUAGE = userenv('LANG')
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'

Line 417: okc_line_styles_b lse_ib,

413: AND stl.LANGUAGE = userenv('LANG')
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,

Line 419: okc_line_styles_b lse_inst,

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,
423: okc_k_lines_b cle_fin,

Line 421: okc_line_styles_b lse_fin,

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
425: WHERE cle_fin.cle_id IS NULL

Line 1560: okc_line_styles_b oks_cov_pd_lse,

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

Line 1563: okc_line_styles_b lnk_srv_lse,

1559: FROM okc_k_headers_b oks_chrb,
1560: okc_line_styles_b oks_cov_pd_lse,
1561: okc_k_lines_b oks_cov_pd_cleb,
1562: okc_k_rel_objs krel,
1563: okc_line_styles_b lnk_srv_lse,
1564: okc_statuses_b lnk_srv_sts,
1565: okc_k_lines_b lnk_srv_cleb,
1566: okc_k_items lnk_srv_cim
1567: WHERE oks_chrb.scs_code = 'SERVICE'