859: , p_item_id NUMBER ) RETURN VARCHAR2 IS
860:
861: CURSOR c_item_segments IS
862: SELECT concatenated_segments
863: FROM mtl_system_items_kfv
864: WHERE organization_id = p_org_id
865: AND inventory_item_id = p_item_id;
866:
867: c_item_seg_rec c_item_segments%ROWTYPE;