DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

SELECT * FROM PL_REQUEST_DOC A

LEFT JOIN dbo.PL_REQUEST_PROCESS PLRP ON PLRP.REQ_ID=A.REQ_ID AND PLRP.STATUS = 'C' AND (PLRP.PROCESS_ID = 'DVCM' AND EXISTS(

      SELECT pc.COST_ID FROM PL_COSTCENTER pc

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

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

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

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

      WHERE (pc.DVDM_ID = PLRP.DVDM_ID OR PLRP.DVDM_ID IS NULL OR PLRP.DVDM_ID = '')

      AND (tu1.TLNANME = 'thaomtt' OR tsrm.TLNAME = 'thaomtt')))

      WHERE A.REQ_CODE = '0001/2023/TTr-0692103'