Project

General

Profile

Download (1.02 KB)

1.0 GET DATA TO TRINH CHU TRUONG.txt

Luc Tran Van, 10/21/2022 09:36 AM

 
1 
DECLARE @REQ_ID VARCHAR(15)
2 
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0175/2022/TTr-0690405')
3 
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
4 
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
5 
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
6 

    		
  

  

    
      7
    
    
      

    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID


    		
  

  

    
      10
    
    
      
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID


    		
  

  

    
      11
    
    
      
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID


    		
  

  

    
      12
    
    
      
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)


    		
  

  

    
      13
    
    
      
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)


    		
  

  

    
      14
    
    
      
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)


    		
  

  

    
      15
    
    
      
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)


    		
  

  

    
      16
    
    
      
SELECT * FROM CM_GOODSTYPE


    		
  

  

    
      17
    
    
      
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID


    		
  

  

    
      18
    
    
      
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID