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

Line 326: okc_line_styles_b lseb,

322: Select 'Y' rbk_asst_flag,
323: clet.NAME
324: from okc_k_lines_tl clet,
325: okc_k_lines_b cleb,
326: okc_line_styles_b lseb,
327: okc_k_headers_b chrb
328: where chrb.id = cleb.dnz_chr_id
329: and chrb.scs_code = 'LEASE'
330: and chrb.orig_system_source_code = 'OKL_REBOOK'

Line 906: okc_line_styles_b lse

902: --start modified abhsaxen for performance SQLID 20562304
903: select 'Y'
904: from okc_k_lines_b kleb,
905: okc_k_lines_tl kle,
906: okc_line_styles_b lse
907: where kle.name = p_asset_number
908: and kle.id = kleb.id
909: and kle.language = USERENV('LANG')
910: and kleb.lse_id = lse.id

Line 937: okc_line_styles_b lse

933: Select 'Y'
934: From Dual
935: Where exists (select '1'
936: from okc_k_lines_b cle,
937: okc_line_styles_b lse
938: where cle.lse_id = lse.id
939: and lse.lty_code = 'FREE_FORM1'
940: and cle.id = p_line_id);
941:

Line 954: OKC_LINE_STYLES_B lse

950: Select txlv.id,
951: txlv.asset_number
952: From OKL_TXL_ASSETS_V txlv,
953: OKC_K_LINES_B cle,
954: OKC_LINE_STYLES_B lse
955: Where txlv.kle_id = cle.id
956: And cle.lse_id = lse.id
957: And lse.lty_code = 'FIXED_ASSET'
958: And cle.cle_id = p_finasst_id

Line 971: OKC_LINE_STYLES_B lse

967: txdv.asset_number
968: From OKL_TXD_ASSETS_V txdv,
969: OKL_TXL_ASSETS_V txlv,
970: OKC_K_LINES_B cle,
971: OKC_LINE_STYLES_B lse
972: Where txdv.tal_id = txlv.id
973: And txlv.kle_id = cle.id
974: And cle.lse_id = lse.id
975: And lse.lty_code = 'FIXED_ASSET'

Line 1183: okc_line_styles_b lse

1179: Select 'Y'
1180: From Dual
1181: Where exists (select '1'
1182: from okc_k_lines_b cle,
1183: okc_line_styles_b lse
1184: where cle.lse_id = lse.id
1185: and lse.lty_code = 'FREE_FORM1'
1186: and cle.id = p_line_id);
1187:

Line 1195: okc_line_styles_b lnk_lse,

1191: --cursor to check if financial asset appears as linked asset
1192: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1193: Select lnk.id
1194: From okc_k_lines_b lnk,
1195: okc_line_styles_b lnk_lse,
1196: okc_statuses_b sts,
1197: okc_k_items cim
1198: Where lnk.id = cim.cle_id
1199: and lnk.dnz_chr_id = cim.dnz_chr_id

Line 1374: from okc_line_styles_b lseb

1370: --cursor to get line style
1371: cursor l_lse_csr (p_lse_id in number ) is
1372: select lseb.lty_code,
1373: lseb.lse_type
1374: from okc_line_styles_b lseb
1375: where lseb.id = p_lse_id;
1376:
1377: l_lty_code okc_line_styles_b.lty_code%TYPE;
1378: l_lse_type okc_line_styles_b.lse_type%TYPE;

Line 1377: l_lty_code okc_line_styles_b.lty_code%TYPE;

1373: lseb.lse_type
1374: from okc_line_styles_b lseb
1375: where lseb.id = p_lse_id;
1376:
1377: l_lty_code okc_line_styles_b.lty_code%TYPE;
1378: l_lse_type okc_line_styles_b.lse_type%TYPE;
1379:
1380: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1381:

Line 1378: l_lse_type okc_line_styles_b.lse_type%TYPE;

1374: from okc_line_styles_b lseb
1375: where lseb.id = p_lse_id;
1376:
1377: l_lty_code okc_line_styles_b.lty_code%TYPE;
1378: l_lse_type okc_line_styles_b.lse_type%TYPE;
1379:
1380: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1381:
1382: l_rbk_cpy varchar2(1) default 'N';

Line 1843: okc_line_styles_b lseb

1839: select txdb.id
1840: from okl_txd_assets_b txdb,
1841: okl_txl_assets_b txlb,
1842: okc_k_lines_b cleb,
1843: okc_line_styles_b lseb
1844: where txdb.tax_book = p_book_type_code
1845: and txdb.tal_id = txlb.id
1846: and txlb.kle_id = cleb.id
1847: and cleb.lse_id = lseb.id

Line 1857: okc_line_styles_b lseb,

1853: select txdb.id
1854: from okl_txd_assets_b txdb,
1855: okl_txl_assets_b txlb,
1856: okc_k_lines_b cleb,
1857: okc_line_styles_b lseb,
1858: okc_k_lines_b cleb_top,
1859: okl_k_lines kle_top
1860: where txdb.tax_book = p_book_type_code
1861: and txdb.tal_id = txlb.id

Line 3064: okc_line_styles_b lseb

3060: select txdb.id
3061: from okl_txd_assets_b txdb,
3062: okl_txl_assets_b txlb,
3063: okc_k_lines_b cleb,
3064: okc_line_styles_b lseb
3065: where txdb.tax_book = p_book_type_code
3066: and txdb.tal_id = txlb.id
3067: and txlb.kle_id = cleb.id
3068: and cleb.lse_id = lseb.id

