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;
取消的PO行重新打开
最新推荐文章于 2022-01-15 14:00:02 发布