Bug #502
[PYCMS xuất kho] PYCMS có chọn Hình Thức Mua Sắm là Xuất Kho (Nếu đúng thì ĐMMS phê duyệt xong là hoàn tất, nhưng phiếu lên tới GDK)
Start date:
10/21/2020
Due date:
% Done:
0%
Estimated time:
Description
PUR/2020/000264
PUR/2020/000189
PUR/2020/000167
History
#1 Updated by Luc Tran Van over 4 years ago
- File PUR 264.xlsx PUR 264.xlsx added
SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000264'
SELECT * FROM TR_REQUEST_DOC_DT WHERE REQ_DOC_ID ='TRRD00000251264'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251264'
SELECT * FROM CM_TRAN_TYPE WHERE TRN_TYPE ='TRN0000000006'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251264'
#2 Updated by Luc Tran Van over 4 years ago
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4666'
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='4667'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE ID ='4668'
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_COST_ID ='TRCC00000001154'
UPDATE TR_REQUEST_DOC SET PROCESS_ID ='APPROVE' WHERE REQ_CODE ='PUR/2020/000264'
#3 Updated by Luc Tran Van over 4 years ago
- File PUR 189.xlsx PUR 189.xlsx added