2.1 SAO KE TO TRINH CHUA HOAN TAT.txt
| 1 |
SELECT A.REQ_CODE, A.REQ_DT AS NGAY_TRINH, A.REQ_REASON, A.REQ_CONTENT, A.REQ_NAME, A.TOTAL_AMT,A.MAKER_ID AS NGUOI_TAO, B.BRANCH_CODE, B.BRANCH_NAME, C.DEP_CODE, C.DEP_NAME FROM PL_REQUEST_DOC A |
|---|---|
| 2 |
INNER JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID |
| 3 |
LEFT JOIN CM_DEPARTMENT C ON A.DEP_CREATE = C.DEP_ID |
| 4 |
WHERE A.PROCESS_ID <> 'APPROVE' AND A.AUTH_STATUS NOT IN ('E','R')
|