remove duplicate lines from a 4 table join

How do I remove duplicate lines from the output from the query.  First result set is what it produces and the second result set is what I want.
select '999|',
        p.part_no ||'|',
        m.manufacturer_no ||'|',
        p.unit_meas ||'|',
        p.contract || '|',
        p.part_staus ||'|',
        s.serial_tracking_code ||'|',
        s.lot_tracking_code ||'|',
        m.preferred_manufacturer ||'|',
        x.manu_part_no

from  inv_part_tab p ,  
      part_manuf_tab m ,
      part_cat s,
      part_no_tab x
     
where p.part_no = m.part_no
and   p.part_no = s.part_no