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_K_LINES_B

Line 89: okc_k_lines_b addon_cleb,

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,
93: okc_line_styles_b lseb,

Line 91: okc_k_lines_b model_cleb,

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
95: where

Line 94: okc_k_lines_b 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
98: and addon_lseb.id = addon_cleb.lse_id

Line 115: from okc_k_lines_b addon_cleb2,

111: and lseb.lty_code = 'FREE_FORM1'
112: --to avoid picking up new asset added during rebook
113: and cleb.orig_system_id1 is not null
114: and exists (select '1'
115: from okc_k_lines_b addon_cleb2,
116: okc_k_lines_b model_cleb2,
117: okc_k_lines_b cleb2
118: where addon_cleb2.id <> nvl(addon_cleb.orig_system_id1,-999)
119: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)

Line 116: okc_k_lines_b model_cleb2,

112: --to avoid picking up new asset added during rebook
113: and cleb.orig_system_id1 is not null
114: and exists (select '1'
115: from okc_k_lines_b addon_cleb2,
116: okc_k_lines_b model_cleb2,
117: okc_k_lines_b cleb2
118: where addon_cleb2.id <> nvl(addon_cleb.orig_system_id1,-999)
119: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)
120: and cleb2.id = nvl(cleb.orig_system_id1,-999)

Line 117: okc_k_lines_b cleb2

113: and cleb.orig_system_id1 is not null
114: and exists (select '1'
115: from okc_k_lines_b addon_cleb2,
116: okc_k_lines_b model_cleb2,
117: okc_k_lines_b cleb2
118: where addon_cleb2.id <> nvl(addon_cleb.orig_system_id1,-999)
119: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)
120: and cleb2.id = nvl(cleb.orig_system_id1,-999)
121: and addon_cleb2.cle_id = model_cleb2.id

Line 139: okc_k_lines_b addon_cleb,

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,
143: okc_line_styles_b lseb,

Line 141: okc_k_lines_b model_cleb,

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
145: where

Line 144: okc_k_lines_b 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
148: and addon_lseb.id = addon_cleb.lse_id

Line 165: from okc_k_lines_b addon_cleb2,

161: and lseb.lty_code = 'FREE_FORM1'
162: --to avoid picking up new asset added during rebook
163: and cleb.orig_system_id1 is not null
164: and not exists (select '1'
165: from okc_k_lines_b addon_cleb2,
166: okc_k_lines_b model_cleb2,
167: okc_k_lines_b cleb2
168: where addon_cleb2.id = nvl(addon_cleb.orig_system_id1,-999)
169: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)

Line 166: okc_k_lines_b model_cleb2,

162: --to avoid picking up new asset added during rebook
163: and cleb.orig_system_id1 is not null
164: and not exists (select '1'
165: from okc_k_lines_b addon_cleb2,
166: okc_k_lines_b model_cleb2,
167: okc_k_lines_b cleb2
168: where addon_cleb2.id = nvl(addon_cleb.orig_system_id1,-999)
169: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)
170: and cleb2.id = nvl(cleb.orig_system_id1,-999)

Line 167: okc_k_lines_b cleb2

