APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS

Line 3311: FROM okc_k_items_v

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

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

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

Line 3778: FROM okc_k_items_v

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

Line 3856: FROM okc_k_items_v

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

Line 6796: FROM OKC_K_ITEMS_V

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