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_SPLIT_ASSET_PVT dependencies on OKC_K_ITEMS

Line 4162: okc_k_items model_cim,

4158: SELECT mtl.serial_number_control_code,
4159: mtl.inventory_item_id,
4160: mtl.organization_id
4161: FROM mtl_system_items mtl,
4162: okc_k_items model_cim,
4163: okc_k_lines_b model_cle,
4164: okc_line_styles_b model_lse
4165: WHERE model_cim.object1_id2 = TO_CHAR(mtl.organization_id)
4166: AND model_cim.object1_id1 = mtl.inventory_item_id

Line 4690: okc_k_items ib_cim,

4686: csi.install_location_type_code, --hz_party_sites, hz_locations
4687: csi.instance_number
4688: FROM csi_item_instances csi,
4689: csi_instance_statuses csi_inst_sts,
4690: okc_k_items ib_cim,
4691: okc_k_lines_b ib_cle,
4692: okc_line_styles_b ib_lse,
4693: okc_k_lines_b inst_cle,
4694: okc_line_styles_b inst_lse,

Line 5014: okc_k_items ib_cim,

5010: CURSOR l_srl_no_count_csr(fin_ast_id IN NUMBER) IS
5011: SELECT
5012: COUNT(1)
5013: FROM csi_item_instances csi,
5014: okc_k_items ib_cim,
5015: okc_k_lines_b ib_cle,
5016: okc_line_styles_b ib_lse,
5017: okc_k_lines_b inst_cle,
5018: okc_line_styles_b inst_lse,

Line 5259: okc_k_items ib_cim,

5255: csi.install_location_id,
5256: --BUG# 3569441
5257: csi.install_location_type_code --hz_party_sites OR hz_loactions
5258: FROM csi_item_instances csi,
5259: okc_k_items ib_cim,
5260: okc_k_lines_b ib_cle,
5261: okc_line_styles_b ib_lse,
5262: okc_k_lines_b inst_cle,
5263: okc_line_styles_b inst_lse,

Line 5302: okc_k_items ib_cim,

5298: csi.install_location_id,
5299: --BUG# 3569441
5300: csi.install_location_type_code --hz_party_sites OR hz_locations
5301: FROM csi_item_instances csi,
5302: okc_k_items ib_cim,
5303: okc_k_lines_b ib_cle,
5304: okc_line_styles_b ib_lse,
5305: okc_k_lines_b inst_cle,
5306: okc_line_styles_b inst_lse,

Line 5879: FROM okc_k_items cim_fa,

5875: clet.name ASSET_NUMBER,
5876: kle.OEC ORIGINAL_COST,
5877: kle.OEC COST,
5878: cle.sts_code LINE_STATUS
5879: FROM okc_k_items cim_fa,
5880: okc_k_lines_b cle_fa,
5881: okc_line_styles_b lse_fa,
5882: okl_k_lines kle,
5883: okc_k_lines_tl clet,

Line 5915: okc_k_items lnk_srv_cim

5911: okc_k_rel_objs krel,
5912: okc_line_styles_b lnk_srv_lse,
5913: okc_statuses_b lnk_srv_sts,
5914: okc_k_lines_b lnk_srv_cleb,
5915: okc_k_items lnk_srv_cim
5916: WHERE oks_chrb.scs_code = 'SERVICE'
5917: AND oks_chrb.id = oks_cov_pd_cleb.dnz_chr_id
5918: AND oks_cov_pd_cleb.lse_id = oks_cov_pd_lse.id
5919: AND oks_cov_pd_lse.lty_code = 'COVER_PROD'

Line 7207: -- FUNCTION get_rec for: OKC_K_ITEMS_V

