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_CREATE_KLE_PVT dependencies on OKC_SUBCLASS_TOP_LINE

Line 1803: FROM okc_subclass_top_line stl,

1799: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1800:
1801: CURSOR c_get_lse_id1(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1802: SELECT lse.id
1803: FROM okc_subclass_top_line stl,
1804: okc_line_styles_b lse
1805: WHERE lse.lty_code = G_FIN_LINE_LTY_CODE
1806: AND lse.lse_parent_id is null
1807: AND lse.lse_type = G_TLS_TYPE

Line 1813: FROM okc_subclass_top_line stl,

1809: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE);
1810:
1811: CURSOR c_get_lse_id2(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1812: SELECT lse1.id
1813: FROM okc_subclass_top_line stl,
1814: okc_line_styles_b lse2,
1815: okc_line_styles_b lse1
1816: WHERE lse1.lty_code = p_code
1817: AND lse2.lty_code = G_FIN_LINE_LTY_CODE

Line 1825: FROM okc_subclass_top_line stl,

1821:
1822: CURSOR c_get_lse_id3(p_code OKC_LINE_STYLES_V.LTY_CODE%TYPE,
1823: p_code2 OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
1824: SELECT lse1.id
1825: FROM okc_subclass_top_line stl,
1826: okc_line_styles_b lse3,
1827: okc_line_styles_b lse2,
1828: okc_line_styles_b lse1
1829: WHERE lse1.lty_code = p_code

Line 6860: FROM okc_subclass_top_line stl,

6856: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6858: IS
6859: SELECT cle.id
6860: FROM okc_subclass_top_line stl,
6861: okc_line_styles_b lse2,
6862: okc_line_styles_b lse1,
6863: okc_k_lines_b cle
6864: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 6872: FROM okc_subclass_top_line stl,

6868: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
6869: AND lse2.id = stl.lse_id
6870: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6871: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6872: FROM okc_subclass_top_line stl,
6873: okc_line_styles_b lse2,
6874: okc_line_styles_b lse1,
6875: okc_k_lines_b cle
6876: WHERE cle.id = p_top_line

Line 7058: FROM okc_subclass_top_line stl,

7054: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7055: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7056: IS
7057: SELECT cle.id
7058: FROM okc_subclass_top_line stl,
7059: okc_line_styles_b lse2,
7060: okc_line_styles_b lse1,
7061: okc_k_lines_b cle
7062: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 7070: FROM okc_subclass_top_line stl,

7066: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
7067: AND lse2.id = stl.lse_id
7068: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7069: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7070: FROM okc_subclass_top_line stl,
7071: okc_line_styles_b lse2,
7072: okc_line_styles_b lse1,
7073: okc_k_lines_b cle
7074: WHERE cle.id = p_top_line

Line 8433: -- FROM okc_subclass_top_line stl,

8429: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8430: IS
8431: -- #4414408
8432: SELECT cle.id
8433: -- FROM okc_subclass_top_line stl,
8434: -- okc_line_styles_b lse2,
8435: -- okc_line_styles_b lse1,
8436: FROM okc_k_lines_b cle
8437: WHERE cle.cle_id = p_top_line

Line 8678: FROM okc_subclass_top_line stl,

8674: lx_klev_rec klev_rec_type;
8675: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8676: SELECT lse.id,
8677: cle.sts_code
8678: FROM okc_subclass_top_line stl,
8679: okc_line_styles_b lse,
8680: okc_k_lines_v cle
8681: WHERE cle.id = p_top_line_id
8682: AND cle.lse_id = lse.id

Line 8944: FROM okc_subclass_top_line stl,

8940: -- To Find out the Top line ID
8941: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8942: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8943: SELECT cle.cle_id
8944: FROM okc_subclass_top_line stl,
8945: okc_line_styles_b lse2,
8946: okc_line_styles_b lse1,
8947: okc_k_items_v cim,
8948: okc_k_lines_v cle

Line 9150: FROM okc_subclass_top_line stl,

9146: -- To Find out the Top line ID
9147: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9148: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9149: SELECT cle.cle_id
9150: FROM okc_subclass_top_line stl,
9151: okc_line_styles_b lse2,
9152: okc_line_styles_b lse1,
9153: okc_k_items_v cim,
9154: okc_k_lines_v cle

Line 9355: FROM okc_subclass_top_line stl,

9351: -- To Find out the Top line ID
9352: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9353: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9354: SELECT cle.cle_id
9355: FROM okc_subclass_top_line stl,
9356: okc_line_styles_b lse2,
9357: okc_line_styles_b lse1,
9358: okc_k_items_v cim,
9359: okc_k_lines_v cle

Line 9862: FROM okc_subclass_top_line stl,

9858: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9859: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9860: IS
9861: SELECT cle.id
9862: FROM okc_subclass_top_line stl,
9863: okc_line_styles_b lse2,
9864: okc_line_styles_b lse1,
9865: okc_k_lines_v cle
9866: WHERE cle.cle_id = p_top_line

Line 18094: FROM okc_subclass_top_line stl,

18090:
18091: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18092: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18093: SELECT count(cle.id)
18094: FROM okc_subclass_top_line stl,
18095: okc_line_styles_b lse2,
18096: okc_line_styles_b lse1,
18097: okc_k_lines_v cle
18098: WHERE cle.cle_id = p_cle_id

Line 18110: FROM okc_subclass_top_line stl,

18106:
18107: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18108: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18109: SELECT cle.id
18110: FROM okc_subclass_top_line stl,
18111: okc_line_styles_b lse2,
18112: okc_line_styles_b lse1,
18113: okc_k_lines_v cle
18114: WHERE cle.cle_id = p_cle_id

Line 18126: FROM okc_subclass_top_line stl,

18122:
18123: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18124: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18125: SELECT cle.id
18126: FROM okc_subclass_top_line stl,
18127: okc_line_styles_b lse2,
18128: okc_line_styles_b lse1,
18129: okc_k_lines_v cle
18130: WHERE cle.cle_id = p_cle_id

Line 18142: FROM okc_subclass_top_line stl,

18138:
18139: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18140: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18141: SELECT cle.id
18142: FROM okc_subclass_top_line stl,
18143: okc_line_styles_b lse3,
18144: okc_line_styles_b lse2,
18145: okc_line_styles_b lse1,
18146: okc_k_lines_b cle

Line 18157: FROM okc_subclass_top_line stl,

18153: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
18154: AND lse3.id = stl.lse_id
18155: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18156: AND cle.cle_id in (SELECT cle.id
18157: FROM okc_subclass_top_line stl,
18158: okc_line_styles_b lse2,
18159: okc_line_styles_b lse1,
18160: okc_k_lines_b cle
18161: WHERE cle.cle_id = p_cle_id

Line 18173: FROM okc_subclass_top_line stl,

18169:
18170: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18171: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18172: SELECT cim.number_of_items
18173: FROM okc_subclass_top_line stl,
18174: okc_line_styles_b lse2,
18175: okc_line_styles_b lse1,
18176: okc_k_items_v cim,
18177: okc_k_lines_v cle

Line 19138: FROM okc_subclass_top_line stl,

19134:
19135: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19136: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19137: SELECT count(cle.id)
19138: FROM okc_subclass_top_line stl,
19139: okc_line_styles_b lse2,
19140: okc_line_styles_b lse1,
19141: okc_k_lines_v cle
19142: WHERE cle.cle_id = p_cle_id

Line 19154: FROM okc_subclass_top_line stl,

19150:
19151: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19152: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19153: SELECT cle.id
19154: FROM okc_subclass_top_line stl,
19155: okc_line_styles_b lse2,
19156: okc_line_styles_b lse1,
19157: okc_k_lines_v cle
19158: WHERE cle.cle_id = p_cle_id

Line 19170: FROM okc_subclass_top_line stl,

19166:
19167: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19168: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19169: SELECT cim.object1_id1
19170: FROM okc_subclass_top_line stl,
19171: okc_line_styles_b lse2,
19172: okc_line_styles_b lse1,
19173: okc_k_items cim,
19174: okc_k_lines_v cle

Line 19190: FROM okc_subclass_top_line stl,

19186:
19187: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19188: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19189: SELECT cle.id
19190: FROM okc_subclass_top_line stl,
19191: okc_line_styles_b lse2,
19192: okc_line_styles_b lse1,
19193: okc_k_lines_v cle
19194: WHERE cle.cle_id = p_cle_id

Line 19206: FROM okc_subclass_top_line stl,

19202:
19203: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19204: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19205: SELECT cle.id
19206: FROM okc_subclass_top_line stl,
19207: okc_line_styles_b lse3,
19208: okc_line_styles_b lse2,
19209: okc_line_styles_b lse1,
19210: okc_k_lines_b cle

Line 19221: FROM okc_subclass_top_line stl,

19217: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
19218: AND lse3.id = stl.lse_id
19219: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19220: AND cle.cle_id in (SELECT cle.id
19221: FROM okc_subclass_top_line stl,
19222: okc_line_styles_b lse2,
19223: okc_line_styles_b lse1,
19224: okc_k_lines_b cle
19225: WHERE cle.cle_id = p_cle_id

Line 20080: FROM okc_subclass_top_line stl,

20076:
20077: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20078: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20079: SELECT cle.id
20080: FROM okc_subclass_top_line stl,
20081: okc_line_styles_b lse2,
20082: okc_line_styles_b lse1,
20083: okc_k_lines_v cle
20084: WHERE cle.cle_id = p_cle_id

Line 20096: FROM okc_subclass_top_line stl,

20092:
20093: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20094: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20095: SELECT cle.id
20096: FROM okc_subclass_top_line stl,
20097: okc_line_styles_b lse2,
20098: okc_line_styles_b lse1,
20099: okc_k_lines_v cle
20100: WHERE cle.cle_id = p_cle_id

Line 20112: FROM okc_subclass_top_line stl,

20108:
20109: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
20110: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
20111: SELECT cle.id
20112: FROM okc_subclass_top_line stl,
20113: okc_line_styles_b lse3,
20114: okc_line_styles_b lse2,
20115: okc_line_styles_b lse1,
20116: okc_k_lines_b cle

Line 20127: FROM okc_subclass_top_line stl,

20123: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
20124: AND lse3.id = stl.lse_id
20125: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
20126: AND cle.cle_id in (SELECT cle.id
20127: FROM okc_subclass_top_line stl,
20128: okc_line_styles_b lse2,
20129: okc_line_styles_b lse1,
20130: okc_k_lines_b cle
20131: WHERE cle.cle_id = p_cle_id