Debug.txt
| 1 |
SELECT pc.COST_ID FROM PL_COSTCENTER pc |
|---|---|
| 2 |
LEFT JOIN PL_COSTCENTER_DT pcd ON pc.COST_ID = pcd.COST_ID |
| 3 |
LEFT JOIN CM_DEPARTMENT cd ON pcd.DEP_ID = cd.DEP_ID OR pcd.DEP_ID = cd.FATHER_ID |
| 4 |
LEFT JOIN TL_USER tu1 ON pcd.BRANCH_ID = tu1.TLSUBBRID AND cd.DEP_ID = tu1.SECUR_CODE |
| 5 |
LEFT JOIN TL_SYS_ROLE_MAPPING tsrm ON tsrm.TLNAME = tu1.TLNANME AND tsrm.DEP_ID = cd.DEP_ID AND pcd.BRANCH_ID = tsrm.BRANCH_ID |
| 6 |
WHERE (pc.DVDM_ID = 'DM0000000000077') |
| 7 |
AND tu1.TLNANME = 'nhanvt' |