7203: x_msg_data,
7204: '_PVT');
7205: END Update_Split_Transaction;
7206: ---------------------------------------------------------------------------
7207: -- FUNCTION get_rec for: OKC_K_ITEMS_V
7208: ---------------------------------------------------------------------------
7209: FUNCTION get_cimv_rec (
7210: p_cle_id IN NUMBER,
7211: x_no_data_found OUT NOCOPY BOOLEAN

Line 7235: FROM Okc_K_Items_V

7231: CREATION_DATE,
7232: LAST_UPDATED_BY,
7233: LAST_UPDATE_DATE,
7234: LAST_UPDATE_LOGIN
7235: FROM Okc_K_Items_V
7236: WHERE okc_k_items_v.cle_id = p_cle_id;
7237: l_cimv_rec cimv_rec_type;
7238: BEGIN
7239: x_no_data_found := TRUE;

Line 7236: WHERE okc_k_items_v.cle_id = p_cle_id;

7232: LAST_UPDATED_BY,
7233: LAST_UPDATE_DATE,
7234: LAST_UPDATE_LOGIN
7235: FROM Okc_K_Items_V
7236: WHERE okc_k_items_v.cle_id = p_cle_id;
7237: l_cimv_rec cimv_rec_type;
7238: BEGIN
7239: x_no_data_found := TRUE;
7240: -- Get current database values

Line 7814: okc_k_items lnk_cim,

7810: lnk_target_cle.id,
7811: --Bug 3502142
7812: lnk_target_cle.cle_id
7813: FROM okc_k_lines_b lnk_cle,
7814: okc_k_items lnk_cim,
7815: okc_line_styles_b lnk_lse,
7816: okc_k_lines_b lnk_target_cle,
7817: okc_k_items lnk_target_cim,
7818: okc_line_styles_b lnk_target_lse

Line 7817: okc_k_items lnk_target_cim,

7813: FROM okc_k_lines_b lnk_cle,
7814: okc_k_items lnk_cim,
7815: okc_line_styles_b lnk_lse,
7816: okc_k_lines_b lnk_target_cle,
7817: okc_k_items lnk_target_cim,
7818: okc_line_styles_b lnk_target_lse
7819: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7820: AND lnk_cim.object1_id2 = '#'
7821: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'

Line 7843: okc_k_items lnk_cim,

7839: lnk_target_cle.id,
7840: --Bug 3502142
7841: lnk_target_cle.cle_id
7842: FROM okc_k_lines_b lnk_cle,
7843: okc_k_items lnk_cim,
7844: okc_line_styles_b lnk_lse,
7845: okc_k_lines_b lnk_target_cle,
7846: okc_k_items lnk_target_cim,
7847: okc_line_styles_b lnk_target_lse

Line 7846: okc_k_items lnk_target_cim,

7842: FROM okc_k_lines_b lnk_cle,
7843: okc_k_items lnk_cim,
7844: okc_line_styles_b lnk_lse,
7845: okc_k_lines_b lnk_target_cle,
7846: okc_k_items lnk_target_cim,
7847: okc_line_styles_b lnk_target_lse
7848: WHERE lnk_cim.object1_id1 = TO_CHAR(p_cle_id)
7849: AND lnk_cim.object1_id2 = '#'
7850: AND lnk_cim.jtot_object1_code = 'OKX_COVASST'

Line 8815: OKC_K_ITEMS cim,

8811: cle.id lnk_line_id
8812: FROM OKC_K_LINES_B cle,
8813: OKC_LINE_STYLES_B lse,
8814: OKC_STATUSES_B sts,
8815: OKC_K_ITEMS cim,
8816: OKC_K_LINES_B fin_asst_line
8817: WHERE cle.lse_id = lse.id
8818: AND lse.lty_code IN ('LINK_FEE_ASSET','LINK_SERV_ASSET','LINK_USAGE_ASSET')
8819: AND cle.dnz_chr_id = fin_asst_line.dnz_chr_id

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

9119: END IF;
9120:
9121: --update the number of items on model and fa lines
9122: --Bug#5559502 --Modification Start
9123: --Update number of items for ADDON record in OKC_K_ITEMS table
9124: IF l_lty_code IN ('ADD_ITEM','ITEM','FIXED_ASSET') THEN
9125: --Bug#5559502 --Modification End
9126: IF (l_cimv_rec.id IS NOT NULL) OR (l_cimv_rec.id <> OKL_API.G_MISS_NUM) THEN
9127: --dbms_output.put_line('cimv rec id'|| to_char(l_cimv_rec.id));

Line 10562: okc_k_items lnk_cim

10558: SELECT lnk_cleb.id lnk_cle_id
10559: FROM okc_k_lines_b lnk_cleb,
10560: okc_line_styles_b lnk_lseb,
10561: okc_statuses_b lnk_stsb,
10562: okc_k_items lnk_cim
10563: WHERE lnk_cleb.id = lnk_cim.cle_id
10564: AND lnk_cleb.dnz_chr_id = lnk_cim.dnz_chr_id
10565: AND lnk_cleb.lse_id = lnk_lseb.id
10566: AND lnk_lseb.lty_code IN

Line 13305: okc_k_items ib_cim,

13301: CURSOR get_instance_cle_csr (PInstanceId IN NUMBER, PTalId IN NUMBER, PChrId IN NUMBER) IS
13302: SELECT inst_cle.id inst_cle_id,
13303: ib_cle.id ib_cle_id
13304: FROM
13305: okc_k_items ib_cim,
13306: okc_k_lines_b ib_cle,
13307: okc_line_styles_b ib_lse,
13308: okc_k_lines_b inst_cle,
13309: okc_line_styles_b inst_lse,

Line 13340: okc_k_items ib_cim,

13336: CURSOR get_instance_cle_csr2 (PTarget_kle_id IN NUMBER, PChrId IN NUMBER) IS
13337: SELECT inst_cle.id inst_cle_id,
13338: ib_cim.id ib_cim_id
13339: FROM
13340: okc_k_items ib_cim,
13341: okc_k_lines_b ib_cle,
13342: okc_line_styles_b ib_lse,
13343: okc_k_lines_b inst_cle,
13344: okc_line_styles_b inst_lse,

Line 13364: l_ib_cim_id OKC_K_ITEMS.ID%TYPE;

13360: AND fa_cle.lse_id = fa_lse.id
13361: AND fa_lse.lty_code = 'FIXED_ASSET';
13362:
13363:
13364: l_ib_cim_id OKC_K_ITEMS.ID%TYPE;
13365: l_serialized VARCHAR2(1) DEFAULT okl_api.g_false;
13366:
13367: --cursor to get the serial numbers for serialized split asset components
13368: CURSOR comp_srl_csr (p_asd_id IN NUMBER) IS

Line 13996: FROM okc_k_items cim_model,

13992: SELECT cim_model.object1_id1,
13993: cim_model.object1_id2,
13994: cle_fa.dnz_chr_id,
13995: cle_fa.cle_id
13996: FROM okc_k_items cim_model,
13997: okc_k_lines_b cle_model,
13998: okc_line_styles_b lse_model,
13999: okc_k_lines_b cle_fa
14000: WHERE cim_model.dnz_chr_id = cle_model.dnz_chr_id

Line 14008: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;

14004: AND cle_model.cle_id = cle_fa.cle_id
14005: AND cle_model.dnz_chr_id = cle_fa.dnz_chr_id
14006: AND cle_fa.id = p_fa_line_id;
14007:
14008: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;
14009: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;
14010: l_chr_id NUMBER;
14011: l_cle_id NUMBER; --top line id
14012:

Line 14009: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;

14005: AND cle_model.dnz_chr_id = cle_fa.dnz_chr_id
14006: AND cle_fa.id = p_fa_line_id;
14007:
14008: l_object1_id1 OKC_K_ITEMS.object1_id1%TYPE;
14009: l_object1_id2 OKC_K_ITEMS.object1_id2%TYPE;
14010: l_chr_id NUMBER;
14011: l_cle_id NUMBER; --top line id
14012:
14013: l_parent_serialized VARCHAR2(1) DEFAULT OKL_API.G_FALSE;

Line 14669: FROM okc_k_items cim

14665:
14666: CURSOR c_cim(p_id IN NUMBER) IS
14667: SELECT id,
14668: cle_id
14669: FROM okc_k_items cim
14670: WHERE EXISTS
14671: (SELECT '1'
14672: FROM okl_txd_assets_b txd
14673: WHERE txd.target_kle_id = cim.cle_id

Line 14689: FROM OKC_K_ITEMS cim,

14685: cim.object1_id2,
14686: cim.id,
14687: cim.cle_id,
14688: cim.dnz_chr_id
14689: FROM OKC_K_ITEMS cim,
14690: OKC_K_LINES_B inst_item,
14691: OKC_LINE_STYLES_B inst_item_lse,
14692: OKC_K_LINES_B f_frm2,
14693: OKC_LINE_STYLES_B f_frm2_lse,

Line 14705: l_csi_id1 okc_k_items.object1_id1%TYPE;

14701: AND f_frm2.lse_id = f_frm2_lse.id
14702: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14703: AND fa.id = p_fa_line_id;
14704:
14705: l_csi_id1 okc_k_items.object1_id1%TYPE;
14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;

Line 14706: l_csi_id2 okc_k_items.object1_id2%TYPE;

14702: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14703: AND fa.id = p_fa_line_id;
14704:
14705: l_csi_id1 okc_k_items.object1_id1%TYPE;
14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;

Line 14707: l_csi_cim_id okc_k_items.id%TYPE;

14703: AND fa.id = p_fa_line_id;
14704:
14705: l_csi_id1 okc_k_items.object1_id1%TYPE;
14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14711:

Line 14708: l_csi_cle_id okc_k_items.cle_id%TYPE;

14704:
14705: l_csi_id1 okc_k_items.object1_id1%TYPE;
14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14711:
14712: l_csi_instance_id NUMBER;

Line 14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;

14705: l_csi_id1 okc_k_items.object1_id1%TYPE;
14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14711:
14712: l_csi_instance_id NUMBER;
14713:

Line 14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;

14706: l_csi_id2 okc_k_items.object1_id2%TYPE;
14707: l_csi_cim_id okc_k_items.id%TYPE;
14708: l_csi_cle_id okc_k_items.cle_id%TYPE;
14709: l_csi_chr_id okc_k_items.dnz_chr_id%TYPE;
14710: l_csi_number_of_items okc_k_items.number_of_items%TYPE;
14711:
14712: l_csi_instance_id NUMBER;
14713:
14714: l_trxv_rec trxv_rec_type;

Line 14786: FROM OKC_K_ITEMS cim,

14782: --Bug #2723498 :11.5.9 split asset by serial numbers
14783: CURSOR get_dup_inst_csr (p_asd_id IN NUMBER) IS
14784: SELECT f_frm2.id instance_id,
14785: inst_item.id ib_line_id
14786: FROM OKC_K_ITEMS cim,
14787: OKC_K_LINES_B inst_item,
14788: OKC_LINE_STYLES_B inst_item_lse,
14789: OKC_K_LINES_B f_frm2,
14790: OKC_LINE_STYLES_B f_frm2_lse,

Line 14804: FROM OKC_K_ITEMS cim_p,

14800: AND f_frm2_lse.lty_code = 'FREE_FORM2'
14801: AND fa.id = asd.target_kle_id
14802: AND asd.id = p_asd_id
14803: AND EXISTS (SELECT NULL
14804: FROM OKC_K_ITEMS cim_p,
14805: OKC_K_LINES_B inst_item_p,
14806: OKC_LINE_STYLES_B inst_item_lse_p,
14807: OKC_K_LINES_B f_frm2_p,
14808: OKC_LINE_STYLES_B f_frm2_lse_p,