Project

General

Profile

Download (2.01 KB)

2.5 GET DATA TO TRINH CHU TRUONG.txt

Luc Tran Van, 11/29/2022 11:22 AM

 
1 
DECLARE @REQ_ID VARCHAR(15)
2 
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0041/2022/TTr-0692105')
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 
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
7 
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
8 
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
9 
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
10 
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
11 
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
12 
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
13 
SELECT * FROM CM_GOODSTYPE
14 
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
15 
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID
16 

    		
  

  

    
      17
    
    
      

    		
  

  

    
      18
    
    
      

    		
  

  

    
      19
    
    
      
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0030/2022/TTr-06921045')


    		
  

  

    
      20
    
    
      
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID


    		
  

  

    
      21
    
    
      
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID


    		
  

  

    
      22
    
    
      
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID


    		
  

  

    
      23
    
    
      
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID


    		
  

  

    
      24
    
    
      
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID


    		
  

  

    
      25
    
    
      
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID


    		
  

  

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


    		
  

  

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


    		
  

  

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


    		
  

  

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


    		
  

  

    
      30
    
    
      
SELECT * FROM CM_GOODSTYPE


    		
  

  

    
      31
    
    
      
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID


    		
  

  

    
      32
    
    
      
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID