Project

General

Profile

Download (734 Bytes)

Lấy data PYCMS PUR-2023-000448.txt

Luc Tran Van, 03/21/2023 10:17 AM

 
1 
SELECT * FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448'
2 

    		
  

  

    
      3
    
    
      
SELECT * FROM TR_REQUEST_DOC_DT trdd where trdd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')


    		
  

  

    
      4
    
    
      

    		
  

  

    
      5
    
    
      
SELECT * FROM TR_REQUEST_DOC_PL_DT trdpd WHERE trdpd.REQ_DOC_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')


    		
  

  

    
      6
    
    
      

    		
  

  

    
      7
    
    
      
SELECT * FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448')


    		
  

  

    
      8
    
    
      

    		
  

  

    
      9
    
    
      
SELECT * FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT prp.ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID IN (SELECT trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE = 'PUR/2023/000448'))