1163:
1164: CURSOR c1
1165: IS
1166: SELECT mtl.NAME
1167: FROM okx_system_items_v mtl,
1168: okx_cust_prod_v cp
1169: WHERE mtl.id1 = cp.inventory_item_id
1170: AND mtl.organization_id = p_inv_org_id
1171: AND cp.customer_product_id = p_object_id;
1260: IS
1261: CURSOR l_service_csr
1262: IS
1263: SELECT NAME
1264: FROM okx_system_items_v mtl,
1265: okc_k_items itm
1266: WHERE mtl.id1 = itm.object1_id1
1267: AND mtl.id2 = itm.object1_id2
1268: AND itm.cle_id = p_line_id
1267: AND mtl.id2 = itm.object1_id2
1268: AND itm.cle_id = p_line_id
1269: AND itm.dnz_chr_id = p_contract_id;
1270:
1271: l_service_name okx_system_items_v.NAME%TYPE;
1272: BEGIN
1273: OPEN l_service_csr;
1274:
1275: FETCH l_service_csr