Project

General

Profile

Download (347 Bytes)

2.4. SETUP IS HAS CHILD DVDM_DC.txt

Luc Tran Van, 10/19/2022 11:50 PM

 
1 
UPDATE  PL_REQUEST_PROCESS SET IS_HAS_CHILD='1'  WHERE REQ_ID IN (SELECT P.REQ_ID FROM PL_REQUEST_DOC P
2 
INNER JOIN PL_REQUEST_PROCESS R ON P.REQ_ID = R.REQ_ID AND R.PROCESS_ID ='DVDM_DC' AND R.STATUS ='U' AND R.DVDM_ID ='DM0000000000003'
3 

    		
  

  

    
      4
    
    
      
AND P.TOTAL_AMT >=10000000 AND YEAR(REQ_DT)=2022 AND P.PROCESS_ID <> 'REJECT')


    		
  

  

    
      5
    
    
      
AND PROCESS_ID ='DVDM_DC'