Line 3106: from okc_line_styles_b lseb

3102: --Bug# 3143522 : Subsidies
3103: --cursor to get lty code
3104: cursor l_ltycd_csr (p_lse_id in number) is
3105: select lseb.lty_code
3106: from okc_line_styles_b lseb
3107: where lseb.id = p_lse_id;
3108:
3109: l_lty_code okc_line_styles_b.lty_code%TYPE default null;
3110:

Line 3109: l_lty_code okc_line_styles_b.lty_code%TYPE default null;

3105: select lseb.lty_code
3106: from okc_line_styles_b lseb
3107: where lseb.id = p_lse_id;
3108:
3109: l_lty_code okc_line_styles_b.lty_code%TYPE default null;
3110:
3111: --cursor to get maximum subsidy term
3112: cursor l_sub_csr (p_cle_id in number) is
3113: select subb.maximum_term

Line 3139: OKC_LINE_STYLES_B OKC_ST

3135: FROM OKL_TXL_ASSETS_B
3136: WHERE KLE_ID IN
3137: (SELECT OKC.ID
3138: FROM OKC_K_LINES_B OKC,
3139: OKC_LINE_STYLES_B OKC_ST
3140: WHERE OKC_ST.LTY_CODE ='FREE_FORM1'
3141: AND OKC.LSE_ID=OKC_ST.ID
3142: AND OKC.CHR_ID =OKC.DNZ_CHR_ID
3143: AND OKC.CHR_ID =p_chr_id1);

Line 4386: FROM okc_line_styles_b lse,

4382: WHERE khr_id = p_khr_id;
4383:
4384: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4385: SELECT cle.id top_line
4386: FROM okc_line_styles_b lse,
4387: okc_k_lines_b cle
4388: WHERE cle.dnz_chr_id = p_dnz_chr_id
4389: AND cle.cle_id IS NULL
4390: AND cle.chr_id = cle.dnz_chr_id

Line 6230: FROM okc_line_styles_b lse,

6226: */
6227: --cursor to fetch the line style code for line style id passed
6228: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6229: SELECT lse.lty_code
6230: FROM okc_line_styles_b lse,
6231: okc_k_lines_b line
6232: WHERE lse.id = line.lse_id
6233: AND line.id = p_line_id;
6234:

Line 6235: l_lty_code okc_line_styles_b.lty_code%TYPE;

6231: okc_k_lines_b line
6232: WHERE lse.id = line.lse_id
6233: AND line.id = p_line_id;
6234:
6235: l_lty_code okc_line_styles_b.lty_code%TYPE;
6236: l_parameter_list wf_parameter_list_t;
6237: l_event_name wf_events.name%TYPE := null;
6238: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
6239: /*

Line 6692: FROM okc_line_styles_b lse,

6688: */
6689: --cursor to fetch the line style code for line style id passed
6690: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6691: SELECT lse.lty_code
6692: FROM okc_line_styles_b lse,
6693: okc_k_lines_b line
6694: WHERE lse.id = line.lse_id
6695: AND line.id = p_line_id;
6696:

Line 6712: l_lty_code okc_line_styles_b.lty_code%TYPE;

6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6710:
6711:
6712: l_lty_code okc_line_styles_b.lty_code%TYPE;
6713: l_parameter_list wf_parameter_list_t;
6714: l_event_name wf_events.name%TYPE := null;
6715: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
6716: /*

Line 7504: FROM okc_line_styles_b lse,

7500: */
7501: --cursor to fetch the line style code for line style id passed
7502: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7503: SELECT lse.lty_code
7504: FROM okc_line_styles_b lse,
7505: okc_k_lines_b lns
7506: WHERE lns.id = p_line_id
7507: AND lse.id = lns.lse_id;
7508:

Line 7509: l_lty_code okc_line_styles_b.lty_code%TYPE;

7505: okc_k_lines_b lns
7506: WHERE lns.id = p_line_id
7507: AND lse.id = lns.lse_id;
7508:
7509: l_lty_code okc_line_styles_b.lty_code%TYPE;
7510: l_parameter_list wf_parameter_list_t;
7511: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
7512: l_business_event_name WF_EVENTS.NAME%TYPE;
7513: /*

Line 8363: FROM okc_line_styles_b lse,

8359: */
8360: --cursor to fetch the line style code for line style id passed
8361: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8362: SELECT lse.lty_code
8363: FROM okc_line_styles_b lse,
8364: okc_k_lines_b lns
8365: WHERE lns.id = p_line_id
8366: AND lse.id = lns.lse_id;
8367:

Line 8368: l_lty_code okc_line_styles_b.lty_code%TYPE;

8364: okc_k_lines_b lns
8365: WHERE lns.id = p_line_id
8366: AND lse.id = lns.lse_id;
8367:
8368: l_lty_code okc_line_styles_b.lty_code%TYPE;
8369: l_parameter_list wf_parameter_list_t;
8370: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
8371: l_business_event_name WF_EVENTS.NAME%TYPE;
8372: /*

Line 10937: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse

10933: SELECT 'x' FROM okc_k_items cim
10934: WHERE cim.object1_id1 = to_char(chr.id)
10935: AND EXISTS
10936: (
10937: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
10938: WHERE cle.lse_id = lse.id
10939: AND lse.lty_code = 'SHARED'
10940: AND cle.id = cim.cle_id
10941: )