Project

General

Profile

Bug #616

Phiếu đi sai quy trình : Phải đưa ĐMMS về HO và bổ sung GĐK vào quyy trình phê duyệt.

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

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

0%

Estimated time:

Description

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000278'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251278'
--SELECT * FROM CM_BRANCH WHERE BRANCH_ID ='BRN000000000395'
--SELECT * FROM CM_DMMS WHERE BRANCH_ID ='BRN000000000395'
--UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = BRANCH_CREATE,DMMS_ID ='DMMS00000000010' WHERE REQ_CODE ='PUR/2020/000493'
EXEC PL_PROCESS_CURRENT_SEARCH 'TRRD00000251278','LUCTV','PYCMS'
UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000001', PROCESS_ID ='DMMS' WHERE REQ_CODE ='PUR/2020/000278'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', NOTES =N'Chờ đầu mối mua sắm đã phê duyệt' WHERE ID ='4595'
UPDATE PL_REQUEST_PROCESS SET STATUS ='U' WHERE ID ='6064'
INSERT PL_REQUEST_PROCESS SELECT REQ_ID ,'GDK_PYC', 'U', 'GDK' ,BRANCH_ID ,'', NULL, PARENT_PROCESS_ID, IS_LEAF ,COST_ID, DVDM_ID, N'Chờ giám đốc khối phê duyệt', IS_HAS_CHILD, DEP_ID FROM PL_REQUEST_PROCESS WHERE ID ='4595'

History

#1 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000278'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251278'
--SELECT * FROM CM_BRANCH WHERE BRANCH_ID ='BRN000000000395'
--SELECT * FROM CM_DMMS WHERE BRANCH_ID ='BRN000000000395'
--UPDATE TR_REQUEST_DOC SET BRANCH_DVMS = BRANCH_CREATE,DMMS_ID ='DMMS00000000010' WHERE REQ_CODE ='PUR/2020/000493'
EXEC PL_PROCESS_CURRENT_SEARCH 'TRRD00000251278','LUCTV','PYCMS'
UPDATE TR_REQUEST_DOC SET DMMS_ID ='DMMS00000000001', PROCESS_ID ='DMMS' WHERE REQ_CODE ='PUR/2020/000278'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C', NOTES =N'Chờ đầu mối mua sắm đã phê duyệt' WHERE ID ='4595'
UPDATE PL_REQUEST_PROCESS SET STATUS ='U' WHERE ID ='6064'
INSERT PL_REQUEST_PROCESS SELECT REQ_ID ,'GDK_PYC', 'U', 'GDK' ,BRANCH_ID ,'', NULL, PARENT_PROCESS_ID, IS_LEAF ,COST_ID, 'DM0000000000015', N'Chờ giám đốc khối phê duyệt', IS_HAS_CHILD, DEP_ID FROM PL_REQUEST_PROCESS WHERE ID ='4595'

#2 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF