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 313: okc_line_styles_b lseb,

309: Select 'Y' rbk_asst_flag,
310: clet.NAME
311: from okc_k_lines_tl clet,
312: okc_k_lines_b cleb,
313: okc_line_styles_b lseb,
314: okc_k_headers_b chrb
315: where chrb.id = cleb.dnz_chr_id
316: and chrb.scs_code = 'LEASE'
317: and chrb.orig_system_source_code = 'OKL_REBOOK'

Line 874: okc_line_styles_b lse

870: --start modified abhsaxen for performance SQLID 20562304
871: select 'Y'
872: from okc_k_lines_b kleb,
873: okc_k_lines_tl kle,
874: okc_line_styles_b lse
875: where kle.name = p_asset_number
876: and kle.id = kleb.id
877: and kle.language = USERENV('LANG')
878: and kleb.lse_id = lse.id

Line 905: okc_line_styles_b lse

901: Select 'Y'
902: From Dual
903: Where exists (select '1'
904: from okc_k_lines_b cle,
905: okc_line_styles_b lse
906: where cle.lse_id = lse.id
907: and lse.lty_code = 'FREE_FORM1'
908: and cle.id = p_line_id);
909:

Line 922: OKC_LINE_STYLES_B lse

918: Select txlv.id,
919: txlv.asset_number
920: From OKL_TXL_ASSETS_V txlv,
921: OKC_K_LINES_B cle,
922: OKC_LINE_STYLES_B lse
923: Where txlv.kle_id = cle.id
924: And cle.lse_id = lse.id
925: And lse.lty_code = 'FIXED_ASSET'
926: And cle.cle_id = p_finasst_id

Line 939: OKC_LINE_STYLES_B lse

935: txdv.asset_number
936: From OKL_TXD_ASSETS_V txdv,
937: OKL_TXL_ASSETS_V txlv,
938: OKC_K_LINES_B cle,
939: OKC_LINE_STYLES_B lse
940: Where txdv.tal_id = txlv.id
941: And txlv.kle_id = cle.id
942: And cle.lse_id = lse.id
943: And lse.lty_code = 'FIXED_ASSET'

Line 1151: okc_line_styles_b lse

1147: Select 'Y'
1148: From Dual
1149: Where exists (select '1'
1150: from okc_k_lines_b cle,
1151: okc_line_styles_b lse
1152: where cle.lse_id = lse.id
1153: and lse.lty_code = 'FREE_FORM1'
1154: and cle.id = p_line_id);
1155:

Line 1163: okc_line_styles_b lnk_lse,

1159: --cursor to check if financial asset appears as linked asset
1160: CURSOR l_lnk_ast_csr (p_line_id OKC_K_LINES_B.ID%TYPE) IS
1161: Select lnk.id
1162: From okc_k_lines_b lnk,
1163: okc_line_styles_b lnk_lse,
1164: okc_statuses_b sts,
1165: okc_k_items cim
1166: Where lnk.id = cim.cle_id
1167: and lnk.dnz_chr_id = cim.dnz_chr_id

Line 1342: from okc_line_styles_b lseb

1338: --cursor to get line style
1339: cursor l_lse_csr (p_lse_id in number ) is
1340: select lseb.lty_code,
1341: lseb.lse_type
1342: from okc_line_styles_b lseb
1343: where lseb.id = p_lse_id;
1344:
1345: l_lty_code okc_line_styles_b.lty_code%TYPE;
1346: l_lse_type okc_line_styles_b.lse_type%TYPE;

Line 1345: l_lty_code okc_line_styles_b.lty_code%TYPE;

1341: lseb.lse_type
1342: from okc_line_styles_b lseb
1343: where lseb.id = p_lse_id;
1344:
1345: l_lty_code okc_line_styles_b.lty_code%TYPE;
1346: l_lse_type okc_line_styles_b.lse_type%TYPE;
1347:
1348: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1349:

Line 1346: l_lse_type okc_line_styles_b.lse_type%TYPE;

1342: from okc_line_styles_b lseb
1343: where lseb.id = p_lse_id;
1344:
1345: l_lty_code okc_line_styles_b.lty_code%TYPE;
1346: l_lse_type okc_line_styles_b.lse_type%TYPE;
1347:
1348: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1349:
1350: l_rbk_cpy varchar2(1) default 'N';

Line 1807: okc_line_styles_b lseb

1803: select txdb.id
1804: from okl_txd_assets_b txdb,
1805: okl_txl_assets_b txlb,
1806: okc_k_lines_b cleb,
1807: okc_line_styles_b lseb
1808: where txdb.tax_book = p_book_type_code
1809: and txdb.tal_id = txlb.id
1810: and txlb.kle_id = cleb.id
1811: and cleb.lse_id = lseb.id

Line 2985: okc_line_styles_b lseb

2981: select txdb.id
2982: from okl_txd_assets_b txdb,
2983: okl_txl_assets_b txlb,
2984: okc_k_lines_b cleb,
2985: okc_line_styles_b lseb
2986: where txdb.tax_book = p_book_type_code
2987: and txdb.tal_id = txlb.id
2988: and txlb.kle_id = cleb.id
2989: and cleb.lse_id = lseb.id

Line 3027: from okc_line_styles_b lseb

