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_K_LINES_B

Line 115: FROM OKC_K_LINES_B

111: WHERE id = p_ctr_id1;
112:
113: CURSOR get_chr_id_csr(p_kle_id1 NUMBER) IS
114: SELECT DNZ_CHR_ID
115: FROM OKC_K_LINES_B
116: WHERE ID = p_kle_id1;
117:
118: FUNCTION generate_instance_number_ib(x_instance_number_ib OUT NOCOPY OKL_TXL_ITM_INSTS_V.INSTANCE_NUMBER_IB%TYPE)
119: RETURN VARCHAR2 IS

Line 339: FROM okc_k_lines_b cle,

335: SELECT cle.cle_id
336: ,cle.chr_id
337: ,lse.lty_code
338: ,lse.lse_type
339: FROM okc_k_lines_b cle,
340: okc_line_styles_v lse
341: WHERE cle.lse_id = lse.id
342: AND cle.id = p_cle_id;
343:

Line 359: okc_k_lines_b cle_ib,

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
363: AND cle_inst.lse_id = lse_inst.id

Line 361: okc_k_lines_b cle_inst

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
365: AND cle_ib.cle_id = cle_inst.id

Line 3069: okc_k_lines_b mdl_cle,

3065: mdl_cim.number_of_items units,
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,

Line 3073: okc_k_lines_b fin_cle,

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,
3075: okl_k_lines fa_kle,
3076: okc_k_lines_b fa_cle,
3077: okc_line_styles_b fa_lse

Line 3076: okc_k_lines_b fa_cle,

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
3079: and mdl_cim.dnz_chr_id = mdl_cle.dnz_chr_id
3080: and mdl_cle.cle_id = fin_cle.id

Line 3751: okc_k_lines_b cleb_sub

3747: ,ppyd.ATTRIBUTE15
3748: ,cleb_sub.id subsidy_cle_id
3749: from okl_party_payment_dtls ppyd,
3750: okc_k_party_roles_b cplb,
3751: okc_k_lines_b cleb_sub
3752: where ppyd.cpl_id = cplb.id
3753: and cplb.cle_id = cleb_sub.id
3754: and cleb_sub.cle_id = p_from_cle_id
3755: and cleb_sub.sts_code <> 'ABANDONED';

Line 3764: okc_k_lines_b cleb_sub

3760: cursor l_cplb_csr (p_to_cle_id in number,
3761: p_parent_cle_id in number)is
3762: select cplb.id
3763: from okc_k_party_roles_b cplb,
3764: okc_k_lines_b cleb_sub
3765: where cplb.cle_id = cleb_sub.id
3766: and cleb_sub.cle_id = p_to_cle_id
3767: and cleb_sub.orig_system_id1 = p_parent_cle_id
3768: and cleb_sub.dnz_chr_id = cleb_sub.dnz_chr_id

Line 3911: okc_k_lines_b cleb_model,

3907: select kle_fin.item_insurance_category,
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

Line 5585: l_new_cle_id OKC_K_LINES_B.ID%TYPE;

5581: p_new_lnk_cim_id IN NUMBER,
5582: p_object_code IN VARCHAR2,
5583: p_new_chr_id IN NUMBER) IS
5584: l_api_name VARCHAR2(30) := 'LINK_COV_ASSET';
5585: l_new_cle_id OKC_K_LINES_B.ID%TYPE;
5586: l_new_lnk_cim_id NUMBER;
5587: l_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5588: lx_cimv_rec OKL_OKC_MIGRATION_PVT.cimv_rec_type;
5589: --cursor to fetch original fin linked asset line id

Line 5593: FROM OKC_K_LINES_B new_cle,

5589: --cursor to fetch original fin linked asset line id
5590: CURSOR l_orig_ast_csr(p_orig_lnk_cle_id IN NUMBER,
5591: p_new_chr_id IN NUMBER) IS
5592: SELECT new_cle.id
5593: FROM OKC_K_LINES_B new_cle,
5594: OKC_K_ITEMS orig_lnk_cim
5595: WHERE
5596: --Bug# 2998115 :
5597: --Bug# 3868709 : Query fixed for Performance issue

Line 5601: from OKC_K_LINES_B rbk_cle

5597: --Bug# 3868709 : Query fixed for Performance issue
5598: ((new_cle.ORIG_SYSTEM_ID1 = orig_lnk_cim.object1_id1)
5599: OR
5600: exists (select null
5601: from OKC_K_LINES_B rbk_cle
5602: where rbk_cle.id = orig_lnk_cim.object1_id1
5603: AND rbk_cle.ORIG_SYSTEM_ID1 = new_cle.id)
5604: )
5605: AND new_cle.chr_id = p_new_chr_id

Line 5609: from OKC_K_LINES_B another_cle

5605: AND new_cle.chr_id = p_new_chr_id
5606: AND orig_lnk_cim.cle_id = p_orig_lnk_cle_id
5607: AND orig_lnk_cim.jtot_object1_code = 'OKX_COVASST'
5608: AND not exists (select null
5609: from OKC_K_LINES_B another_cle
5610: where another_cle.orig_system_id1 = new_cle.orig_system_id1
5611: and another_cle.lse_id = new_cle.lse_id
5612: and another_cle.chr_id = new_cle.chr_id
5613: and another_cle.id <> new_cle.id);

Line 5619: from okc_k_lines_b cov_ast_cleb,

5615: --Bug# 3877032 : CAP AMNT
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

Line 5633: from okc_k_lines_b fin_ast_cleb,

5629: and cov_ast_cim.jtot_object1_code = 'OKX_COVASST'
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'

Line 5772: p_from_line_id IN OKC_K_LINES_B.ID%TYPE

5768: x_return_status OUT NOCOPY VARCHAR2,
5769: x_msg_count OUT NOCOPY NUMBER,
5770: x_msg_data OUT NOCOPY VARCHAR2,
5771: p_to_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
5772: p_from_line_id IN OKC_K_LINES_B.ID%TYPE
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

Line 5774: CURSOR line_style_csr(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS

5770: x_msg_data OUT NOCOPY VARCHAR2,
5771: p_to_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
5772: p_from_line_id IN OKC_K_LINES_B.ID%TYPE
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

Line 5778: okc_k_lines_b cle

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
5782: AND lse.lse_type = G_TLS_TYPE;

Line 5831: okc_k_lines_b line

5827: rel.object1_id1,
5828: rel.object1_id2,
5829: rel.jtot_object1_code
5830: FROM okc_k_rel_objs rel,
5831: okc_k_lines_b line
5832: WHERE rty_code = 'OKLSRV'
5833: AND rel.cle_id is not null
5834: AND rel.jtot_object1_code = 'OKL_COV_PROD'
5835: AND rel.cle_id = line.id

Line 5841: FROM okc_k_lines_b

5837:
5838: CURSOR copy_line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
5839: p_line_id OKC_K_LINES_V.ID%TYPE) IS
5840: SELECT id
5841: FROM okc_k_lines_b
5842: WHERE orig_system_id1 = p_line_id
5843: AND dnz_chr_id = p_chr_id;
5844:
5845: copy_service_failed EXCEPTION;

Line 5982: l_new_lnk_cle_id OKC_K_LINES_B.ID%TYPE;

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;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;

Line 5983: l_orig_lnk_cle_id OKC_K_LINES_B.ID%TYPE;

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;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;

Line 5988: l_cle_id OKC_K_LINES_B.ID%TYPE;

5984: l_new_lnk_cim_id OKC_K_ITEMS.ID%TYPE;
5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
5990: l_level NUMBER;
5991: l_orig_system_id1 OKC_K_LINES_B.ORIG_SYSTEM_ID1%TYPE;
5992:

Line 5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;

5985: l_jtot_object1_code OKC_K_ITEMS.JTOT_OBJECT1_CODE%TYPE;
5986: l_object1_id1 OKC_K_ITEMS.OBJECT1_ID1%TYPE;
5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
5990: l_level NUMBER;
5991: l_orig_system_id1 OKC_K_LINES_B.ORIG_SYSTEM_ID1%TYPE;
5992:
5993: lsx_cle_id_tbl klev_tbl_type;

Line 5991: l_orig_system_id1 OKC_K_LINES_B.ORIG_SYSTEM_ID1%TYPE;

5987: l_object1_id2 OKC_K_ITEMS.OBJECT1_ID2%TYPE;
5988: l_cle_id OKC_K_LINES_B.ID%TYPE;
5989: l_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE;
5990: l_level NUMBER;
5991: l_orig_system_id1 OKC_K_LINES_B.ORIG_SYSTEM_ID1%TYPE;
5992:
5993: lsx_cle_id_tbl klev_tbl_type;
5994: j NUMBER := 0;
5995: k NUMBER := 0;

Line 5999: CURSOR c_get_lty_code(p_top_line_id OKC_K_LINES_B.ID%TYPE) IS

5995: k NUMBER := 0;
5996: m NUMBER := 0;
5997: ln_old_chr_id OKC_K_HEADERS_B.ID%TYPE;
5998:
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,

Line 6004: okc_k_lines_b cle

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
6008: AND lse.lse_type = G_TLS_TYPE;

Line 6010: CURSOR c_get_tls_spk(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)

6006: AND cle.lse_id = lse.id
6007: AND lse.lse_parent_id is null
6008: AND lse.lse_type = G_TLS_TYPE;
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

Line 6014: okc_k_lines_b cle

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
6018: AND lse.lse_type = G_TLS_TYPE

Line 6027: FROM okc_k_lines_b

6023: SELECT level,
6024: id,
6025: dnz_chr_id,
6026: orig_system_id1
6027: FROM okc_k_lines_b
6028: CONNECT BY PRIOR id = cle_id
6029: START WITH id = p_cle_id;
6030:
6031: --cursor to fetch copied link lines for fixing

Line 6040: okc_k_lines_b new_lnk_cle

6036: new_lnk_cim.jtot_object1_code,
6037: new_lnk_cim.object1_id1,
6038: new_lnk_cim.object1_id2
6039: FROM okc_k_items new_lnk_cim,
6040: okc_k_lines_b new_lnk_cle
6041: WHERE new_lnk_cim.cle_id = new_lnk_cle.id
6042: AND new_lnk_cim.dnz_chr_id = new_lnk_cle.dnz_chr_id
6043: --Bug# 4899328
6044: -- To link cov assets when copying only sub-lines