Project

General

Profile

Download (1.22 KB)

2.2. GET DATA.txt

Luc Tran Van, 10/19/2022 12:15 AM

 
1 
SELECT P.REQ_ID, P.REQ_CODE, P.AUTH_STATUS, P.PROCESS_ID FROM PL_REQUEST_DOC P
2 
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='TGD' AND R.STATUS IN ('C','U')
3 
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT' AND P.PROCESS_ID <> 'TGD'
4 

    		
  

  

    
      5
    
    
      

    		
  

  

    
      6
    
    
      
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT P.REQ_ID  FROM PL_REQUEST_DOC P


    		
  

  

    
      7
    
    
      
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='TGD' AND R.STATUS IN ('C','U')


    		
  

  

    
      8
    
    
      
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT' AND P.PROCESS_ID <> 'TGD')


    		
  

  

    
      9
    
    
      

    		
  

  

    
      10
    
    
      

    		
  

  

    
      11
    
    
      
SELECT P.REQ_ID, P.REQ_CODE, P.AUTH_STATUS, P.PROCESS_ID FROM PL_REQUEST_DOC P


    		
  

  

    
      12
    
    
      
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='PTGDK_TT' AND R.STATUS IN ('C','U') AND R.DVDM_ID ='DM0000000000015'


    		
  

  

    
      13
    
    
      
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT'


    		
  

  

    
      14
    
    
      

    		
  

  

    
      15
    
    
      
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT P.REQ_ID FROM PL_REQUEST_DOC P


    		
  

  

    
      16
    
    
      
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID =R.REQ_ID AND R.PROCESS_ID ='PTGDK_TT' AND R.STATUS IN ('C','U') AND R.DVDM_ID ='DM0000000000015'


    		
  

  

    
      17
    
    
      
WHERE P.PROCESS_ID <> 'APPROVE' AND YEAR(CREATE_DT)=2022 AND  P.PROCESS_ID<> 'REJECT')