Project

General

Profile

Download (508 Bytes)

2.1 UPDATE DMMS 000973.txt

Luc Tran Van, 07/06/2021 11:18 AM

 
1 

    		
  

  

    
      2
    
    
      
EXEC TL_SYSROLE_LIMIT_Auto '','ADV_PAY'


    		
  

  

    
      3
    
    
      
UPDATE TR_REQUEST_DOC SET DMMS_ID =(SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE  BRANCH_ID ='BRN000000001842') WHERE REQ_ID ='TRRD00000253031'


    		
  

  

    
      4
    
    
      
INSERT INTO PL_REQUEST_PROCESS (REQ_ID,PROCESS_ID,STATUS,ROLE_USER,BRANCH_ID,CHECKER_ID,APPROVE_DT,PARENT_PROCESS_ID,IS_LEAF,COST_ID,NOTES, IS_HAS_CHILD,DEP_ID)


    		
  

  

    
      5
    
    
      
					VALUES ('PLRD00000202005','DVDM','C','GDDV','DV0001','',NULL,'TC','N','','DM0000000000052',N'Chờ đơn vị đầu mối ngân sách phê duyệt','0','')