3023: --Bug# 3143522 : Subsidies
3024: --cursor to get lty code
3025: cursor l_ltycd_csr (p_lse_id in number) is
3026: select lseb.lty_code
3027: from okc_line_styles_b lseb
3028: where lseb.id = p_lse_id;
3029:
3030: l_lty_code okc_line_styles_b.lty_code%TYPE default null;
3031:

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

3026: select lseb.lty_code
3027: from okc_line_styles_b lseb
3028: where lseb.id = p_lse_id;
3029:
3030: l_lty_code okc_line_styles_b.lty_code%TYPE default null;
3031:
3032: --cursor to get maximum subsidy term
3033: cursor l_sub_csr (p_cle_id in number) is
3034: select subb.maximum_term

Line 3060: OKC_LINE_STYLES_B OKC_ST

3056: FROM OKL_TXL_ASSETS_B
3057: WHERE KLE_ID IN
3058: (SELECT OKC.ID
3059: FROM OKC_K_LINES_B OKC,
3060: OKC_LINE_STYLES_B OKC_ST
3061: WHERE OKC_ST.LTY_CODE ='FREE_FORM1'
3062: AND OKC.LSE_ID=OKC_ST.ID
3063: AND OKC.CHR_ID =OKC.DNZ_CHR_ID
3064: AND OKC.CHR_ID =p_chr_id1);

Line 4301: FROM okc_line_styles_b lse,

4297: WHERE khr_id = p_khr_id;
4298:
4299: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4300: SELECT cle.id top_line
4301: FROM okc_line_styles_b lse,
4302: okc_k_lines_b cle
4303: WHERE cle.dnz_chr_id = p_dnz_chr_id
4304: AND cle.cle_id IS NULL
4305: AND cle.chr_id = cle.dnz_chr_id

Line 6128: FROM okc_line_styles_b lse,

6124: */
6125: --cursor to fetch the line style code for line style id passed
6126: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6127: SELECT lse.lty_code
6128: FROM okc_line_styles_b lse,
6129: okc_k_lines_b line
6130: WHERE lse.id = line.lse_id
6131: AND line.id = p_line_id;
6132:

Line 6133: l_lty_code okc_line_styles_b.lty_code%TYPE;

6129: okc_k_lines_b line
6130: WHERE lse.id = line.lse_id
6131: AND line.id = p_line_id;
6132:
6133: l_lty_code okc_line_styles_b.lty_code%TYPE;
6134: l_parameter_list wf_parameter_list_t;
6135: l_event_name wf_events.name%TYPE := null;
6136: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
6137: /*

Line 6590: FROM okc_line_styles_b lse,

6586: */
6587: --cursor to fetch the line style code for line style id passed
6588: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
6589: SELECT lse.lty_code
6590: FROM okc_line_styles_b lse,
6591: okc_k_lines_b line
6592: WHERE lse.id = line.lse_id
6593: AND line.id = p_line_id;
6594:

Line 6610: l_lty_code okc_line_styles_b.lty_code%TYPE;

6606: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6608:
6609:
6610: l_lty_code okc_line_styles_b.lty_code%TYPE;
6611: l_parameter_list wf_parameter_list_t;
6612: l_event_name wf_events.name%TYPE := null;
6613: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
6614: /*

Line 7402: FROM okc_line_styles_b lse,

7398: */
7399: --cursor to fetch the line style code for line style id passed
7400: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
7401: SELECT lse.lty_code
7402: FROM okc_line_styles_b lse,
7403: okc_k_lines_b lns
7404: WHERE lns.id = p_line_id
7405: AND lse.id = lns.lse_id;
7406:

Line 7407: l_lty_code okc_line_styles_b.lty_code%TYPE;

7403: okc_k_lines_b lns
7404: WHERE lns.id = p_line_id
7405: AND lse.id = lns.lse_id;
7406:
7407: l_lty_code okc_line_styles_b.lty_code%TYPE;
7408: l_parameter_list wf_parameter_list_t;
7409: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
7410: l_business_event_name WF_EVENTS.NAME%TYPE;
7411: /*

Line 8261: FROM okc_line_styles_b lse,

8257: */
8258: --cursor to fetch the line style code for line style id passed
8259: CURSOR lty_code_csr(p_line_id okc_k_lines_b.id%TYPE) IS
8260: SELECT lse.lty_code
8261: FROM okc_line_styles_b lse,
8262: okc_k_lines_b lns
8263: WHERE lns.id = p_line_id
8264: AND lse.id = lns.lse_id;
8265:

Line 8266: l_lty_code okc_line_styles_b.lty_code%TYPE;

8262: okc_k_lines_b lns
8263: WHERE lns.id = p_line_id
8264: AND lse.id = lns.lse_id;
8265:
8266: l_lty_code okc_line_styles_b.lty_code%TYPE;
8267: l_parameter_list wf_parameter_list_t;
8268: l_raise_business_event VARCHAR2(1) := OKL_API.G_FALSE;
8269: l_business_event_name WF_EVENTS.NAME%TYPE;
8270: /*

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

10831: SELECT 'x' FROM okc_k_items cim
10832: WHERE cim.object1_id1 = to_char(chr.id)
10833: AND EXISTS
10834: (
10835: SELECT 'x' FROM okc_k_lines_b cle, okc_line_styles_b lse
10836: WHERE cle.lse_id = lse.id
10837: AND lse.lty_code = 'SHARED'
10838: AND cle.id = cim.cle_id
10839: )