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