DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_ITEMS_V

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 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