APPS.OKS_RENCPY_PVT dependencies on OKC_K_ITEMS

Line 1132: FROM okc_k_items

1128: WHERE id = p_to_cle_id;
1129:
1130: CURSOR c_cimv IS
1131: SELECT id
1132: FROM okc_k_items
1133: WHERE cle_id = p_from_cle_id;
1134:
1135: BEGIN
1136:

Line 1390: FROM okc_k_items

1386: WHERE id = p_id;
1387:
1388: CURSOR c_cim(p_cle_id IN NUMBER) IS
1389: SELECT id
1390: FROM okc_k_items
1391: WHERE cle_id = p_cle_id
1392: AND priced_item_yn = 'Y';
1393:
1394: BEGIN

Line 1501: FROM okc_k_items a, oks_k_lines_b b

1497: l_actual_coverage_id NUMBER;
1498:
1499: CURSOR c_item IS
1500: SELECT a.object1_id1, b.standard_cov_yn
1501: FROM okc_k_items a, oks_k_lines_b b
1502: WHERE a.cle_id = p_old_cle_id
1503: AND b.cle_id = p_old_cle_id;
1504:
1505: CURSOR l_ctr_csr (p_id NUMBER) IS

Line 2543: FROM OKC_K_ITEMS_V

2539: UOM_CODE,
2540: EXCEPTION_YN,
2541: NUMBER_OF_ITEMS,
2542: PRICED_ITEM_YN
2543: FROM OKC_K_ITEMS_V
2544: WHERE ID = p_cim_id;
2545:
2546: BEGIN
2547: OPEN c_cimv_rec;