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 1063: okc_line_styles_b lse,

1059:
1060: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1061: SELECT cle.id top_line
1062: FROM okc_subclass_top_line stl,
1063: okc_line_styles_b lse,
1064: okc_k_lines_b cle
1065: WHERE cle.dnz_chr_id = p_dnz_chr_id
1066: AND cle.lse_id = lse.id
1067: AND lse.lty_code = G_FIN_LINE_LTY_CODE

Line 1279: okc_line_styles_b lse,

1275:
1276: CURSOR c_get_old_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1277: SELECT cle.id top_line
1278: FROM okc_subclass_top_line stl,
1279: okc_line_styles_b lse,
1280: okc_k_lines_b cle
1281: WHERE cle.dnz_chr_id = p_dnz_chr_id
1282: AND cle.lse_id = lse.id
1283: AND lse.lty_code = G_FIN_LINE_LTY_CODE

Line 1292: okc_line_styles_b lse2,

1288:
1289: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1290: SELECT av.asset_number asset_number
1291: FROM okc_subclass_top_line stl,
1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,
1294: okx_assets_v av,
1295: okc_k_items cim,
1296: okc_k_lines_b cle

Line 1293: okc_line_styles_b lse1,

1289: CURSOR c_get_old_k_asset(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1290: SELECT av.asset_number asset_number
1291: FROM okc_subclass_top_line stl,
1292: okc_line_styles_b lse2,
1293: okc_line_styles_b lse1,
1294: okx_assets_v av,
1295: okc_k_items cim,
1296: okc_k_lines_b cle
1297: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 1836: okc_line_styles_b lse,

1832: tcl.source_value_2,
1833: tcl.source_column_3,
1834: tcl.source_value_3
1835: FROM okc_k_lines_v cle,
1836: okc_line_styles_b lse,
1837: okl_txl_cntrct_lns tcl
1838: WHERE cle.chr_id = p_chr_id
1839: AND cle.dnz_chr_id = p_chr_id
1840: AND lse.lty_code = 'FREE_FORM1'

Line 2300: okc_line_styles_b fin_ast_lse,

2296: SELECT fin_ast_cle.id,
2297: fin_ast_cle.name
2298: FROM okc_k_lines_v fin_ast_cle,
2299: okc_k_headers_b chr,
2300: okc_line_styles_b fin_ast_lse,
2301: okl_trx_quotes_b qte,
2302: okl_txl_quote_lines_b tql
2303: WHERE chr.id = p_orig_chr_id
2304: AND fin_ast_cle.chr_id = chr.id

Line 2343: okc_line_styles_b fin_ast_lse,

2339: SELECT fin_ast_cle.id,
2340: fin_ast_cle.name
2341: FROM okc_k_lines_v fin_ast_cle,
2342: okc_k_headers_b chr,
2343: okc_line_styles_b fin_ast_lse,
2344: okl_trx_assets ota,
2345: okl_txl_assets_b otl
2346: WHERE chr.id = p_orig_chr_id
2347: AND fin_ast_cle.chr_id = chr.id

Line 3191: okc_line_styles_b lse

3187: CURSOR chk_usage_csr(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
3188: IS
3189: SELECT 'Y'
3190: FROM okc_k_lines_b cle,
3191: okc_line_styles_b lse
3192: WHERE cle.chr_id = p_chr_id
3193: AND cle.dnz_chr_id = p_chr_id
3194: AND lse.id = cle.lse_id
3195: AND lse.lty_code = 'USAGE'

Line 3223: okc_line_styles_b fin_ast_lse

3219: SELECT fin_ast_cle.id,
3220: fin_ast_cle.name
3221: FROM okc_k_lines_v fin_ast_cle,
3222: okc_k_headers_b chr,
3223: okc_line_styles_b fin_ast_lse
3224: WHERE chr.id = p_orig_chr_id
3225: AND fin_ast_cle.chr_id = chr.id
3226: AND fin_ast_cle.dnz_chr_id = chr.id
3227: AND fin_ast_cle.sts_code = chr.sts_code

Line 4099: okc_line_styles_b lse,

4095: sts.ste_code,
4096: cle.orig_system_id1
4097: FROM okc_k_lines_b cle,
4098: okl_k_lines kle,
4099: okc_line_styles_b lse,
4100: okc_statuses_b sts
4101: WHERE cle.dnz_chr_id = p_chr_id
4102: AND cle.chr_id = p_chr_id
4103: AND kle.id = cle.id

Line 5370: okc_line_styles_b lse,

5366: cle.orig_system_id1,
5367: sts.ste_code
5368: FROM okc_k_lines_b cle,
5369: okl_k_lines kle,
5370: okc_line_styles_b lse,
5371: okc_statuses_b sts
5372: WHERE cle.dnz_chr_id = p_chr_id
5373: AND cle.chr_id = p_chr_id
5374: AND kle.id = cle.id

Line 6053: okc_line_styles_b lse,

6049: IS
6050: SELECT cle.id,
6051: kle.amount
6052: FROM okc_k_lines_b cle,
6053: okc_line_styles_b lse,
6054: okl_k_lines kle
6055: WHERE cle.chr_id = p_chr_id
6056: AND cle.dnz_chr_id = p_chr_id
6057: AND lse.lty_code IN ('FEE','SOLD_SERVICE')

Line 6581: okc_line_styles_b lse,

6577: cle.start_date,
6578: sts.ste_code,
6579: cle.orig_system_id1
6580: FROM okc_k_lines_b cle,
6581: okc_line_styles_b lse,
6582: okc_statuses_b sts
6583: WHERE cle.dnz_chr_id = p_chr_id
6584: AND cle.chr_id = p_chr_id
6585: AND cle.lse_id = lse.id

Line 6614: FROM okc_line_styles_b

6610: START WITH id = p_cle_id;
6611:
6612: CURSOR lse_csr(p_lse_id IN NUMBER) IS
6613: SELECT lty_code
6614: FROM okc_line_styles_b
6615: WHERE id = p_lse_id;
6616:
6617: lse_rec lse_csr%ROWTYPE;
6618:

Line 6651: okc_line_styles_b fa_lseb

6647: txlb.id
6648: FROM okl_txl_assets_b txlb,
6649: okl_trx_assets trx,
6650: okc_k_lines_b fa_cleb,
6651: okc_line_styles_b fa_lseb
6652: WHERE txlb.kle_id = fa_cleb.id
6653: AND txlb.tal_type = 'CRL'
6654: AND trx.id = txlb.tas_id
6655: AND trx.tsu_code <> 'PROCESSED'

Line 7253: okc_line_styles_b lse,

7249: tcl.source_value_2,
7250: tcl.source_column_3,
7251: tcl.source_value_3
7252: FROM okc_k_lines_b cle,
7253: okc_line_styles_b lse,
7254: okl_txl_cntrct_lns tcl
7255: WHERE cle.chr_id = p_chr_id
7256: AND cle.dnz_chr_id = p_chr_id
7257: AND lse.lty_code = 'FREE_FORM1'

Line 7275: okc_line_styles_b fa_lseb

7271: SELECT txlb.id
7272: FROM okl_txl_assets_b txlb,
7273: okl_trx_assets trx,
7274: okc_k_lines_b fa_cleb,
7275: okc_line_styles_b fa_lseb
7276: WHERE txlb.kle_id = fa_cleb.id
7277: AND txlb.tal_type = 'CRL'
7278: AND trx.id = txlb.tas_id
7279: AND trx.tsu_code <> 'PROCESSED'

Line 7300: okc_line_styles_b lseb_ib,

7296: iti.jtot_object_code_new
7297: FROM okl_trx_assets trx,
7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,
7302: okc_line_styles_b lseb_inst
7303: WHERE trx.id = iti.tas_id
7304: AND trx.tsu_code <> 'PROCESSED'

Line 7302: okc_line_styles_b lseb_inst

7298: okl_txl_itm_insts iti,
7299: okc_k_lines_b cleb_ib,
7300: okc_line_styles_b lseb_ib,
7301: okc_k_lines_b cleb_inst,
7302: okc_line_styles_b lseb_inst
7303: WHERE trx.id = iti.tas_id
7304: AND trx.tsu_code <> 'PROCESSED'
7305: AND trx.tas_type = 'CRL'
7306: AND iti.kle_id = cleb_ib.id

Line 7906: okc_line_styles_b lse

7902: p_source_trx_id IN NUMBER)
7903: IS
7904: SELECT cle.id
7905: FROM okc_k_lines_b cle,
7906: okc_line_styles_b lse
7907: WHERE cle.chr_id = p_new_chr_id
7908: AND cle.dnz_chr_id = p_new_chr_id
7909: AND lse.lty_code = 'FREE_FORM1'
7910: AND cle.lse_id = lse.id

Line 7921: okc_line_styles_b lse

7917: CURSOR taa_fee_serv_csr(p_new_chr_id IN NUMBER)
7918: IS
7919: SELECT cle.id
7920: FROM okc_k_lines_b cle,
7921: okc_line_styles_b lse
7922: WHERE cle.chr_id = p_new_chr_id
7923: AND cle.dnz_chr_id = p_new_chr_id
7924: AND lse.lty_code IN ('FEE','SOLD_SERVICE')
7925: AND cle.lse_id = lse.id

Line 8417: OKC_LINE_STYLES_B lse

8413: CURSOR get_orig_fa(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8414: SELECT cle.orig_system_id1 orig_cle_fa,
8415: cle.id id
8416: FROM OKC_K_LINES_B cle,
8417: OKC_LINE_STYLES_B lse
8418: WHERE cle.dnz_chr_id = p_chr_id
8419: AND cle.lse_id = lse.id
8420: AND lse.lty_code = 'FIXED_ASSET';
8421:

Line 8427: OKC_LINE_STYLES_B lse

8423: CURSOR get_orig_ib(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
8424: SELECT cle.orig_system_id1 orig_cle_ib,
8425: cle.id id
8426: FROM OKC_K_LINES_B cle,
8427: OKC_LINE_STYLES_B lse
8428: WHERE cle.dnz_chr_id = p_chr_id
8429: AND cle.lse_id = lse.id
8430: AND lse.lty_code = 'INST_ITEM';
8431:

Line 8448: OKC_LINE_STYLES_B lse_orig,

8444: cle_orig.cle_id orig_finasst_id,
8445: asr.id asset_return_id
8446: FROM OKL_ASSET_RETURNS_B asr,
8447: OKC_K_LINES_B cle_orig,
8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,

Line 8452: OKC_LINE_STYLES_B lse,

8448: OKC_LINE_STYLES_B lse_orig,
8449: OKC_K_ITEMS cim_orig,
8450: OKC_K_ITEMS cim,
8451: OKC_K_LINES_B cle,
8452: OKC_LINE_STYLES_B lse,
8453: OKC_STATUSES_B sts,
8454: OKL_TXL_ASSETS_B txl
8455: WHERE asr.kle_id = cle_orig.cle_id
8456: AND asr.ars_code = 'RELEASE_IN_PROCESS'