Document #393
SCRIPT xóa config hàng hóa với hạng mục ngân sách
Status:
Feedback
Priority:
Normal
Assignee:
-
Start date:
10/09/2020
Due date:
% Done:
0%
Estimated time:
Description
DELETE FROM dbo.CM_HANGHOA_GOODS
WHERE GD_ID IN (SELECT GD_ID FROM dbo.CM_GOODS WHERE GD_TYPE_ID='CP')
History
#1 Updated by Truong Nguyen Vu over 4 years ago
- Status changed from New to Feedback
#2 Updated by Luc Tran Van over 4 years ago
- File DATA PUR 2020 000201.xls DATA PUR 2020 000201.xls added
#3 Updated by Truong Nguyen Vu over 4 years ago
SET @REQ_ID= (SELECT REQ_ID FROM dbo.PL_REQUEST_DOC WHERE REQ_CODE='0053/2020/TTr-0690604')
UPDATE dbo.PL_REQUEST_DOC_DT SET TRADE_ID='',PLAN_ID='',GOODS_ID='GOO000001063100' WHERE REQ_ID=@REQ_ID
UPDATE dbo.PL_REQUEST_TRANSFER SET TO_GOOD_ID='GOO000001063100',TO_BRN_ID='DV0001',TO_DEP_ID='DEP000000000011' WHERE REQ_DOC_ID=@REQ_ID