Project

General

Profile

Download (304 Bytes)

Check bug.txt

Luc Tran Van, 08/16/2022 10:24 AM

 
1 
SELECT pc.DVDM_ID FROM TL_USER tu
2 
      LEFT JOIN PL_COSTCENTER_DT pcd ON tu.SECUR_CODE = pcd.DEP_ID AND tu.TLSUBBRID = pcd.BRANCH_ID
3 
      LEFT JOIN PL_COSTCENTER pc ON pcd.COST_ID = pc.COST_ID
4 
      LEFT JOIN CM_DVDM cd ON pc.DVDM_ID = cd.DVDM_ID
5 
      WHERE tu.TLNANME = 'tridq' AND cd.IS_DVDM = 1