4.6 XUAT SAO KE NS CHI PHI THANH TOAN THUC TE.txt
| 1 |
SELECT B.GD_CODE, B.GD_NAME, D.BRANCH_CODE, D.BRANCH_NAME, E.DEP_CODE, E.DEP_NAME, A.AMT_APP AS NS_APP,A.AMT_RECEIVE_TF AS NS_XIN, A.AMT_TF AS NS_CHO, A.AMT_ETM AS NS_SU_DUNG_DU_KIEN, A.AMT_EXE AS NGAN_SACH_THANH_TOAN FROM PL_TRADEDETAIL A |
|---|---|
| 2 |
INNER JOIN CM_GOODS B ON A.GOODS_ID = B.GD_ID |
| 3 |
INNER JOIN PL_MASTER C ON A.PLAN_ID =C.PLAN_ID |
| 4 |
INNER JOIN CM_BRANCH D ON C.BRANCH_ID = D.BRANCH_ID |
| 5 |
INNER JOIN CM_DEPARTMENT E ON C.DEPT_ID = E.DEP_ID |
| 6 |
WHERE A.TRADE_ID IN |
| 7 |
(SELECT TRADE_ID FROM TR_REQ_PAY_BUDGET |
| 8 |
WHERE REQ_PAY_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE AUTH_STATUS_KT ='A')) |
| 9 |
AND A.TRADE_ID IN |
| 10 |
(SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID IN(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE PROCESS_ID ='APPROVE')) |