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

Line 41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';

37: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';

Line 42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';

38: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';
46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';

Line 43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';

39: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';
46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';
47:

Line 44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';

40: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';
46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';
47:
48: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

Line 45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';

41: G_SER_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'SOLD_SERVICE';
42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';
46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';
47:
48: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
49: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

Line 46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';

42: G_SRL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_SERV_ASSET';
43: G_FEE_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'FEE';
44: G_FEL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_FEE_ASSET';
45: G_USG_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'USAGE';
46: G_USL_LINE_LTY_CODE OKC_LINE_STYLES_B.LTY_CODE%TYPE := 'LINK_USAGE_ASSET';
47:
48: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
49: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
50: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

Line 1583: FROM okc_line_styles_b lse,

1579: WHERE khr_id = p_khr_id;
1580:
1581: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1582: SELECT cle.id top_line
1583: FROM okc_line_styles_b lse,
1584: okc_k_lines_b cle
1585: WHERE cle.dnz_chr_id = p_dnz_chr_id
1586: AND cle.cle_id IS NULL
1587: AND cle.chr_id = cle.dnz_chr_id

Line 2112: okc_line_styles_b lse

2108: IS
2109: SELECT cle.id id
2110: FROM okl_k_lines_v kle,
2111: okc_k_lines_v cle,
2112: okc_line_styles_b lse
2113: WHERE cle.dnz_chr_id = p_chr_id
2114: AND cle.id = kle.id
2115: AND cle.lse_id = lse.id
2116: AND lse.lty_code IN (G_FEE_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)

Line 2122: okc_line_styles_b lse_sl

2118: AND cle.cle_id IS NULL
2119: AND cle.id NOT IN (SELECT DISTINCT(cle_sl.cle_id) cle_id
2120: FROM okl_k_lines_v kle_sl,
2121: okc_k_lines_v cle_sl,
2122: okc_line_styles_b lse_sl
2123: WHERE cle_sl.dnz_chr_id = p_chr_id
2124: AND cle_sl.id = kle_sl.id
2125: AND cle_sl.lse_id = lse_sl.id
2126: AND lse_sl.lty_code IN (G_FEL_LINE_LTY_CODE, G_SRL_LINE_LTY_CODE));

Line 2252: OKC_LINE_STYLES_b lse

2248: SELECT '1'
2249: FROM DUAL
2250: WHERE EXISTS (SELECT '1'
2251: FROM OKC_K_LINES_B cle,
2252: OKC_LINE_STYLES_b lse
2253: WHERE cle.dnz_chr_id = p_chr_id
2254: AND lse.id = cle.lse_id
2255: AND lse.lty_code IN (G_SER_LINE_LTY_CODE,
2256: G_SRL_LINE_LTY_CODE,

Line 2272: okc_line_styles_b lse

2268: /*CURSOR get_asset_info(p_chr_id OKC_K_HEADERS_B.ID%TYPE)
2269: IS
2270: SELECT sum(cle.capital_amount) total_capital_amount
2271: FROM okl_k_lines_full_v cle,
2272: okc_line_styles_b lse
2273: WHERE cle.dnz_chr_id = p_chr_id
2274: AND cle.lse_id = lse.id
2275: AND lse.lty_code = G_FIN_LINE_LTY_CODE
2276: AND lse.lse_type = G_TLS_TYPE;*/

Line 2285: okc_line_styles_b lse

2281: IS
2282: select tcle.id id
2283: from okc_k_items tcim,
2284: okc_k_lines_b tcle,
2285: okc_line_styles_b lse
2286: where tcim.dnz_chr_id = p_dnz_chr_id
2287: and tcle.lse_id = lse.id
2288: and tcim.cle_id = tcle.id
2289: and tcim.dnz_chr_id = tcle.dnz_chr_id

Line 2301: okc_line_styles_b lse

2297: and cim.jtot_object1_code = 'OKX_COVASST'
2298: and not exists
2299: (select 1
2300: from okc_k_lines_b cle,
2301: okc_line_styles_b lse
2302: where cle.dnz_chr_id = p_dnz_chr_id
2303: and cle.lse_id = lse.id
2304: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2305: and lse.lse_type = G_TLS_TYPE

Line 2310: okc_line_styles_b lse

2306: and cle.id = cim.object1_id1))
2307: and not exists
2308: (select 1
2309: from okc_k_lines_b cle,
2310: okc_line_styles_b lse
2311: where cle.dnz_chr_id = p_dnz_chr_id
2312: and cle.lse_id = lse.id
2313: and lse.lty_code in (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2314: and lse.lse_type = G_TLS_TYPE

Line 2335: okc_line_styles_b lse

2331: AND cle.id = cim.cle_id
2332: AND cim.jtot_object1_code = 'OKX_COVASST'
2333: AND cim.object1_id1 NOT IN (SELECT cle.id
2334: FROM okc_k_lines_b cle,
2335: okc_line_styles_b lse
2336: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2337: AND cle.lse_id = lse.id
2338: AND lse.lty_code IN (G_FIN_LINE_LTY_CODE, G_SER_LINE_LTY_CODE)
2339: AND lse.lse_type = G_TLS_TYPE);

Line 2354: okc_line_styles_b lse

2350: AND cim.dnz_chr_id = cle.dnz_chr_id
2351: AND cim.jtot_object1_code = 'OKX_COVASST'
2352: AND cim.object1_id1 not in (SELECT cle.id
2353: FROM okc_k_lines_b cle,
2354: okc_line_styles_b lse
2355: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2356: AND cle.lse_id = lse.id
2357: AND lse.lty_code = G_FIN_LINE_LTY_CODE
2358: AND lse.lse_type = G_TLS_TYPE);

Line 2368: okc_line_styles_b lse

2364: WHERE cim.dnz_chr_id = p_dnz_chr_Id
2365: AND cim.jtot_object1_code = 'OKX_COVASST'
2366: AND cim.object1_id1 not in (SELECT cle.id
2367: FROM okc_k_lines_b cle,
2368: okc_line_styles_b lse
2369: WHERE cle.dnz_chr_id = p_dnz_chr_Id
2370: AND cle.lse_id = lse.id
2371: AND lse.lty_code = G_FIN_LINE_LTY_CODE
2372: AND lse.lse_type = G_TLS_TYPE);*/

Line 2383: okc_line_styles_b lse

2379: nvl(kle.initial_direct_cost,0) initial_direct_cost,
2380: cle.id id
2381: FROM okl_k_lines_v kle,
2382: okc_k_lines_v cle,
2383: okc_line_styles_b lse
2384: WHERE cle.dnz_chr_id = p_chr_id
2385: AND cle.id = kle.id
2386: AND cle.lse_id = lse.id
2387: AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)

Line 2400: okc_line_styles_b lse_sl,

2396: NVL(kle.amount,0) amount,
2397: NVL(kle.initial_direct_cost,0) initial_direct_cost
2398: FROM okl_k_lines_v kle_sl,
2399: okc_k_lines_v cle_sl,
2400: okc_line_styles_b lse_sl,
2401: okl_k_lines_v kle,
2402: okc_k_lines_v cle,
2403: okc_line_styles_b lse
2404: WHERE cle.dnz_chr_id = p_chr_id

Line 2403: okc_line_styles_b lse

2399: okc_k_lines_v cle_sl,
2400: okc_line_styles_b lse_sl,
2401: okl_k_lines_v kle,
2402: okc_k_lines_v cle,
2403: okc_line_styles_b lse
2404: WHERE cle.dnz_chr_id = p_chr_id
2405: AND cle.id = kle.id
2406: AND cle.lse_id = lse.id
2407: AND lse.lty_code IN (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)

Line 2421: okc_line_styles_b lse,

2417: CURSOR get_cap_link_asset_amount(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE)
2418: IS
2419: SELECT SUM(kle.CAPITAL_AMOUNT)
2420: FROM okl_k_lines_v kle,
2421: okc_line_styles_b lse,
2422: okc_k_lines_v cle
2423: WHERE cle.cle_id = p_cle_id
2424: AND cle.id = kle.id
2425: AND cle.lse_id = lse.id

Line 2436: okc_line_styles_b lse_sl,

2432: cle.id id,
2433: cle.orig_system_id1 orig_system_id1
2434: FROM okl_k_lines_v kle_sl,
2435: okc_k_lines_v cle_sl,
2436: okc_line_styles_b lse_sl,
2437: okl_k_lines_v kle,
2438: okc_k_lines_v cle,
2439: okc_line_styles_b lse
2440: WHERE cle.dnz_chr_id = p_chr_id

Line 2439: okc_line_styles_b lse

2435: okc_k_lines_v cle_sl,
2436: okc_line_styles_b lse_sl,
2437: okl_k_lines_v kle,
2438: okc_k_lines_v cle,
2439: okc_line_styles_b lse
2440: WHERE cle.dnz_chr_id = p_chr_id
2441: AND cle.id = kle.id
2442: AND cle.lse_id = lse.id
2443: AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)

Line 2462: okc_line_styles_b lse

2458: rl.rule_information2 rl_date
2459: FROM okc_rule_groups_b rg,
2460: okc_rules_b rl,
2461: okc_k_lines_v cle,
2462: okc_line_styles_b lse
2463: WHERE cle.dnz_chr_id = p_chr_id
2464: AND cle.id = p_cle_id
2465: AND cle.lse_id = lse.id
2466: AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)

Line 2477: okc_line_styles_b lse_sl

2473: AND rg.rgd_code = 'LALEVL'
2474: AND rl.rule_information_category = 'LASLL'
2475: AND not exists (SELECT '1'
2476: FROM okc_k_lines_v cle_sl,
2477: okc_line_styles_b lse_sl
2478: WHERE cle_sl.dnz_chr_id = p_chr_id
2479: AND cle_sl.cle_id = cle.id
2480: AND cle_sl.lse_id = lse_sl.id
2481: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/

Line 2491: okc_line_styles_b lse

2487: rl.rule_information6 payment_amount
2488: FROM okc_rule_groups_b rg,
2489: okc_rules_b rl,
2490: okc_k_lines_v cle,
2491: okc_line_styles_b lse
2492: WHERE cle.dnz_chr_id = p_chr_id
2493: AND cle.id = p_cle_id
2494: AND cle.lse_id = lse.id
2495: AND lse.lty_code in (G_SER_LINE_LTY_CODE,G_FEE_LINE_LTY_CODE)

Line 2506: okc_line_styles_b lse_sl

2502: AND rg.rgd_code = 'LALEVL'
2503: AND rl.rule_information_category = 'LASLL'
2504: AND exists (SELECT '1'
2505: FROM okc_k_lines_v cle_sl,
2506: okc_line_styles_b lse_sl
2507: WHERE cle_sl.dnz_chr_id = p_chr_id
2508: AND cle_sl.cle_id = cle.id
2509: AND cle_sl.lse_id = lse_sl.id
2510: AND lse_sl.lty_code in (G_SRL_LINE_LTY_CODE,G_FEL_LINE_LTY_CODE));*/

Line 2521: okc_line_styles_b lse

2517: cle.currency_code
2518: FROM okc_rule_groups_b rg,
2519: okc_rules_b rl,
2520: okc_k_lines_v cle,
2521: okc_line_styles_b lse
2522: WHERE cle.dnz_chr_id = p_chr_id
2523: AND cle.id = p_cle_id
2524: AND cle.lse_id = lse.id
2525: AND lse.lty_code = G_SER_LINE_LTY_CODE

Line 2555: okc_line_styles_b lse

2551: SELECT cle.id id,
2552: NVL(kle.amount,0) amount
2553: FROM okl_k_lines_v kle,
2554: okc_k_lines_v cle,
2555: okc_line_styles_b lse
2556: WHERE cle.dnz_chr_id = p_chr_id
2557: AND cle.id = kle.id
2558: AND cle.lse_id = lse.id
2559: AND lse.lty_code = G_SER_LINE_LTY_CODE

Line 2571: okc_line_styles_b lse

2567: SELECT cle.id id,
2568: NVL(kle.amount,0) amount
2569: FROM okl_k_lines_v kle,
2570: okc_k_lines_v cle,
2571: okc_line_styles_b lse
2572: WHERE cle.dnz_chr_id = p_old_chr_id
2573: AND cle.id = kle.id
2574: AND cle.lse_id = lse.id
2575: AND lse.lty_code = 'SOLD_SERVICE'

Line 2598: okc_line_styles_b lse

2594: cle.currency_code
2595: FROM okc_rule_groups_b rg,
2596: okc_rules_b rl,
2597: okc_k_lines_v cle,
2598: okc_line_styles_b lse
2599: WHERE cle.dnz_chr_id = p_chr_id
2600: AND cle.id = p_cle_id
2601: AND cle.lse_id = lse.id
2602: AND cle.cle_id IS NULL

Line 3324: OKC_LINE_STYLES_b lse

3320: SELECT '1'
3321: FROM DUAL
3322: WHERE EXISTS (SELECT '1'
3323: FROM OKC_K_LINES_B cle,
3324: OKC_LINE_STYLES_b lse
3325: WHERE cle.dnz_chr_id = p_chr_id
3326: AND lse.id = cle.lse_id
3327: AND lse.lty_code IN (G_USG_LINE_LTY_CODE,
3328: G_USL_LINE_LTY_CODE));