SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001351'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ( SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001351')
UPDATE TR_REQUEST_DOC_DT SET PRICE =5279447, TOTAL_AMT =5279447 * QUANTITY WHERE REQ_DOC_ID =(SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001351') AND PRICE =5279446.5
UPDATE TR_REQUEST_DOC SET TOTAL_AMT =118441293 WHERE REQ_CODE ='PUR/2021/001351'