FILE 1.1.txt
1 |
|
---|---|
2 |
UPDATE dbo.TR_REQUEST_COSTCENTER SET AUTH_STATUS='A' WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE='PUR/2020/00009806') AND COST_ID='DM0000000000004' |
3 |
UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='P' WHERE REQ_ID = (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE='PUR/2020/00009806') AND DVDM_ID='DM0000000000004' |