Project

General

Profile

Support #784

Cập nhật dữ liệu do sai sót người dùng: PUR 296 (Update hình thức mua sắm của Tờ trình được link tới)

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
12/29/2020
Due date:
% Done:

0%

Estimated time:

Description

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT'
UPDATE PL_REQUEST_DOC SET REQ_CODE ='15/2020/TTr-KCNTT', REQ_DT ='2020-05-08' WHERE REQ_CODE ='0014/2020/TTr-0690907'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT')

UPDATE PL_REQUEST_DOC_DT SET TRADE_TYPE ='CDT' WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT') AND REQDT_ID ='PLRDD0000203356'

UPDATE PL_REQUEST_DOC_DT SET TRADE_TYPE ='CDT' WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT') AND REQDT_ID ='PLRDD0000203357'

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT'
UPDATE PL_REQUEST_DOC SET REQ_CODE ='15/2020/TTr-KCNTT', REQ_DT ='2020-05-08' WHERE REQ_CODE ='0014/2020/TTr-0690907'
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT')

UPDATE PL_REQUEST_DOC_DT SET TRADE_TYPE ='CDT', SUP_ID ='CMS000000251153' WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT') AND REQDT_ID ='PLRDD0000203356'

UPDATE PL_REQUEST_DOC_DT SET TRADE_TYPE ='CDT', SUP_ID ='CMS000001126227' WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='15/2020/TTr-KCNTT') AND REQDT_ID ='PLRDD0000203357'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF