---执行下面的语句就可以了. 我之前碰到这种状况就是这样处理的. 参数P_po_id是当前订单号码.
 update po_headers_all set APPROVED_FLAG='N' ,approved_date=null,authorization_status=NULL WHERE SEGMENT1=2080104;

  delete from po_headers_archive_all where segment1=2080104;

  delete from po_lines_archive_all where po_header_id=(select po_header_id from po_headers_all where segment1=2080104);

  delete from po_line_locations_archive_all where po_header_id=(select po_header_id from po_headers_all where segment1=2080104);

  delete from po_distributions_archive_all where po_header_id=(select po_header_id from po_headers_all where segment1=2080104);

   COMMIT;