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_ACTIVATE_CONTRACT_PUB dependencies on OKC_LINE_STYLES_B

Line 95: from okc_line_styles_b addon_lseb,

91: ------------------------------------------------------
92: Cursor l_deleted_addon_csr (p_rbk_chr_id in NUMBER,
93: p_orig_chr_id in NUMBER) is
94: select clet.name
95: from okc_line_styles_b addon_lseb,
96: okc_k_lines_b addon_cleb,
97: okc_line_styles_b model_lseb,
98: okc_k_lines_b model_cleb,
99: okc_k_lines_tl clet,

Line 97: okc_line_styles_b model_lseb,

93: p_orig_chr_id in NUMBER) is
94: select clet.name
95: from okc_line_styles_b addon_lseb,
96: okc_k_lines_b addon_cleb,
97: okc_line_styles_b model_lseb,
98: okc_k_lines_b model_cleb,
99: okc_k_lines_tl clet,
100: okc_line_styles_b lseb,
101: okc_k_lines_b cleb

Line 100: okc_line_styles_b lseb,

96: okc_k_lines_b addon_cleb,
97: okc_line_styles_b model_lseb,
98: okc_k_lines_b model_cleb,
99: okc_k_lines_tl clet,
100: okc_line_styles_b lseb,
101: okc_k_lines_b cleb
102: where
103: addon_cleb.cle_id = model_cleb.id
104: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id

Line 412: okc_line_styles_b rbk_lse,

408: p_item_lty_code VARCHAR2) IS
409: select rbk_cle.price_unit rbk_price_unit,
410: orig_cle.price_unit orig_price_unit
411: from okc_k_lines_b rbk_cle,
412: okc_line_styles_b rbk_lse,
413: okc_k_lines_b orig_cle
414: where rbk_cle.dnz_chr_id = p_rbk_chr_id
415: and rbk_lse.lty_code = p_item_lty_code
416: and rbk_cle.lse_id = rbk_lse.id

Line 422: l_item_lty_code okc_line_styles_b.lty_code%type := 'ITEM';

418: and orig_cle.dnz_chr_id = p_orig_chr_id;
419:
420: l_cle_rec cle_csr%rowtype;
421: l_chr_rec chr_csr%rowtype;
422: l_item_lty_code okc_line_styles_b.lty_code%type := 'ITEM';
423: BEGIN
424:
425: open chr_csr(p_rbk_chr_id);
426: fetch chr_csr into l_chr_rec;

Line 570: OKC_LINE_STYLES_B lse,

566: FROM okc_k_headers_b CHR
567: WHERE chr.ID = p_chr_id
568: AND exists (SELECT '1'
569: FROM
570: OKC_LINE_STYLES_B lse,
571: OKC_K_LINES_B cle
572: WHERE cle.sts_code = 'APPROVED'
573: AND lse.id = cle.lse_id
574: AND lse.lty_code = 'USAGE'

Line 663: OKC_LINE_STYLES_B lse_orig,

659: cle_orig.cle_id orig_finasst_id,
660: asr.id asset_return_id
661: FROM OKL_ASSET_RETURNS_B asr,
662: OKC_K_LINES_B cle_orig,
663: OKC_LINE_STYLES_B lse_orig,
664: OKC_K_ITEMS cim_orig,
665: OKC_K_ITEMS cim,
666: OKC_K_LINES_B cle,
667: OKC_LINE_STYLES_B lse,

Line 667: OKC_LINE_STYLES_B lse,

663: OKC_LINE_STYLES_B lse_orig,
664: OKC_K_ITEMS cim_orig,
665: OKC_K_ITEMS cim,
666: OKC_K_LINES_B cle,
667: OKC_LINE_STYLES_B lse,
668: OKC_STATUSES_B sts,
669: OKL_TXL_ASSETS_B txl
670: WHERE asr.kle_id = cle_orig.cle_id
671: AND asr.ars_code = 'RE_LEASE'

Line 738: okc_line_styles_b lseb_sub,

734: from okl_subsidies_b subb,
735: okl_k_lines kle_sub,
736: okc_k_lines_tl clet_sub,
737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,
739: okc_k_lines_tl clet_asst,
740: okc_k_lines_b cleb_asst,
741: okc_line_styles_b lseb_asst
742: where subb.id = kle_sub.subsidy_id

Line 741: okc_line_styles_b lseb_asst

737: okc_k_lines_b cleb_sub,
738: okc_line_styles_b lseb_sub,
739: okc_k_lines_tl clet_asst,
740: okc_k_lines_b cleb_asst,
741: okc_line_styles_b lseb_asst
742: where subb.id = kle_sub.subsidy_id
743: --and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate
744: and kle_sub.id = cleb_sub.id
745: and clet_sub.id = cleb_sub.id