47: AND wdd.shipped_quantity is null;
48: if (unshipped_count >0 ) then
49: select set_name
50: into l_ship_set_name
51: from oe_sets
52: where set_id = l_ship_set_id;
53: if (l_ship_set is null) then
54: l_ship_set := l_ship_set_name;
55: else l_ship_set := l_ship_set ||', '||l_ship_set_name;