Project

General

Profile

Download (450 Bytes)

DEBUG.txt

Luc Tran Van, 11/14/2022 10:04 AM

 
1 
SELECT TOP 1 ID FROM dbo.PL_REQUEST_PROCESS
2 
WHERE REQ_ID='PLRD00000205775'
3 
  AND (ROLE_USER='GDDV' OR ROLE_USER IN (SELECT ROLE_OLD FROM dbo.TL_SYS_ROLE_MAPPING WHERE ROLE_NEW='GDDV') )
4 
  AND ( DVDM_ID='DM0000000000052' OR 'DM0000000000052' IN ((SELECT PC.DVDM_ID FROM dbo.PL_COSTCENTER PC
5 
LEFT JOIN dbo.PL_COSTCENTER_DT PCD ON PCD.COST_ID = PC.COST_ID
6 
WHERE PCD.BRANCH_ID=PL_REQUEST_PROCESS.BRANCH_ID AND PCD.DEP_ID=PL_REQUEST_PROCESS.DEP_ID)))