Project

General

Profile

Download (457 Bytes)

1.4 GET DATA THANH TOAN TTCT 0005 2022 TTr 0692103.txt

Luc Tran Van, 10/31/2022 04:23 PM

 
1 
SELECT * FROM PL_REQUEST_DOC WHERE REQ_CODE='0005/2022/TTr-0692103'
2 
SELECT SUM(TOTAL_AMT)  FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000203297' AND PROCESS_ID = 'APPROVE'
3 

    		
  

  

    
      4
    
    
      
SELECT SUM(TOTAL_AMT)  FROM TR_REQUEST_DOC WHERE PL_REQ_ID ='PLRD00000203297' AND PROCESS_ID <> 'APPROVE'


    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
SELECT * FROM TR_REQ_PAYMENT


    		
  

  

    
      7
    
    
      
INNER JOIN TR_REQ_PAY_SERVICE ON TR_REQ_PAYMENT.REQ_PAY_ID =TR_REQ_PAY_SERVICE.REQ_PAY_ID


    		
  

  

    
      8
    
    
      
WHERE TR_REQ_PAY_SERVICE.EMP_ID ='PLRD00000203297'