190:
191: CURSOR get_item_number_csr(p_item_id NUMBER) IS
192: SELECT DISTINCT concatenated_segments item_number,
193: description
194: FROM mtl_system_items_kfv
195: WHERE inventory_item_id = p_item_id;
196:
197: CURSOR get_claim_number_csr(p_claim_id NUMBER) IS
198: SELECT claim_number
459: END IF;
460: --Get the item description
461: SELECT DISTINCT description
462: INTO l_item_description
463: FROM mtl_system_items_kfv
464: WHERE inventory_item_id = l_txn_line_tbl(i).Inventory_Item_Id;
465: EXCEPTION
466: WHEN NO_DATA_FOUND THEN
467: ROLLBACK TO CREATE_CLAIMS_PVT;