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

SELECT * FROM PL_REQUEST_PROCESS PLRP

      WHERE PLRP.REQ_ID='PLRD00000204964' 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

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

      AND tu1.TLNANME = 'nganhtk'))

      OR (PLRP.PROCESS_ID = 'DVDC' AND EXISTS(

      SELECT prt.REQ_TRANSFER_ID FROM PL_REQUEST_TRANSFER prt

      LEFT JOIN TL_USER tu1 ON prt.FR_BRN_ID = tu1.TLSUBBRID AND prt.FR_DEP_ID = tu1.SECUR_CODE

      WHERE prt.FR_BRN_ID = PLRP.BRANCH_ID AND prt.FR_DEP_ID = PLRP.DEP_ID AND prt.REQ_DOC_ID = PLRP.REQ_ID

      AND tu1.TLNANME = 'nganhtk'))

      OR PLRP.PROCESS_ID NOT IN ('DVCM','DVDC'))