取消的PO行重新打开

UPDATE PO_LINES_ALL T
   SET T.CANCEL_FLAG   = 'N',
       T.CANCELLED_BY  = NULL,
       T.CANCEL_DATE   = NULL,
       T.CANCEL_REASON = NULL,
       T.CLOSED_CODE   = 'OPEN',
       T.CLOSED_DATE   = NULL,
       T.CLOSED_REASON = NULL,
       T.CLOSED_BY     = NULL
 where T.PO_LINE_ID = 8758081;
 

UPDATE PO_LINE_LOCATIONS_ALL T
   SET T.CANCEL_FLAG        = NULL,
       T.CANCELLED_BY       = NULL,
       T.CANCEL_DATE        = NULL,
       T.CANCEL_REASON      = NULL,
       T.CLOSED_CODE        = 'OPEN',
       T.CLOSED_DATE        = NULL,
       T.CLOSED_REASON      = NULL,
       T.CLOSED_BY          = NULL,
       T.QUANTITY_CANCELLED = 0
 where T.PO_LINE_ID = 8758081;
 

UPDATE PO_DISTRIBUTIONS_ALL T
   SET T.QUANTITY_CANCELLED = 0, T.GL_CANCELLED_DATE = NULL
 where T.PO_LINE_ID = 8758081;