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

Line 348: FROM okc_line_styles_b lse,

344: CURSOR c_get_fa_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)
345: IS
346: SELECT cle.id,
347: cle.dnz_chr_id
348: FROM okc_line_styles_b lse,
349: okc_k_lines_v cle
350: WHERE cle.cle_id = p_cle_id
351: AND lse.id = cle.lse_id
352: AND lse.lty_code = G_FA_LINE_LTY_CODE;

Line 358: FROM okc_line_styles_b lse_ib,

354: CURSOR c_get_ib_line_id(p_cle_id OKC_K_LINES_V.ID%TYPE)
355: IS
356: SELECT cle_ib.id,
357: cle_ib.dnz_chr_id
358: FROM okc_line_styles_b lse_ib,
359: okc_k_lines_b cle_ib,
360: okc_line_styles_b lse_inst,
361: okc_k_lines_b cle_inst
362: WHERE cle_inst.cle_id = p_cle_id

Line 360: okc_line_styles_b lse_inst,

356: SELECT cle_ib.id,
357: cle_ib.dnz_chr_id
358: FROM okc_line_styles_b lse_ib,
359: okc_k_lines_b cle_ib,
360: okc_line_styles_b lse_inst,
361: okc_k_lines_b cle_inst
362: WHERE cle_inst.cle_id = p_cle_id
363: AND cle_inst.lse_id = lse_inst.id
364: AND lse_inst.lty_code = G_INST_LINE_LTY_CODE

Line 3070: okc_line_styles_b mdl_lse,

3066: fin_kle.oec oec,
3067: fa_kle.year_built Year_of_Manufacture
3068: From okc_k_items mdl_cim,
3069: okc_k_lines_b mdl_cle,
3070: okc_line_styles_b mdl_lse,
3071: okl_k_lines fin_kle,
3072: okc_k_lines_tl fin_tl,
3073: okc_k_lines_b fin_cle,
3074: okc_line_styles_b fin_lse,

Line 3074: okc_line_styles_b fin_lse,

3070: okc_line_styles_b mdl_lse,
3071: okl_k_lines fin_kle,
3072: okc_k_lines_tl fin_tl,
3073: okc_k_lines_b fin_cle,
3074: okc_line_styles_b fin_lse,
3075: okl_k_lines fa_kle,
3076: okc_k_lines_b fa_cle,
3077: okc_line_styles_b fa_lse
3078: where mdl_cim.cle_id = mdl_cle.id

Line 3077: okc_line_styles_b fa_lse

3073: okc_k_lines_b fin_cle,
3074: okc_line_styles_b fin_lse,
3075: okl_k_lines fa_kle,
3076: okc_k_lines_b fa_cle,
3077: okc_line_styles_b fa_lse
3078: where mdl_cim.cle_id = mdl_cle.id
3079: and mdl_cim.dnz_chr_id = mdl_cle.dnz_chr_id
3080: and mdl_cle.cle_id = fin_cle.id
3081: and mdl_cle.dnz_chr_id = fin_cle.dnz_chr_id

Line 3912: okc_line_styles_b lseb_model,

3908: cim_model.object1_id1,
3909: cim_model.object1_id2
3910: from okc_k_items cim_model,
3911: okc_k_lines_b cleb_model,
3912: okc_line_styles_b lseb_model,
3913: okl_k_lines kle_fin
3914: where cim_model.cle_id = cleb_model.id
3915: and cleb_model.cle_id = p_cle_id
3916: and lseb_model.id = cleb_model.lse_id

Line 4277: okc_line_styles_b lse,

4273: SELECT khrv.deal_type,
4274: klev.oec
4275: FROM okl_k_headers_v khrv,
4276: okc_subclass_top_line stl,
4277: okc_line_styles_b lse,
4278: okc_k_lines_v cle,
4279: okl_k_lines_v klev
4280: WHERE cle.cle_id is null
4281: AND cle.id = klev.id

Line 5620: okc_line_styles_b cov_ast_lseb,

5616: cursor l_cap_amnt_csr(p_cim_id in number) is
5617: select cov_ast_cim.object1_id1,
5618: cov_ast_cim.dnz_chr_id
5619: from okc_k_lines_b cov_ast_cleb,
5620: okc_line_styles_b cov_ast_lseb,
5621: okl_k_lines fee_kle,
5622: okc_k_items cov_ast_cim
5623: where fee_kle.id = cov_ast_cleb.cle_id
5624: and fee_kle.fee_type = 'CAPITALIZED'

Line 5634: okc_line_styles_b fin_ast_lseb

5630: --Bug# 4057305 : exclude the linked asset lines for which the asset does not
5631: -- exist on the same contract
5632: and exists (select '1'
5633: from okc_k_lines_b fin_ast_cleb,
5634: okc_line_styles_b fin_ast_lseb
5635: where fin_ast_cleb.id = cov_ast_cim.object1_id1
5636: and fin_ast_cleb.lse_id = fin_ast_lseb.id
5637: and fin_ast_lseb.lty_code = 'FREE_FORM1'
5638: and fin_ast_cleb.dnz_chr_id = cov_ast_cim.dnz_chr_id);

Line 5777: FROM okc_line_styles_b lse,

5773: ) IS
5774: CURSOR line_style_csr(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS
5775: SELECT lse.lty_code,
5776: cle.dnz_chr_id
5777: FROM okc_line_styles_b lse,
5778: okc_k_lines_b cle
5779: WHERE cle.id = p_top_line_id
5780: AND cle.lse_id = lse.id
5781: AND lse.lse_parent_id is null

Line 5846: l_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;

5842: WHERE orig_system_id1 = p_line_id
5843: AND dnz_chr_id = p_chr_id;
5844:
5845: copy_service_failed EXCEPTION;
5846: l_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
5847: l_from_chr_id OKC_K_HEADERS_B.ID%TYPE;
5848: l_h_link_exist VARCHAR2(1) := 'N';
5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;
5850:

Line 5980: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;

5976: IS
5977: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COPY_ASSETS';
5978: l_api_version CONSTANT NUMBER := 1;
5979: i NUMBER := 0;
5980: lv_lty_code OKC_LINE_STYLES_B.LTY_CODE%TYPE;
5981: lx_cle_id_tbl klev_tbl_type;
5982: l_new_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;
5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;

Line 6003: FROM okc_line_styles_b lse,

5999: CURSOR c_get_lty_code(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS
6000:
6001: SELECT lse.lty_code,
6002: cle.dnz_chr_id
6003: FROM okc_line_styles_b lse,
6004: okc_k_lines_b cle
6005: WHERE cle.id = p_top_line_id
6006: AND cle.lse_id = lse.id
6007: AND lse.lse_parent_id is null

Line 6013: FROM okc_line_styles_b lse,

6009:
6010: CURSOR c_get_tls_spk(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
6011: IS
6012: SELECT cle.id top_line_id
6013: FROM okc_line_styles_b lse,
6014: okc_k_lines_b cle
6015: WHERE cle.dnz_chr_id = p_dnz_chr_id
6016: AND cle.lse_id = lse.id
6017: AND lse.lse_parent_id is null