163: and cleb.orig_system_id1 is not null
164: and not exists (select '1'
165: from okc_k_lines_b addon_cleb2,
166: okc_k_lines_b model_cleb2,
167: okc_k_lines_b cleb2
168: where addon_cleb2.id = nvl(addon_cleb.orig_system_id1,-999)
169: and model_cleb2.id = nvl(model_cleb.orig_system_id1,-999)
170: and cleb2.id = nvl(cleb.orig_system_id1,-999)
171: and addon_cleb2.cle_id = model_cleb2.id

Line 188: okc_k_lines_b addon_cleb,

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,
192: okc_line_styles_b lseb,

Line 190: okc_k_lines_b model_cleb,

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
194: where cim.cle_id = addon_cleb.id

Line 193: okc_k_lines_b 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
197: and addon_cleb.dnz_chr_id = model_cleb.dnz_chr_id

Line 216: okc_k_lines_b addon_cleb2,

212: --to avoid picking up new asset added during rebook
213: and cleb.orig_system_id1 is not null
214: and exists (select '1'
215: from okc_k_items cim2,
216: okc_k_lines_b addon_cleb2,
217: okc_k_lines_b model_cleb2,
218: okc_k_lines_b cleb2
219: where cim2.cle_id = addon_cleb2.id
220: and cim2.dnz_chr_id = addon_cleb2.dnz_chr_id

Line 217: okc_k_lines_b model_cleb2,

213: and cleb.orig_system_id1 is not null
214: and exists (select '1'
215: from okc_k_items cim2,
216: okc_k_lines_b addon_cleb2,
217: okc_k_lines_b model_cleb2,
218: okc_k_lines_b cleb2
219: where cim2.cle_id = addon_cleb2.id
220: and cim2.dnz_chr_id = addon_cleb2.dnz_chr_id
221: and ( (cim2.object1_id1 <> cim.object1_id1)

Line 218: okc_k_lines_b cleb2

214: and exists (select '1'
215: from okc_k_items cim2,
216: okc_k_lines_b addon_cleb2,
217: okc_k_lines_b model_cleb2,
218: okc_k_lines_b cleb2
219: where cim2.cle_id = addon_cleb2.id
220: and cim2.dnz_chr_id = addon_cleb2.dnz_chr_id
221: and ( (cim2.object1_id1 <> cim.object1_id1)
222: OR

Line 245: okc_k_lines_b addon_cleb,

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,
249: okc_line_styles_b lseb,

Line 247: okc_k_lines_b model_cleb,

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
251: where

Line 250: okc_k_lines_b 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
254: and addon_lseb.id = addon_cleb.lse_id

Line 269: from okc_k_lines_b addon_cleb2,

265: and cleb.dnz_chr_id = p_orig_chr_id --orig contract
266: and lseb.id = cleb.lse_id
267: and lseb.lty_code = 'FREE_FORM1'
268: and not exists (select '1'
269: from okc_k_lines_b addon_cleb2,
270: okc_k_lines_b model_cleb2,
271: okc_k_lines_b cleb2
272: where nvl(addon_cleb2.orig_system_id1,-999) = addon_cleb.id
273: and nvl(model_cleb2.orig_system_id1,-999) = model_cleb.id

Line 270: okc_k_lines_b model_cleb2,

266: and lseb.id = cleb.lse_id
267: and lseb.lty_code = 'FREE_FORM1'
268: and not exists (select '1'
269: from okc_k_lines_b addon_cleb2,
270: okc_k_lines_b model_cleb2,
271: okc_k_lines_b cleb2
272: where nvl(addon_cleb2.orig_system_id1,-999) = addon_cleb.id
273: and nvl(model_cleb2.orig_system_id1,-999) = model_cleb.id
274: --and nvl(cleb2.orig_system_id1,-999) = cleb2.id

Line 271: okc_k_lines_b cleb2

267: and lseb.lty_code = 'FREE_FORM1'
268: and not exists (select '1'
269: from okc_k_lines_b addon_cleb2,
270: okc_k_lines_b model_cleb2,
271: okc_k_lines_b cleb2
272: where nvl(addon_cleb2.orig_system_id1,-999) = addon_cleb.id
273: and nvl(model_cleb2.orig_system_id1,-999) = model_cleb.id
274: --and nvl(cleb2.orig_system_id1,-999) = cleb2.id
275: and nvl(cleb2.orig_system_id1,-999) = cleb.id

Line 294: okc_k_lines_b cleb,

290: p_orig_chr_id in NUMBER) is
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')

Line 307: okc_k_lines_b cleb2

303: --to avoid picking up new asset during rebook
304: and cleb.orig_system_id1 is not null
305: and exists (select '1'
306: from okl_k_lines kle2,
307: okc_k_lines_b cleb2
308: where kle2.id = cleb2.id
309: and cleb2.id = nvl(cleb.orig_system_id1,-999)
310: and (
311: -- Bug# 4721428: allow updates to trade-in

Line 487: from okc_k_lines_b cleb

483:
484: --cursor to fetch contract line level BTO and CAN
485: cursor l_cleb_csr (chrId In Number) is
486: Select cleb.bill_to_site_use_id
487: from okc_k_lines_b cleb
488: where cleb.dnz_chr_id = ChrId
489: and cleb.sts_code <> 'ABANDONED'
490: and cleb.bill_to_site_use_id is not null;
491:

Line 693: from okc_k_lines_b rbk_cle,

689: p_orig_chr_id NUMBER,
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

Line 695: okc_k_lines_b orig_cle

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
699: and orig_cle.id = rbk_cle.orig_system_id1

Line 853: OKC_K_LINES_B cle

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'
857: AND cle.dnz_chr_id = chr.id);

Line 892: OKC_K_LINES_B cle_orig,

888: cim.object1_id1 asset_id,
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,

Line 896: OKC_K_LINES_B cle,

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,
898: OKC_STATUSES_B sts,
899: OKL_TXL_ASSETS_B txl
900: WHERE asr.kle_id = cle_orig.cle_id

Line 967: okc_k_lines_b cleb_sub,

963: ,subb.effective_from_date effective_from_date -- added : Bug 6050165 : prasjain
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

Line 970: okc_k_lines_b cleb_asst,

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
973: --and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate
974: and kle_sub.id = cleb_sub.id

Line 999: okc_k_lines_b cleb

995: cursor l_cle_csr (p_subsidy_id in number,
996: p_asset_cle_id in number) is
997: Select 'Y'
998: from okl_subsidies_b sub,
999: okc_k_lines_b cleb
1000: where sub.id = p_subsidy_id
1001: and cleb.id = p_asset_cle_id
1002: and TRUNC(cleb.start_date) between TRUNC(sub.effective_from_date)
1003: and TRUNC(nvl(sub.effective_to_date,cleb.start_date));