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 88: from okc_line_styles_b addon_lseb,

84: ------------------------------------------------------
85: cursor l_new_addon_csr(p_rbk_chr_id in NUMBER,
86: p_orig_chr_id in NUMBER) is
87: select clet.name
88: from okc_line_styles_b addon_lseb,
89: okc_k_lines_b addon_cleb,
90: okc_line_styles_b model_lseb,
91: okc_k_lines_b model_cleb,
92: okc_k_lines_tl clet,

Line 90: okc_line_styles_b model_lseb,

86: p_orig_chr_id in NUMBER) is
87: select clet.name
88: from okc_line_styles_b addon_lseb,
89: okc_k_lines_b addon_cleb,
90: okc_line_styles_b model_lseb,
91: okc_k_lines_b model_cleb,
92: okc_k_lines_tl clet,
93: okc_line_styles_b lseb,
94: okc_k_lines_b cleb

Line 93: okc_line_styles_b lseb,

89: okc_k_lines_b addon_cleb,
90: okc_line_styles_b model_lseb,
91: okc_k_lines_b model_cleb,
92: okc_k_lines_tl clet,
93: okc_line_styles_b lseb,
94: okc_k_lines_b cleb
95: where
96: addon_cleb.cle_id = model_cleb.id
97: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id

Line 138: from okc_line_styles_b addon_lseb,

134: --------------------------------------------------------------
135: cursor l_new_addon_csr2(p_rbk_chr_id in NUMBER,
136: p_orig_chr_id in NUMBER) is
137: select clet.name
138: from okc_line_styles_b addon_lseb,
139: okc_k_lines_b addon_cleb,
140: okc_line_styles_b model_lseb,
141: okc_k_lines_b model_cleb,
142: okc_k_lines_tl clet,

Line 140: okc_line_styles_b model_lseb,

136: p_orig_chr_id in NUMBER) is
137: select clet.name
138: from okc_line_styles_b addon_lseb,
139: okc_k_lines_b addon_cleb,
140: okc_line_styles_b model_lseb,
141: okc_k_lines_b model_cleb,
142: okc_k_lines_tl clet,
143: okc_line_styles_b lseb,
144: okc_k_lines_b cleb

Line 143: okc_line_styles_b lseb,

139: okc_k_lines_b addon_cleb,
140: okc_line_styles_b model_lseb,
141: okc_k_lines_b model_cleb,
142: okc_k_lines_tl clet,
143: okc_line_styles_b lseb,
144: okc_k_lines_b cleb
145: where
146: addon_cleb.cle_id = model_cleb.id
147: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id

Line 187: okc_line_styles_b addon_lseb,

183: cursor l_addon_modfn_csr (p_rbk_chr_id in NUMBER,
184: p_orig_chr_id in NUMBER) is
185: select clet.name
186: from okc_k_items cim,
187: okc_line_styles_b addon_lseb,
188: okc_k_lines_b addon_cleb,
189: okc_line_styles_b model_lseb,
190: okc_k_lines_b model_cleb,
191: okc_k_lines_tl clet,

Line 189: okc_line_styles_b model_lseb,

185: select clet.name
186: from okc_k_items cim,
187: okc_line_styles_b addon_lseb,
188: okc_k_lines_b addon_cleb,
189: okc_line_styles_b model_lseb,
190: okc_k_lines_b model_cleb,
191: okc_k_lines_tl clet,
192: okc_line_styles_b lseb,
193: okc_k_lines_b cleb

Line 192: okc_line_styles_b lseb,

188: okc_k_lines_b addon_cleb,
189: okc_line_styles_b model_lseb,
190: okc_k_lines_b model_cleb,
191: okc_k_lines_tl clet,
192: okc_line_styles_b lseb,
193: okc_k_lines_b cleb
194: where cim.cle_id = addon_cleb.id
195: and cim.dnz_chr_id = addon_cleb.dnz_chr_id
196: and addon_cleb.cle_id = model_cleb.id

Line 244: from okc_line_styles_b addon_lseb,

240: ------------------------------------------------------
241: Cursor l_deleted_addon_csr (p_rbk_chr_id in NUMBER,
242: p_orig_chr_id in NUMBER) is
243: select clet.name
244: from okc_line_styles_b addon_lseb,
245: okc_k_lines_b addon_cleb,
246: okc_line_styles_b model_lseb,
247: okc_k_lines_b model_cleb,
248: okc_k_lines_tl clet,

Line 246: okc_line_styles_b model_lseb,

242: p_orig_chr_id in NUMBER) is
243: select clet.name
244: from okc_line_styles_b addon_lseb,
245: okc_k_lines_b addon_cleb,
246: okc_line_styles_b model_lseb,
247: okc_k_lines_b model_cleb,
248: okc_k_lines_tl clet,
249: okc_line_styles_b lseb,
250: okc_k_lines_b cleb

Line 249: okc_line_styles_b lseb,

245: okc_k_lines_b addon_cleb,
246: okc_line_styles_b model_lseb,
247: okc_k_lines_b model_cleb,
248: okc_k_lines_tl clet,
249: okc_line_styles_b lseb,
250: okc_k_lines_b cleb
251: where
252: addon_cleb.cle_id = model_cleb.id
253: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id

Line 295: okc_line_styles_b lseb

291: select clet.name
292: from okl_k_lines kle,
293: okc_k_lines_tl clet,
294: okc_k_lines_b cleb,
295: okc_line_styles_b lseb
296: where kle.id = cleb.id
297: and clet.id = cleb.id
298: and clet.language = userenv('LANG')
299: and cleb.chr_id = p_rbk_chr_id --rebook chr_id

Line 694: okc_line_styles_b rbk_lse,

690: p_item_lty_code VARCHAR2) IS
691: select rbk_cle.price_unit rbk_price_unit,
692: orig_cle.price_unit orig_price_unit
693: from okc_k_lines_b rbk_cle,
694: okc_line_styles_b rbk_lse,
695: okc_k_lines_b orig_cle
696: where rbk_cle.dnz_chr_id = p_rbk_chr_id
697: and rbk_lse.lty_code = p_item_lty_code
698: and rbk_cle.lse_id = rbk_lse.id

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

700: and orig_cle.dnz_chr_id = p_orig_chr_id;
701:
702: l_cle_rec cle_csr%rowtype;
703: l_chr_rec chr_csr%rowtype;
704: l_item_lty_code okc_line_styles_b.lty_code%type := 'ITEM';
705: BEGIN
706:
707: open chr_csr(p_rbk_chr_id);
708: fetch chr_csr into l_chr_rec;

Line 852: OKC_LINE_STYLES_B lse,

848: FROM okc_k_headers_b CHR
849: WHERE chr.ID = p_chr_id
850: AND exists (SELECT '1'
851: FROM
852: OKC_LINE_STYLES_B lse,
853: OKC_K_LINES_B cle
854: WHERE cle.sts_code = 'APPROVED'
855: AND lse.id = cle.lse_id
856: AND lse.lty_code = 'USAGE'

Line 893: OKC_LINE_STYLES_B lse_orig,

889: cle_orig.cle_id orig_finasst_id,
890: asr.id asset_return_id
891: FROM OKL_ASSET_RETURNS_B asr,
892: OKC_K_LINES_B cle_orig,
893: OKC_LINE_STYLES_B lse_orig,
894: OKC_K_ITEMS cim_orig,
895: OKC_K_ITEMS cim,
896: OKC_K_LINES_B cle,
897: OKC_LINE_STYLES_B lse,

Line 897: OKC_LINE_STYLES_B lse,

893: OKC_LINE_STYLES_B lse_orig,
894: OKC_K_ITEMS cim_orig,
895: OKC_K_ITEMS cim,
896: OKC_K_LINES_B cle,
897: OKC_LINE_STYLES_B lse,
898: OKC_STATUSES_B sts,
899: OKL_TXL_ASSETS_B txl
900: WHERE asr.kle_id = cle_orig.cle_id
901: AND asr.ars_code = 'RE_LEASE'

Line 968: okc_line_styles_b lseb_sub,

964: from okl_subsidies_b subb,
965: okl_k_lines kle_sub,
966: okc_k_lines_tl clet_sub,
967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,
969: okc_k_lines_tl clet_asst,
970: okc_k_lines_b cleb_asst,
971: okc_line_styles_b lseb_asst
972: where subb.id = kle_sub.subsidy_id

Line 971: okc_line_styles_b lseb_asst

967: okc_k_lines_b cleb_sub,
968: okc_line_styles_b lseb_sub,
969: okc_k_lines_tl clet_asst,
970: okc_k_lines_b cleb_asst,
971: okc_line_styles_b lseb_asst
972: where subb.id = kle_sub.subsidy_id
973: --and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate
974: and kle_sub.id = cleb_sub.id
975: and clet_sub.id = cleb_sub.id