UPDATE po_headers_all
SET closed_code = 'OPEN' --FINALLY CLOSED
WHERE segment1 = '<PO_NUMBER>';
UPDATE po_lines_all
SET closed_flag=NULL,
closed_code = 'OPEN', --FINALLY CLOSED
closed_date = NULL, --01-AUG-19
closed_reason = NULL, --NULL
closed_by = NULL --1583
where po_line_id = <PO_LINE_ID>;
UPDATE po_line_locations_all
SET closed_code = 'OPEN', --FINALLY CLOSED
closed_date = NULL, --01-AUG-19
closed_by = NULL, --1583
closed_for_receiving_date = NULL, --01-AUG-19
closed_for_invoice_date = NULL --01-AUG-19
WHERE po_line_id = <PO_LINE_ID>;
No comments:
Post a Comment