Project

General

Profile

2.0 TRANSFER PUR 2021 1425 VE THUONG HIEU TRUYEN THONG.txt

Luc Tran Van, 08/18/2021 05:12 PM

 
1
UPDATE TR_REQUEST_DOC SET DMMS_ID ='DM0000000000004' WHERE REQ_ID ='TRRD00000253483'
2
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID ='TRRD00000253483'
3
DELETE FROM PL_PROCESS WHERE ID ='160278'
4
SELECT * FROM CM_HANGHOA WHERE HH_ID NOT IN
5
(SELECT HH_ID FROM CM_HANGHOA_DVCM)
6
SELECT * FROM  CM_HANGHOA_DVCM WHERE DVCM_ID IS NULL OR DVCM_ID=''