Script for finally closed PO to open state

Before run the script backup your table data and run this script on test or development instance after successful testing use it on desired environment.

CREATE TABLE TAR_323232_779_plla

AS SELECT * FROM po_line_locations_all

where po_header_id= 323232;



CREATE TABLE TAR_25415_758_pla

AS SELECT * FROM po_lines_all

where po_header_id= 25415;



CREATE TABLE TAR_12155_323_pha

AS SELECT * FROM po_headers_all

where po_header_id = 12155;




-- Update

update po_line_locations_all

set closed_code='', closed_date=''

where po_header_id= 154222;



update po_lines_all

set closed_code='', closed_date=''

where po_header_id= 323232;



update po_headers_all

set closed_code='', closed_date=''

where po_header_id = 2323233;