Project

General

Profile

Download (468 Bytes)

Debug.txt

Luc Tran Van, 12/01/2022 01:51 PM

 
1 

    		
  

  

    
      2
    
    
      
SELECT * FROM PL_COSTCENTER pc


    		
  

  

    
      3
    
    
      
  LEFT JOIN PL_COSTCENTER_DT pcd ON pc.COST_ID = pcd.COST_ID


    		
  

  

    
      4
    
    
      
  LEFT JOIN CM_DEPARTMENT cd ON pcd.DEP_ID = cd.DEP_ID OR pcd.DEP_ID = cd.FATHER_ID


    		
  

  

    
      5
    
    
      
  LEFT JOIN TL_USER tu1 ON pcd.BRANCH_ID = tu1.TLSUBBRID AND cd.DEP_ID = tu1.SECUR_CODE


    		
  

  

    
      6
    
    
      
  LEFT JOIN TL_SYS_ROLE_MAPPING tsrm ON tsrm.DEP_ID = cd.DEP_ID AND pcd.BRANCH_ID = tsrm.BRANCH_ID


    		
  

  

    
      7
    
    
      
  WHERE (pc.DVDM_ID = 'DM0000000000077')


    		
  

  

    
      8
    
    
      
  AND (tu1.TLNANME = 'nhannt' OR tsrm.TLNAME = 'nhannt')