SELECT RP.REQ_CODE AS N'SỐ TỜ TRÌNH',RP.TOTAL_AMT AS N'SỐ TIỀN TỜ TRÌNH', SUM(RP.SO_TIEN_THANH_TOAN) AS N'SỐ TIỀN THANH TOÁN THEO PO' FROM 
(
SELECT A.REQ_CODE, A.TOTAL_AMT,
B.REQ_CODE SO_PYCMS, ISNULL(B.TOTAL_AMT,0) AS GIA_TRI_PYCMS,
C.PO_CODE , ISNULL(C.TOTAL_AMT,0) AS GIA_TRI_PO,
ISNULL(DT.REQ_AMT,0) AS SO_TIEN_THANH_TOAN FROM PL_REQUEST_DOC A
LEFT JOIN TR_REQUEST_DOC B ON A.REQ_ID = B.PL_REQ_ID
LEFT JOIN TR_PO_MASTER C ON C.REQ_DOC_ID = B.REQ_ID
LEFT JOIN 
(
SELECT DISTINCT VT.REF_ID, F.REQ_AMT
FROM TR_REQ_ADVANCE_DT VT
LEFT JOIN TR_REQ_PAY_SCHEDULE E ON VT.REF_ID = E.REF_ID
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
WHERE ISNULL(F.AUTH_STATUS,'')='A'
) AS DT ON C.PO_ID = DT.REF_ID
WHERE A.PROCESS_ID ='APPROVE'
) RP
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT


SELECT RP.REQ_CODE AS N'SỐ TỜ TRÌNH',RP.TOTAL_AMT AS N'SỐ TIỀN TỜ TRÌNH', SUM(RP.SO_TIEN_THANH_TOAN) AS N'SỐ TIỀN THANH TOÁN THEO HỢP ĐỒNG' FROM 
(
SELECT A.REQ_CODE, A.TOTAL_AMT,
B.REQ_CODE SO_PYCMS, ISNULL(B.TOTAL_AMT,0) AS GIA_TRI_PYCMS,
C.CONTRACT_CODE , ISNULL(C.TOTAL_AMT,0) AS GIA_TRI_PO,
ISNULL(DT.REQ_AMT,0) AS SO_TIEN_THANH_TOAN FROM PL_REQUEST_DOC A
LEFT JOIN TR_REQUEST_DOC B ON A.REQ_ID = B.PL_REQ_ID
LEFT JOIN TR_CONTRACT C ON C.REQ_DOC_ID = B.REQ_ID
LEFT JOIN 
(
SELECT DISTINCT VT.REF_ID, F.REQ_AMT
FROM TR_REQ_ADVANCE_DT VT
LEFT JOIN TR_REQ_PAY_SCHEDULE E ON VT.REF_ID = E.REF_ID
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
WHERE ISNULL(F.AUTH_STATUS,'')='A'
) AS DT ON C.CONTRACT_ID = DT.REF_ID
WHERE A.PROCESS_ID ='APPROVE'
) RP
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT


SELECT RP.REQ_CODE AS N'SỐ TỜ TRÌNH',RP.TOTAL_AMT AS N'SỐ TIỀN TỜ TRÌNH', SUM(RP.SO_TIEN_THANH_TOAN) AS N'SỐ TIỀN THANH TOÁN TRỰC TIẾP' FROM 
(
SELECT A.REQ_CODE, A.TOTAL_AMT,ISNULL(F.REQ_AMT,0) AS SO_TIEN_THANH_TOAN
FROM PL_REQUEST_DOC A
LEFT JOIN TR_REQ_PAY_SERVICE E ON E.EMP_ID = A.REQ_ID
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
WHERE A.PROCESS_ID ='APPROVE' AND ISNULL(F.AUTH_STATUS,'')='A'
) RP
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT