2.2 SAO KE NGAN SACH DANG DIEU CHUYEN CHUA HOAN TAT.txt
| 1 |
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 , |
|---|---|
| 2 |
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 |
| 3 |
INNER JOIN PL_TRADEDETAIL B ON A.FR_TRADE_ID = B.TRADE_ID |
| 4 |
INNER JOIN CM_GOODS C ON A.FR_GOOD_ID =C.GD_ID |
| 5 |
INNER JOIN PL_MASTER D ON A.FR_PLAN_ID = D.PLAN_ID |
| 6 |
INNER JOIN CM_BRANCH E ON A.FR_BRN_ID = E.BRANCH_ID |
| 7 |
INNER JOIN CM_DEPARTMENT F ON A.FR_DEP_ID = F.DEP_ID |
| 8 |
INNER JOIN PL_REQUEST_DOC G ON A.REQ_DOC_ID = G.REQ_ID |
| 9 |
WHERE A.REQ_DOC_ID NOT IN (SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID = 'APPROVE') |
| 10 |
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 |
| 11 |
---20211013 |