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

Line 92: FROM OKC_LINE_STYLES_B lse,

88: CURSOR l_chk_usage_csr (p_chr_id IN Number) IS
89: SELECT '!'
90: FROM dual
91: where exists (SELECT 1
92: FROM OKC_LINE_STYLES_B lse,
93: OKC_K_LINES_B cle,
94: okc_statuses_b sts
95: WHERE lse.id = cle.lse_id
96: AND lse.lty_code = 'USAGE'

Line 226: FROM okc_line_styles_b lse,

222: -- linked to any asset
223:
224: CURSOR non_linked_usage_csr (p_chr_id NUMBER) IS
225: SELECT cle.id usage_line_id
226: FROM okc_line_styles_b lse,
227: okc_k_lines_b cle,
228: okc_statuses_v okcsts
229: WHERE cle.dnz_chr_id = p_chr_id
230: AND cle.lse_id = lse.id

Line 238: okc_line_styles_b lse,

234: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED')
235: AND NOT EXISTS (
236: SELECT 1
237: FROM okc_k_lines_b line,
238: okc_line_styles_b lse,
239: okc_statuses_b sts
240: WHERE line.dnz_chr_id = p_chr_id
241: AND line.cle_id = cle.id
242: AND line.lse_id = lse.id

Line 251: FROM okc_line_styles_b lse,

247:
248:
249: CURSOR usage_csr (p_chr_id NUMBER) IS
250: SELECT cle.id usage_line_id
251: FROM okc_line_styles_b lse,
252: okc_k_lines_b cle,okc_statuses_v okcsts
253: WHERE cle.dnz_chr_id = p_chr_id
254: AND cle.lse_id = lse.id
255: AND lse.lse_parent_id is null

Line 265: okc_line_styles_b lse,

261: CURSOR link_asset_csr (p_chr_id NUMBER,
262: p_usage_line_id NUMBER) IS
263: SELECT line.id
264: FROM okc_k_lines_b line,
265: okc_line_styles_b lse,
266: okc_statuses_b okcsts
267: WHERE line.dnz_chr_id = p_chr_id
268: AND line.cle_id = p_usage_line_id
269: AND line.lse_id = lse.id

Line 1077: okc_line_styles_b lse,

1073:
1074: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1075: SELECT cle.id top_line
1076: FROM okc_subclass_top_line stl,
1077: okc_line_styles_b lse,
1078: okc_k_lines_b cle
1079: WHERE cle.dnz_chr_id = p_dnz_chr_id
1080: AND cle.lse_id = lse.id
1081: AND lse.lty_code = G_FIN_LINE_LTY_CODE

Line 1300: okc_line_styles_b lse,

1296:
1297: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1298: SELECT cle.id top_line
1299: FROM okc_subclass_top_line stl,
1300: okc_line_styles_b lse,
1301: okc_k_lines_b cle
1302: WHERE cle.dnz_chr_id = p_dnz_chr_id
1303: AND cle.lse_id = lse.id
1304: AND lse.lty_code = G_FIN_LINE_LTY_CODE

Line 1313: okc_line_styles_b lse2,

1309:
1310: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1311: SELECT av.asset_number asset_number
1312: FROM okc_subclass_top_line stl,
1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,
1315: okx_assets_v av,
1316: okc_k_items cim,
1317: okc_k_lines_b cle

Line 1314: okc_line_styles_b lse1,

1310: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1311: SELECT av.asset_number asset_number
1312: FROM okc_subclass_top_line stl,
1313: okc_line_styles_b lse2,
1314: okc_line_styles_b lse1,
1315: okx_assets_v av,
1316: okc_k_items cim,
1317: okc_k_lines_b cle
1318: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 1857: okc_line_styles_b lse,

1853: tcl.source_value_2,
1854: tcl.source_column_3,
1855: tcl.source_value_3
1856: FROM okc_k_lines_v cle,
1857: okc_line_styles_b lse,
1858: okl_txl_cntrct_lns tcl
1859: WHERE cle.chr_id = p_chr_id
1860: AND cle.dnz_chr_id = p_chr_id
1861: AND lse.lty_code = 'FREE_FORM1'

Line 2324: okc_line_styles_b fin_ast_lse,

2320: SELECT fin_ast_cle.id,
2321: fin_ast_cle.name
2322: FROM okc_k_lines_v fin_ast_cle,
2323: okc_k_headers_b chr,
2324: okc_line_styles_b fin_ast_lse,
2325: okl_trx_quotes_b qte,
2326: okl_txl_quote_lines_b tql
2327: WHERE chr.id = p_orig_chr_id
2328: AND fin_ast_cle.chr_id = chr.id

Line 2367: okc_line_styles_b fin_ast_lse,

2363: SELECT fin_ast_cle.id,
2364: fin_ast_cle.name
2365: FROM okc_k_lines_v fin_ast_cle,
2366: okc_k_headers_b chr,
2367: okc_line_styles_b fin_ast_lse,
2368: okl_trx_assets ota,
2369: okl_txl_assets_b otl
2370: WHERE chr.id = p_orig_chr_id
2371: AND fin_ast_cle.chr_id = chr.id

Line 3245: okc_line_styles_b lse

3241: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3242: IS
3243: SELECT 'Y'
3244: FROM okc_k_lines_b cle,
3245: okc_line_styles_b lse
3246: WHERE cle.chr_id = p_chr_id
3247: AND cle.dnz_chr_id = p_chr_id
3248: AND lse.id = cle.lse_id
3249: AND lse.lty_code = 'USAGE'

Line 3277: okc_line_styles_b fin_ast_lse

3273: SELECT fin_ast_cle.id,
3274: fin_ast_cle.name
3275: FROM okc_k_lines_v fin_ast_cle,
3276: okc_k_headers_b chr,
3277: okc_line_styles_b fin_ast_lse
3278: WHERE chr.id = p_orig_chr_id
3279: AND fin_ast_cle.chr_id = chr.id
3280: AND fin_ast_cle.dnz_chr_id = chr.id
3281: AND fin_ast_cle.sts_code = chr.sts_code

Line 4159: okc_line_styles_b lse,

4155: sts.ste_code,
4156: cle.orig_system_id1
4157: FROM okc_k_lines_b cle,
4158: okl_k_lines kle,
4159: okc_line_styles_b lse,
4160: okc_statuses_b sts
4161: WHERE cle.dnz_chr_id = p_chr_id
4162: AND cle.chr_id = p_chr_id
4163: AND kle.id = cle.id

Line 5679: okc_line_styles_b lse,

5675: cle.orig_system_id1,
5676: sts.ste_code
5677: FROM okc_k_lines_b cle,
5678: okl_k_lines kle,
5679: okc_line_styles_b lse,
5680: okc_statuses_b sts
5681: WHERE cle.dnz_chr_id = p_chr_id
5682: AND cle.chr_id = p_chr_id
5683: AND kle.id = cle.id

Line 6362: okc_line_styles_b lse,

6358: IS
6359: SELECT cle.id,
6360: kle.amount
6361: FROM okc_k_lines_b cle,
6362: okc_line_styles_b lse,
6363: okl_k_lines kle
6364: WHERE cle.chr_id = p_chr_id
6365: AND cle.dnz_chr_id = p_chr_id
6366: AND lse.lty_code IN ('FEE','SOLD_SERVICE')

Line 6890: okc_line_styles_b lse,

6886: cle.start_date,
6887: sts.ste_code,
6888: cle.orig_system_id1
6889: FROM okc_k_lines_b cle,
6890: okc_line_styles_b lse,
6891: okc_statuses_b sts
6892: WHERE cle.dnz_chr_id = p_chr_id
6893: AND cle.chr_id = p_chr_id
6894: AND cle.lse_id = lse.id

Line 6923: FROM okc_line_styles_b

6919: START WITH id = p_cle_id;
6920:
6921: CURSOR lse_csr(p_lse_id IN NUMBER) IS
6922: SELECT lty_code
6923: FROM okc_line_styles_b
6924: WHERE id = p_lse_id;
6925:
6926: lse_rec lse_csr%ROWTYPE;
6927:

Line 6960: okc_line_styles_b fa_lseb

6956: txlb.id
6957: FROM okl_txl_assets_b txlb,
6958: okl_trx_assets trx,
6959: okc_k_lines_b fa_cleb,
6960: okc_line_styles_b fa_lseb
6961: WHERE txlb.kle_id = fa_cleb.id
6962: AND txlb.tal_type = 'CRL'
6963: AND trx.id = txlb.tas_id
6964: AND trx.tsu_code <> 'PROCESSED'

Line 7573: okc_line_styles_b lse,

7569: tcl.source_value_2,
7570: tcl.source_column_3,
7571: tcl.source_value_3
7572: FROM okc_k_lines_b cle,
7573: okc_line_styles_b lse,
7574: okl_txl_cntrct_lns tcl
7575: WHERE cle.chr_id = p_chr_id
7576: AND cle.dnz_chr_id = p_chr_id
7577: AND lse.lty_code = 'FREE_FORM1'

Line 7595: okc_line_styles_b fa_lseb

7591: SELECT txlb.id
7592: FROM okl_txl_assets_b txlb,
7593: okl_trx_assets trx,
7594: okc_k_lines_b fa_cleb,
7595: okc_line_styles_b fa_lseb
7596: WHERE txlb.kle_id = fa_cleb.id
7597: AND txlb.tal_type = 'CRL'
7598: AND trx.id = txlb.tas_id
7599: AND trx.tsu_code <> 'PROCESSED'

Line 7620: okc_line_styles_b lseb_ib,

7616: iti.jtot_object_code_new
7617: FROM okl_trx_assets trx,
7618: okl_txl_itm_insts iti,
7619: okc_k_lines_b cleb_ib,
7620: okc_line_styles_b lseb_ib,
7621: okc_k_lines_b cleb_inst,
7622: okc_line_styles_b lseb_inst
7623: WHERE trx.id = iti.tas_id
7624: AND trx.tsu_code <> 'PROCESSED'

Line 7622: okc_line_styles_b lseb_inst

7618: okl_txl_itm_insts iti,
7619: okc_k_lines_b cleb_ib,
7620: okc_line_styles_b lseb_ib,
7621: okc_k_lines_b cleb_inst,
7622: okc_line_styles_b lseb_inst
7623: WHERE trx.id = iti.tas_id
7624: AND trx.tsu_code <> 'PROCESSED'
7625: AND trx.tas_type = 'CRL'
7626: AND iti.kle_id = cleb_ib.id

Line 8230: okc_line_styles_b lse

8226: p_source_trx_id IN NUMBER)
8227: IS
8228: SELECT cle.id
8229: FROM okc_k_lines_b cle,
8230: okc_line_styles_b lse
8231: WHERE cle.chr_id = p_new_chr_id
8232: AND cle.dnz_chr_id = p_new_chr_id
8233: AND lse.lty_code = 'FREE_FORM1'
8234: AND cle.lse_id = lse.id

Line 8245: okc_line_styles_b lse

8241: CURSOR taa_fee_serv_csr(p_new_chr_id IN NUMBER)
8242: IS
8243: SELECT cle.id
8244: FROM okc_k_lines_b cle,
8245: okc_line_styles_b lse
8246: WHERE cle.chr_id = p_new_chr_id
8247: AND cle.dnz_chr_id = p_new_chr_id
8248: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
8249: AND cle.lse_id = lse.id

Line 8746: OKC_LINE_STYLES_B lse

8742: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8743: SELECT cle.orig_system_id1 orig_cle_fa,
8744: cle.id id
8745: FROM OKC_K_LINES_B cle,
8746: OKC_LINE_STYLES_B lse
8747: WHERE cle.dnz_chr_id = p_chr_id
8748: AND cle.lse_id = lse.id
8749: AND lse.lty_code = 'FIXED_ASSET';
8750:

Line 8756: OKC_LINE_STYLES_B lse

8752: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8753: SELECT cle.orig_system_id1 orig_cle_ib,
8754: cle.id id
8755: FROM OKC_K_LINES_B cle,
8756: OKC_LINE_STYLES_B lse
8757: WHERE cle.dnz_chr_id = p_chr_id
8758: AND cle.lse_id = lse.id
8759: AND lse.lty_code = 'INST_ITEM';
8760:

Line 8777: OKC_LINE_STYLES_B lse_orig,

8773: cle_orig.cle_id orig_finasst_id,
8774: asr.id asset_return_id
8775: FROM OKL_ASSET_RETURNS_B asr,
8776: OKC_K_LINES_B cle_orig,
8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,

Line 8781: OKC_LINE_STYLES_B lse,

8777: OKC_LINE_STYLES_B lse_orig,
8778: OKC_K_ITEMS cim_orig,
8779: OKC_K_ITEMS cim,
8780: OKC_K_LINES_B cle,
8781: OKC_LINE_STYLES_B lse,
8782: OKC_STATUSES_B sts,
8783: OKL_TXL_ASSETS_B txl
8784: WHERE asr.kle_id = cle_orig.cle_id
8785: AND asr.ars_code = 'RELEASE_IN_PROCESS'