APPS.OKC_PRICE_PVT dependencies on OKC_K_ITEMS

Line 763: FROM okc_k_items

759: --NOTE: validate_covered_line_qty is to be called ONLY for (sub) lines with lse_id = 41 as we support only
760: -- this particular linestyle for 'OKX_COVLINE' object code
761: CURSOR c_get_quantity1 (b_cle_id NUMBER) is
762: SELECT object1_id1, number_of_items qty
763: FROM okc_k_items
764: WHERE cle_id = b_cle_id
765: AND dnz_chr_id = p_chr_id
766: AND jtot_object1_code = 'OKX_COVLINE';
767:

Line 773: FROM okc_k_items

769:
770: --gets the quantity of the parent non-service item line being pointed to
771: CURSOR c_get_quantity2 (b_cle_id NUMBER) is
772: SELECT number_of_items qty
773: FROM okc_k_items
774: WHERE cle_id = b_cle_id
775: AND dnz_chr_id = p_chr_id;
776:
777:

Line 3229: FROM okc_k_items

3225: ) IS
3226:
3227: Cursor l_item_csr(p_cle_id NUMBER,p_chr_id NUMBER) is
3228: SELECT object1_id1, object1_id2, jtot_object1_code, uom_code,number_of_items
3229: FROM okc_k_items
3230: where cle_id = p_cle_id and dnz_chr_id=p_chr_id;
3231:
3232: Cursor l_item_csr1(p_cle_id NUMBER) is
3233: SELECT number_of_items

Line 3234: FROM okc_k_items

3230: where cle_id = p_cle_id and dnz_chr_id=p_chr_id;
3231:
3232: Cursor l_item_csr1(p_cle_id NUMBER) is
3233: SELECT number_of_items
3234: FROM okc_k_items
3235: where Cle_id = p_cle_id and dnz_chr_id=p_chr_id;
3236:
3237:
3238: --Bug 2543687

Line 3378: Update okc_k_items

3374: If l_item_csr1%found and ((l_item_row1.number_of_items <> x_line_tbl(i).qty)
3375: and (l_item_row1.number_of_items is not null)) Then
3376: x_line_tbl(i).qty := l_item_row1.number_of_items ;
3377:
3378: Update okc_k_items
3379: set number_of_items=l_item_row1.number_of_items
3380: where cle_id = x_line_tbl(i).id
3381: and dnz_chr_id = p_chr_id;
3382: IF (l_debug = 'Y') THEN

Line 3605: from okc_k_items

3601: -- For covered lines get inventory id from lines
3602: If p_line_tbl(i).object_code = 'OKX_COVLINE' then
3603:
3604: select object1_id1 into inv_id1
3605: from okc_k_items
3606: where cle_id = p_line_tbl(1).id1;
3607:
3608: line_attr_rec.PRICING_ATTR_VALUE_FROM := inv_id1;
3609: OKC_PRICE_PUB.G_CONTRACT_INFO.inventory_item_id := inv_id1;

Line 6663: FROM okc_k_items

6659:
6660: BEGIN
6661: SELECT object1_id1, object1_id2, jtot_object1_code
6662: into l_id1,l_id2,l_jtot1_code
6663: FROM okc_k_items
6664: where cle_id = l_id_tbl(i) and dnz_chr_id=p_chr_id;
6665: --dbms_output.put_line('while again'||l_id_tbl(i));
6666: IF (l_debug = 'Y') THEN
6667: my_debug('16700 : select rowcount'||SQL%ROWCOUNT, 1);