APPROVE PR FROM DATABASE ENV.

SELECT RECID,* FROM PURCHREQTABLE A WHERE A.PURCHREQID ='201710001261 ' BEGIN TRANSACTION UPDATE PURCHREQLINE SET ISPREENCUMBRANCEREQUIRED=2, ISPURCHASEORDERGENERATIONMANUAL =1, REQUISITIONSTATUS=30 WHERE PURCHREQTABLE =5637183663 commit begin transaction update SOURCEDOCUMENTLINE set ACCOUNTINGSTATUS = 4 where recid in ( select recid from SOURCEDOCUMENTLINE a where RECID in (select SOURCEDOCUMENTLINE from PURCHREQLINE where PURCHREQTABLE =5637183663)) commit