Bug #1605
14072025
Status:
New
Priority:
Normal
Assignee:
-
Start date:
07/14/2025
Due date:
% Done:
0%
Estimated time:
History
#1 Updated by Luc Tran Van 19 days ago
#2 Updated by Luc Tran Van 18 days ago
SELECT AUTH_STATUS FROM DELI_REQ_DELIVERY_MASTER drdm
GROUP BY drdm.AUTH_STATUS
#3 Updated by Luc Tran Van 18 days ago
DELI_REVEICE_DELIVERY_MASTER
#4 Updated by Luc Tran Van 18 days ago
SELECT * INTO ##bak_DELI_REVEICE_DELIVERY_MASTER FROM DELI_REVEICE_DELIVERY_MASTER
UPDATE DELI_REVEICE_DELIVERY_MASTER SET AUTH_STATUS = 'B' WHERE AUTH_STATUS IN ('B','C','D','V')
#5 Updated by Luc Tran Van 18 days ago
SELECT TOP 10 * FROM DELI_REVEICE_DELIVERY_MASTER WHERE AUTH_STATUS IN ('B','C','D','V') ORDER BY TO_DATE asc