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 6819: FROM okc_subclass_top_line stl,

6815: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
6816: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
6817: IS
6818: SELECT cle.id
6819: FROM okc_subclass_top_line stl,
6820: okc_line_styles_b lse2,
6821: okc_line_styles_b lse1,
6822: okc_k_lines_b cle
6823: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 6831: FROM okc_subclass_top_line stl,

6827: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
6828: AND lse2.id = stl.lse_id
6829: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
6830: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
6831: FROM okc_subclass_top_line stl,
6832: okc_line_styles_b lse2,
6833: okc_line_styles_b lse1,
6834: okc_k_lines_b cle
6835: WHERE cle.id = p_top_line

Line 7017: FROM okc_subclass_top_line stl,

7013: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
7014: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
7015: IS
7016: SELECT cle.id
7017: FROM okc_subclass_top_line stl,
7018: okc_line_styles_b lse2,
7019: okc_line_styles_b lse1,
7020: okc_k_lines_b cle
7021: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 7029: FROM okc_subclass_top_line stl,

7025: AND lse2.lty_code = G_FIN_LINE_LTY_CODE
7026: AND lse2.id = stl.lse_id
7027: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
7028: AND cle.cle_id in (SELECT distinct to_char(cle.cle_id)
7029: FROM okc_subclass_top_line stl,
7030: okc_line_styles_b lse2,
7031: okc_line_styles_b lse1,
7032: okc_k_lines_b cle
7033: WHERE cle.id = p_top_line

Line 8392: -- FROM okc_subclass_top_line stl,

8388: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
8389: IS
8390: -- #4414408
8391: SELECT cle.id
8392: -- FROM okc_subclass_top_line stl,
8393: -- okc_line_styles_b lse2,
8394: -- okc_line_styles_b lse1,
8395: FROM okc_k_lines_b cle
8396: WHERE cle.cle_id = p_top_line

Line 8637: FROM okc_subclass_top_line stl,

8633: lx_klev_rec klev_rec_type;
8634: CURSOR c_get_lse_id_sts(p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
8635: SELECT lse.id,
8636: cle.sts_code
8637: FROM okc_subclass_top_line stl,
8638: okc_line_styles_b lse,
8639: okc_k_lines_v cle
8640: WHERE cle.id = p_top_line_id
8641: AND cle.lse_id = lse.id

Line 8859: FROM okc_subclass_top_line stl,

8855: -- To Find out the Top line ID
8856: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
8857: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
8858: SELECT cle.cle_id
8859: FROM okc_subclass_top_line stl,
8860: okc_line_styles_b lse2,
8861: okc_line_styles_b lse1,
8862: okc_k_items_v cim,
8863: okc_k_lines_v cle

Line 9065: FROM okc_subclass_top_line stl,

9061: -- To Find out the Top line ID
9062: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9063: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9064: SELECT cle.cle_id
9065: FROM okc_subclass_top_line stl,
9066: okc_line_styles_b lse2,
9067: okc_line_styles_b lse1,
9068: okc_k_items_v cim,
9069: okc_k_lines_v cle

Line 9270: FROM okc_subclass_top_line stl,

9266: -- To Find out the Top line ID
9267: CURSOR c_model_top_line(p_model_line_id OKC_K_LINES_V.ID%TYPE,
9268: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
9269: SELECT cle.cle_id
9270: FROM okc_subclass_top_line stl,
9271: okc_line_styles_b lse2,
9272: okc_line_styles_b lse1,
9273: okc_k_items_v cim,
9274: okc_k_lines_v cle

Line 9777: FROM okc_subclass_top_line stl,

9773: CURSOR get_fa_id(p_top_line OKC_K_LINES_V.ID%TYPE,
9774: p_dnz_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE)
9775: IS
9776: SELECT cle.id
9777: FROM okc_subclass_top_line stl,
9778: okc_line_styles_b lse2,
9779: okc_line_styles_b lse1,
9780: okc_k_lines_v cle
9781: WHERE cle.cle_id = p_top_line

Line 17887: FROM okc_subclass_top_line stl,

17883:
17884: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17885: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17886: SELECT count(cle.id)
17887: FROM okc_subclass_top_line stl,
17888: okc_line_styles_b lse2,
17889: okc_line_styles_b lse1,
17890: okc_k_lines_v cle
17891: WHERE cle.cle_id = p_cle_id

Line 17903: FROM okc_subclass_top_line stl,

17899:
17900: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17901: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17902: SELECT cle.id
17903: FROM okc_subclass_top_line stl,
17904: okc_line_styles_b lse2,
17905: okc_line_styles_b lse1,
17906: okc_k_lines_v cle
17907: WHERE cle.cle_id = p_cle_id

Line 17919: FROM okc_subclass_top_line stl,

17915:
17916: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17917: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17918: SELECT cle.id
17919: FROM okc_subclass_top_line stl,
17920: okc_line_styles_b lse2,
17921: okc_line_styles_b lse1,
17922: okc_k_lines_v cle
17923: WHERE cle.cle_id = p_cle_id

Line 17935: FROM okc_subclass_top_line stl,

17931:
17932: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17933: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17934: SELECT cle.id
17935: FROM okc_subclass_top_line stl,
17936: okc_line_styles_b lse3,
17937: okc_line_styles_b lse2,
17938: okc_line_styles_b lse1,
17939: okc_k_lines_b cle

Line 17950: FROM okc_subclass_top_line stl,

17946: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
17947: AND lse3.id = stl.lse_id
17948: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
17949: AND cle.cle_id in (SELECT cle.id
17950: FROM okc_subclass_top_line stl,
17951: okc_line_styles_b lse2,
17952: okc_line_styles_b lse1,
17953: okc_k_lines_b cle
17954: WHERE cle.cle_id = p_cle_id

Line 17966: FROM okc_subclass_top_line stl,

17962:
17963: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
17964: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
17965: SELECT cim.number_of_items
17966: FROM okc_subclass_top_line stl,
17967: okc_line_styles_b lse2,
17968: okc_line_styles_b lse1,
17969: okc_k_items_v cim,
17970: okc_k_lines_v cle

Line 18907: FROM okc_subclass_top_line stl,

18903:
18904: CURSOR c_remain_inst_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18905: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18906: SELECT count(cle.id)
18907: FROM okc_subclass_top_line stl,
18908: okc_line_styles_b lse2,
18909: okc_line_styles_b lse1,
18910: okc_k_lines_v cle
18911: WHERE cle.cle_id = p_cle_id

Line 18923: FROM okc_subclass_top_line stl,

18919:
18920: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18921: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18922: SELECT cle.id
18923: FROM okc_subclass_top_line stl,
18924: okc_line_styles_b lse2,
18925: okc_line_styles_b lse1,
18926: okc_k_lines_v cle
18927: WHERE cle.cle_id = p_cle_id

Line 18939: FROM okc_subclass_top_line stl,

18935:
18936: CURSOR c_model_item(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18937: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18938: SELECT cim.object1_id1
18939: FROM okc_subclass_top_line stl,
18940: okc_line_styles_b lse2,
18941: okc_line_styles_b lse1,
18942: okc_k_items cim,
18943: okc_k_lines_v cle

Line 18959: FROM okc_subclass_top_line stl,

18955:
18956: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18957: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18958: SELECT cle.id
18959: FROM okc_subclass_top_line stl,
18960: okc_line_styles_b lse2,
18961: okc_line_styles_b lse1,
18962: okc_k_lines_v cle
18963: WHERE cle.cle_id = p_cle_id

Line 18975: FROM okc_subclass_top_line stl,

18971:
18972: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
18973: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
18974: SELECT cle.id
18975: FROM okc_subclass_top_line stl,
18976: okc_line_styles_b lse3,
18977: okc_line_styles_b lse2,
18978: okc_line_styles_b lse1,
18979: okc_k_lines_b cle

Line 18990: FROM okc_subclass_top_line stl,

18986: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
18987: AND lse3.id = stl.lse_id
18988: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
18989: AND cle.cle_id in (SELECT cle.id
18990: FROM okc_subclass_top_line stl,
18991: okc_line_styles_b lse2,
18992: okc_line_styles_b lse1,
18993: okc_k_lines_b cle
18994: WHERE cle.cle_id = p_cle_id

Line 19824: FROM okc_subclass_top_line stl,

19820:
19821: CURSOR c_model_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19822: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19823: SELECT cle.id
19824: FROM okc_subclass_top_line stl,
19825: okc_line_styles_b lse2,
19826: okc_line_styles_b lse1,
19827: okc_k_lines_v cle
19828: WHERE cle.cle_id = p_cle_id

Line 19840: FROM okc_subclass_top_line stl,

19836:
19837: CURSOR c_fa_line(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19838: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19839: SELECT cle.id
19840: FROM okc_subclass_top_line stl,
19841: okc_line_styles_b lse2,
19842: okc_line_styles_b lse1,
19843: okc_k_lines_v cle
19844: WHERE cle.cle_id = p_cle_id

Line 19856: FROM okc_subclass_top_line stl,

19852:
19853: CURSOR c_addon_line_id(p_cle_id OKC_K_LINES_V.CLE_ID%TYPE,
19854: p_chr_id OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
19855: SELECT cle.id
19856: FROM okc_subclass_top_line stl,
19857: okc_line_styles_b lse3,
19858: okc_line_styles_b lse2,
19859: okc_line_styles_b lse1,
19860: okc_k_lines_b cle

Line 19871: FROM okc_subclass_top_line stl,

19867: AND lse3.lty_code = G_FIN_LINE_LTY_CODE
19868: AND lse3.id = stl.lse_id
19869: AND stl.scs_code in (G_LEASE_SCS_CODE,G_LOAN_SCS_CODE)
19870: AND cle.cle_id in (SELECT cle.id
19871: FROM okc_subclass_top_line stl,
19872: okc_line_styles_b lse2,
19873: okc_line_styles_b lse1,
19874: okc_k_lines_b cle
19875: WHERE cle.cle_id = p_cle_id