APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 3312: FROM okc_k_items_v

3308: WHERE id = p_to_cle_id;
3309:
3310: CURSOR c_cimv IS
3311: SELECT id
3312: FROM okc_k_items_v
3313: WHERE cle_id = p_from_cle_id;
3314:
3315: BEGIN
3316: x_return_status := l_return_status;

Line 3369: SELECT nvl(object1_id1,-002) into l_b FROM okc_k_items

3365: SELECT nvl(orig_system_id1,-001) into l_a FROM okc_k_lines_b
3366: WHERE id = l_cimv_rec.cle_id;
3367:
3368: -- Getting the object1_id1 for original line id from where new line is copied
3369: SELECT nvl(object1_id1,-002) into l_b FROM okc_k_items
3370: WHERE cle_id = l_a;
3371:
3372: -- Getting the new line id
3373: SELECT nvl(id,-003) into l_c FROM okc_k_lines_b

Line 3779: FROM okc_k_items_v

3775: WHERE id = p_id;
3776:
3777: CURSOR c_cim(p_cle_id IN NUMBER) IS
3778: SELECT id
3779: FROM okc_k_items_v
3780: WHERE cle_id = p_cle_id
3781: AND priced_item_yn = 'Y';
3782:
3783: BEGIN

Line 3857: FROM okc_k_items_v

3853: l_actual_coverage_id NUMBER;
3854:
3855: CURSOR c_item IS
3856: SELECT object1_id1
3857: FROM okc_k_items_v
3858: WHERE cle_id = p_old_cle_id;
3859:
3860: Cursor l_ctr_csr (p_id Number) Is
3861: Select Counter_Group_id

Line 6797: FROM OKC_K_ITEMS_V

6793: UOM_CODE,
6794: EXCEPTION_YN,
6795: NUMBER_OF_ITEMS,
6796: PRICED_ITEM_YN
6797: FROM OKC_K_ITEMS_V
6798: WHERE ID = p_cim_id;
6799: BEGIN
6800: OPEN c_cimv_rec;
6801: FETCH c_cimv_rec