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
INNER JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID
LEFT JOIN CM_DEPARTMENT C ON A.DEP_CREATE = C.DEP_ID
WHERE A.PROCESS_ID <> 'APPROVE' AND A.AUTH_STATUS NOT IN ('E','R')