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.

[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on OKC_K_ITEMS

Line 4190: okc_k_items model_cim,

4186: SELECT mtl.serial_number_control_code,
4187: mtl.inventory_item_id,
4188: mtl.organization_id
4189: FROM mtl_system_items mtl,
4190: okc_k_items model_cim,
4191: okc_k_lines_b model_cle,
4192: okc_line_styles_b model_lse
4193: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)
4194: AND model_cim.object1_id1 = mtl.inventory_item_id

Line 4718: okc_k_items ib_cim,

4714: csi.install_location_type_code, --hz_party_sites, hz_locations
4715: csi.instance_number
4716: FROM csi_item_instances csi,
4717: csi_instance_statuses csi_inst_sts,
4718: okc_k_items ib_cim,
4719: okc_k_lines_b ib_cle,
4720: okc_line_styles_b ib_lse,
4721: okc_k_lines_b inst_cle,
4722: okc_line_styles_b inst_lse,

Line 5042: okc_k_items ib_cim,

5038: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS
5039: SELECT
5040: COUNT(1)
5041: FROM csi_item_instances csi,
5042: okc_k_items ib_cim,
5043: okc_k_lines_b ib_cle,
5044: okc_line_styles_b ib_lse,
5045: okc_k_lines_b inst_cle,
5046: okc_line_styles_b inst_lse,

Line 5287: okc_k_items ib_cim,

5283: csi.install_location_id,
5284: --BUG# 3569441
5285: csi.install_location_type_code --hz_party_sites OR hz_loactions
5286: FROM csi_item_instances csi,
5287: okc_k_items ib_cim,
5288: okc_k_lines_b ib_cle,
5289: okc_line_styles_b ib_lse,
5290: okc_k_lines_b inst_cle,
5291: okc_line_styles_b inst_lse,

Line 5330: okc_k_items ib_cim,

5326: csi.install_location_id,
5327: --BUG# 3569441
5328: csi.install_location_type_code --hz_party_sites OR hz_locations
5329: FROM csi_item_instances csi,
5330: okc_k_items ib_cim,
5331: okc_k_lines_b ib_cle,
5332: okc_line_styles_b ib_lse,
5333: okc_k_lines_b inst_cle,
5334: okc_line_styles_b inst_lse,

Line 5907: FROM okc_k_items cim_fa,

5903: clet.name ASSET_NUMBER,
5904: kle.OEC ORIGINAL_COST,
5905: kle.OEC COST,
5906: cle.sts_code LINE_STATUS
5907: FROM okc_k_items cim_fa,
5908: okc_k_lines_b cle_fa,
5909: okc_line_styles_b lse_fa,
5910: okl_k_lines kle,
5911: okc_k_lines_tl clet,

Line 5943: okc_k_items lnk_srv_cim

5939: okc_k_rel_objs krel,
5940: okc_line_styles_b lnk_srv_lse,
5941: okc_statuses_b lnk_srv_sts,
5942: okc_k_lines_b lnk_srv_cleb,
5943: okc_k_items lnk_srv_cim
5944: WHERE oks_chrb.scs_code = 'SERVICE'
5945: AND oks_chrb.id = oks_cov_pd_cleb.dnz_chr_id
5946: AND oks_cov_pd_cleb.lse_id = oks_cov_pd_lse.id
5947: AND oks_cov_pd_lse.lty_code = 'COVER_PROD'

Line 7260: -- FUNCTION get_rec for: OKC_K_ITEMS_V

