-- bknox use with caution

--**Use this information and these scripts at your own risk. As a condition of using these scripts and information from this site, you agree to hold harmless both the University of Arkansas Cooperative Extension Service and Bruce Knox for any problems that they may cause or other situations that may arise from their use, and that neither the Extension Service nor I will be held liable for those consequences. The scripts and information are provided "as is" without warranty, implied or otherwise. Limitation of liability will be the amount paid to the University of Arkansas specifically for this information. (It was free:) 

SET termout on

UPDATE fbgench
SET fgbench_status_ind = 'O'
WHERE fgbench_num = '&&POnumber'

UPDATE fgbencd
SET fgbencd_status = 'O'
WHERE fgbencd_num = '&&POnumber';

UPDATE fpbpohd
SET fpbpohd_closed_ind = 'N'
WHERE fpbpohd_code = '&&POnumber';

UPDATE FPBPOHD                       -- _closed_date code, thanks to Mohammed ElGergawi, Zayed University
SET fpbpohd_closed_date = NULL
WHERE FPBPOHD_CODE = '&&POnumber';

UPDATE fprpodt
SET fprpodt_closed_ind = NULL
WHERE fprpodt_pohd_code = '&&POnumber';

UPDATE fprpoda
SET fprpoda_closed_ind = NULL
WHERE fprpoda_pohd_code = '&&POnumber';