Project

General

Profile

Download (453 Bytes)

2.2 UPDATE PRICE PUR 1351.txt

Luc Tran Van, 08/20/2021 05:13 PM

 
1 
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001351'
2 
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID IN ( SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/001351')
3 
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
4 
UPDATE TR_REQUEST_DOC SET TOTAL_AMT =118441293 WHERE REQ_CODE ='PUR/2021/001351'