Project

General

Profile

Download (405 Bytes)

lay_data.txt

Luc Tran Van, 03/14/2023 11:43 AM

 
1 
DECLARE @REQ_ID NVARCHAR(20) = NULL
2 
SELECT @REQ_ID = REQUEST_TEMPLATE_ID
3 
FROM dbo.CM_REQUEST_TEMPLATE
4 
WHERE REPORT_NO = '000186/2023/TTR-0690604'
5 

    		
  

  

    
      6
    
    
      
SELECT * FROM CM_REQUEST_TEMPLATE WHERE REQUEST_TEMPLATE_ID = @REQ_ID


    		
  

  

    
      7
    
    
      
SELECT * FROM dbo.CM_APPROVE_GROUP WHERE REQ_ID = @REQ_ID


    		
  

  

    
      8
    
    
      
SELECT * FROM dbo.CM_TEMPLATE_LOG WHERE REQ_ID = @REQ_ID


    		
  

  

    
      9
    
    
      
SELECT * FROM dbo.CM_SENT_TO_TEMPLATE WHERE TEMPLATE_ID = @REQ_ID