7256: x_msg_data,
7257: '_PVT');
7258: END Update_Split_Transaction;
7259: ---------------------------------------------------------------------------
7260: -- FUNCTION get_rec for: OKC_K_ITEMS_V
7261: ---------------------------------------------------------------------------
7262: FUNCTION get_cimv_rec (
7263: p_cle_id IN NUMBER,
7264: x_no_data_found OUT NOCOPY BOOLEAN

Line 7288: FROM Okc_K_Items_V

7284: CREATION_DATE,
7285: LAST_UPDATED_BY,
7286: LAST_UPDATE_DATE,
7287: LAST_UPDATE_LOGIN
7288: FROM Okc_K_Items_V
7289: WHERE okc_k_items_v.cle_id = p_cle_id;
7290: l_cimv_rec cimv_rec_type;
7291: BEGIN
7292: x_no_data_found := TRUE;

Line 7289: WHERE okc_k_items_v.cle_id = p_cle_id;

7285: LAST_UPDATED_BY,
7286: LAST_UPDATE_DATE,
7287: LAST_UPDATE_LOGIN
7288: FROM Okc_K_Items_V
7289: WHERE okc_k_items_v.cle_id = p_cle_id;
7290: l_cimv_rec cimv_rec_type;
7291: BEGIN
7292: x_no_data_found := TRUE;
7293: -- Get current database values

Line 7867: okc_k_items lnk_cim,

7863: lnk_target_cle.id,
7864: --Bug 3502142
7865: lnk_target_cle.cle_id
7866: FROM okc_k_lines_b lnk_cle,
7867: okc_k_items lnk_cim,
7868: okc_line_styles_b lnk_lse,
7869: okc_k_lines_b lnk_target_cle,
7870: okc_k_items lnk_target_cim,
7871: okc_line_styles_b lnk_target_lse

Line 7870: okc_k_items lnk_target_cim,

7866: FROM okc_k_lines_b lnk_cle,
7867: okc_k_items lnk_cim,
7868: okc_line_styles_b lnk_lse,
7869: okc_k_lines_b lnk_target_cle,
7870: okc_k_items lnk_target_cim,
7871: okc_line_styles_b lnk_target_lse
7872: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7873: AND lnk_cim.object1_id2 = '#'
7874: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'

Line 7896: okc_k_items lnk_cim,

7892: lnk_target_cle.id,
7893: --Bug 3502142
7894: lnk_target_cle.cle_id
7895: FROM okc_k_lines_b lnk_cle,
7896: okc_k_items lnk_cim,
7897: okc_line_styles_b lnk_lse,
7898: okc_k_lines_b lnk_target_cle,
7899: okc_k_items lnk_target_cim,
7900: okc_line_styles_b lnk_target_lse

Line 7899: okc_k_items lnk_target_cim,

7895: FROM okc_k_lines_b lnk_cle,
7896: okc_k_items lnk_cim,
7897: okc_line_styles_b lnk_lse,
7898: okc_k_lines_b lnk_target_cle,
7899: okc_k_items lnk_target_cim,
7900: okc_line_styles_b lnk_target_lse
7901: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7902: AND lnk_cim.object1_id2 = '#'
7903: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'

Line 8868: OKC_K_ITEMS cim,

8864: cle.id lnk_line_id
8865: FROM OKC_K_LINES_B cle,
8866: OKC_LINE_STYLES_B lse,
8867: OKC_STATUSES_B sts,
8868: OKC_K_ITEMS cim,
8869: OKC_K_LINES_B fin_asst_line
8870: WHERE cle.lse_id = lse.id
8871: AND lse.lty_code IN ('LINK_FEE_ASSET','LINK_SERV_ASSET','LINK_USAGE_ASSET')
8872: AND cle.dnz_chr_id = fin_asst_line.dnz_chr_id

Line 9176: --Update number of items for ADDON record in OKC_K_ITEMS table

9172: END IF;
9173:
9174: --update the number of items on model and fa lines
9175: --Bug#5559502 --Modification Start
9176: --Update number of items for ADDON record in OKC_K_ITEMS table
9177: IF l_lty_code IN ('ADD_ITEM','ITEM','FIXED_ASSET') THEN
9178: --Bug#5559502 --Modification End
9179: IF (l_cimv_rec.id IS NOT NULL) OR (l_cimv_rec.id <> OKL_API.G_MISS_NUM) THEN
9180: --dbms_output.put_line('cimv rec id'|| to_char(l_cimv_rec.id));

Line 10615: okc_k_items lnk_cim

10611: SELECT lnk_cleb.id lnk_cle_id
10612: FROM okc_k_lines_b lnk_cleb,
10613: okc_line_styles_b lnk_lseb,
10614: okc_statuses_b lnk_stsb,
10615: okc_k_items lnk_cim
10616: WHERE lnk_cleb.id = lnk_cim.cle_id
10617: AND lnk_cleb.dnz_chr_id = lnk_cim.dnz_chr_id
10618: AND lnk_cleb.lse_id = lnk_lseb.id
10619: AND lnk_lseb.lty_code IN

Line 13358: okc_k_items ib_cim,

13354: CURSOR get_instance_cle_csr (PInstanceId IN NUMBER, PTalId IN NUMBER, PChrId IN NUMBER) IS
13355: SELECT inst_cle.id inst_cle_id,
13356: ib_cle.id ib_cle_id
13357: FROM
13358: okc_k_items ib_cim,
13359: okc_k_lines_b ib_cle,
13360: okc_line_styles_b ib_lse,
13361: okc_k_lines_b inst_cle,
13362: okc_line_styles_b inst_lse,

Line 13393: okc_k_items ib_cim,

13389: CURSOR get_instance_cle_csr2 (PTarget_kle_id IN NUMBER, PChrId IN NUMBER) IS
13390: SELECT inst_cle.id inst_cle_id,
13391: ib_cim.id ib_cim_id
13392: FROM
13393: okc_k_items ib_cim,
13394: okc_k_lines_b ib_cle,
13395: okc_line_styles_b ib_lse,
13396: okc_k_lines_b inst_cle,
13397: okc_line_styles_b inst_lse,

Line 13417: l_ib_cim_id OKC_K_ITEMS.ID%TYPE;

13413: AND fa_cle.lse_id = fa_lse.id
13414: AND fa_lse.lty_code = 'FIXED_ASSET';
13415:
13416:
13417: l_ib_cim_id OKC_K_ITEMS.ID%TYPE;
13418: l_serialized VARCHAR2(1) DEFAULT okl_api.g_false;
13419:
13420: --cursor to get the serial numbers for serialized split asset components
13421: CURSOR comp_srl_csr (p_asd_id IN NUMBER) IS

Line 14049: FROM okc_k_items cim_model,

14045: SELECT cim_model.object1_id1,
14046: cim_model.object1_id2,
14047: cle_fa.dnz_chr_id,
14048: cle_fa.cle_id
14049: FROM okc_k_items cim_model,
14050: okc_k_lines_b cle_model,
14051: okc_line_styles_b lse_model,
14052: okc_k_lines_b cle_fa
14053: WHERE cim_model.dnz_chr_id = cle_model.dnz_chr_id

Line 14061: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;

14057: AND cle_model.cle_id = cle_fa.cle_id
14058: AND cle_model.dnz_chr_id = cle_fa.dnz_chr_id
14059: AND cle_fa.id = p_fa_line_id;
14060:
14061: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;
14062: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;
14063: l_chr_id NUMBER;
14064: l_cle_id NUMBER; --top line id
14065:

Line 14062: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;

14058: AND cle_model.dnz_chr_id = cle_fa.dnz_chr_id
14059: AND cle_fa.id = p_fa_line_id;
14060:
14061: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;
14062: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;
14063: l_chr_id NUMBER;
14064: l_cle_id NUMBER; --top line id
14065:
14066: l_parent_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 14722: FROM okc_k_items cim

14718:
14719: CURSOR c_cim(p_id IN NUMBER) IS
14720: SELECT id,
14721: cle_id
14722: FROM okc_k_items cim
14723: WHERE EXISTS
14724: (SELECT '1'
14725: FROM okl_txd_assets_b txd
14726: WHERE txd.target_kle_id = cim.cle_id

Line 14742: FROM OKC_K_ITEMS cim,

14738: cim.object1_id2,
14739: cim.id,
14740: cim.cle_id,
14741: cim.dnz_chr_id
14742: FROM OKC_K_ITEMS cim,
14743: OKC_K_LINES_B inst_item,
14744: OKC_LINE_STYLES_B inst_item_lse,
14745: OKC_K_LINES_B f_frm2,
14746: OKC_LINE_STYLES_B f_frm2_lse,

Line 14758: l_csi_id1 okc_k_items.object1_id1%TYPE;

14754: AND f_frm2.lse_id = f_frm2_lse.id
14755: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14756: AND fa.id = p_fa_line_id;
14757:
14758: l_csi_id1 okc_k_items.object1_id1%TYPE;
14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;

Line 14759: l_csi_id2 okc_k_items.object1_id2%TYPE;

14755: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14756: AND fa.id = p_fa_line_id;
14757:
14758: l_csi_id1 okc_k_items.object1_id1%TYPE;
14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;

Line 14760: l_csi_cim_id okc_k_items.id%TYPE;

14756: AND fa.id = p_fa_line_id;
14757:
14758: l_csi_id1 okc_k_items.object1_id1%TYPE;
14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14764:

Line 14761: l_csi_cle_id okc_k_items.cle_id%TYPE;

14757:
14758: l_csi_id1 okc_k_items.object1_id1%TYPE;
14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14764:
14765: l_csi_instance_id NUMBER;

Line 14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;

14758: l_csi_id1 okc_k_items.object1_id1%TYPE;
14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14764:
14765: l_csi_instance_id NUMBER;
14766:

Line 14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;

14759: l_csi_id2 okc_k_items.object1_id2%TYPE;
14760: l_csi_cim_id okc_k_items.id%TYPE;
14761: l_csi_cle_id okc_k_items.cle_id%TYPE;
14762: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14763: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14764:
14765: l_csi_instance_id NUMBER;
14766:
14767: l_trxv_rec trxv_rec_type;

Line 14839: FROM OKC_K_ITEMS cim,

14835: --Bug #2723498 :11.5.9 split asset by serial numbers
14836: CURSOR get_dup_inst_csr (p_asd_id IN NUMBER) IS
14837: SELECT f_frm2.id instance_id,
14838: inst_item.id ib_line_id
14839: FROM OKC_K_ITEMS cim,
14840: OKC_K_LINES_B inst_item,
14841: OKC_LINE_STYLES_B inst_item_lse,
14842: OKC_K_LINES_B f_frm2,
14843: OKC_LINE_STYLES_B f_frm2_lse,

Line 14857: FROM OKC_K_ITEMS cim_p,

14853: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14854: AND fa.id = asd.target_kle_id
14855: AND asd.id = p_asd_id
14856: AND EXISTS (SELECT NULL
14857: FROM OKC_K_ITEMS cim_p,
14858: OKC_K_LINES_B inst_item_p,
14859: OKC_LINE_STYLES_B inst_item_lse_p,
14860: OKC_K_LINES_B f_frm2_p,
14861: OKC_LINE_STYLES_B f_frm2_lse_p,