SELECT B.TRADE_ID,C.GD_CODE, C.GD_NAME, E.BRANCH_CODE, E.BRANCH_NAME, F.DEP_CODE, F.DEP_NAME,  SUM(A.TOTAL_AMT) AS NS_DANG_DIEU_CHUYEN , SUM(B.AMT_APP) AS AMT_APP ,
SUM (B.AMT_ETM) AS AMT_ETM , SUM(B.AMT_EXE) AS AMT_EXE, SUM(B.AMT_RECEIVE_TF) AS AMT_RECEIVE_TF,SUM(B.AMT_TF) AS AMT_RECEIVE_TF, G.REQ_CODE FROM PL_REQUEST_TRANSFER A 
INNER JOIN PL_TRADEDETAIL B ON A.FR_TRADE_ID = B.TRADE_ID
INNER JOIN CM_GOODS C ON A.FR_GOOD_ID =C.GD_ID
INNER JOIN PL_MASTER D ON A.FR_PLAN_ID = D.PLAN_ID
INNER JOIN CM_BRANCH E ON A.FR_BRN_ID = E.BRANCH_ID
INNER JOIN CM_DEPARTMENT F ON A.FR_DEP_ID = F.DEP_ID
INNER JOIN PL_REQUEST_DOC G ON A.REQ_DOC_ID = G.REQ_ID
WHERE A.REQ_DOC_ID NOT IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID = 'APPROVE')
GROUP BY B.TRADE_ID,C.GD_CODE, C.GD_NAME, E.BRANCH_CODE, E.BRANCH_NAME, F.DEP_CODE, F.DEP_NAME, G.REQ_CODE
---20211013