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

SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_ID FROM PL_REQUEST_PROCESS WHERE STATUS ='C' AND PROCESS_ID ='APPROVE') AND YEAR(CREATE_DT)=2023

AND REQ_ID NOT IN (SELECT REQ_ID FROM PL_TRADEDETAIL_HIST)