|
1
|
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
|
|
2
|
(
|
|
3
|
SELECT A.REQ_CODE, A.TOTAL_AMT,
|
|
4
|
B.REQ_CODE SO_PYCMS, ISNULL(B.TOTAL_AMT,0) AS GIA_TRI_PYCMS,
|
|
5
|
C.PO_CODE , ISNULL(C.TOTAL_AMT,0) AS GIA_TRI_PO,
|
|
6
|
ISNULL(DT.REQ_AMT,0) AS SO_TIEN_THANH_TOAN FROM PL_REQUEST_DOC A
|
|
7
|
LEFT JOIN TR_REQUEST_DOC B ON A.REQ_ID = B.PL_REQ_ID
|
|
8
|
LEFT JOIN TR_PO_MASTER C ON C.REQ_DOC_ID = B.REQ_ID
|
|
9
|
LEFT JOIN
|
|
10
|
(
|
|
11
|
SELECT DISTINCT VT.REF_ID, F.REQ_AMT
|
|
12
|
FROM TR_REQ_ADVANCE_DT VT
|
|
13
|
LEFT JOIN TR_REQ_PAY_SCHEDULE E ON VT.REF_ID = E.REF_ID
|
|
14
|
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
|
|
15
|
WHERE ISNULL(F.AUTH_STATUS,'')='A'
|
|
16
|
) AS DT ON C.PO_ID = DT.REF_ID
|
|
17
|
WHERE A.PROCESS_ID ='APPROVE'
|
|
18
|
) RP
|
|
19
|
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT
|
|
20
|
|
|
21
|
|
|
22
|
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
|
|
23
|
(
|
|
24
|
SELECT A.REQ_CODE, A.TOTAL_AMT,
|
|
25
|
B.REQ_CODE SO_PYCMS, ISNULL(B.TOTAL_AMT,0) AS GIA_TRI_PYCMS,
|
|
26
|
C.CONTRACT_CODE , ISNULL(C.TOTAL_AMT,0) AS GIA_TRI_PO,
|
|
27
|
ISNULL(DT.REQ_AMT,0) AS SO_TIEN_THANH_TOAN FROM PL_REQUEST_DOC A
|
|
28
|
LEFT JOIN TR_REQUEST_DOC B ON A.REQ_ID = B.PL_REQ_ID
|
|
29
|
LEFT JOIN TR_CONTRACT C ON C.REQ_DOC_ID = B.REQ_ID
|
|
30
|
LEFT JOIN
|
|
31
|
(
|
|
32
|
SELECT DISTINCT VT.REF_ID, F.REQ_AMT
|
|
33
|
FROM TR_REQ_ADVANCE_DT VT
|
|
34
|
LEFT JOIN TR_REQ_PAY_SCHEDULE E ON VT.REF_ID = E.REF_ID
|
|
35
|
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
|
|
36
|
WHERE ISNULL(F.AUTH_STATUS,'')='A'
|
|
37
|
) AS DT ON C.CONTRACT_ID = DT.REF_ID
|
|
38
|
WHERE A.PROCESS_ID ='APPROVE'
|
|
39
|
) RP
|
|
40
|
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT
|
|
41
|
|
|
42
|
|
|
43
|
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
|
|
44
|
(
|
|
45
|
SELECT A.REQ_CODE, A.TOTAL_AMT,ISNULL(F.REQ_AMT,0) AS SO_TIEN_THANH_TOAN
|
|
46
|
FROM PL_REQUEST_DOC A
|
|
47
|
LEFT JOIN TR_REQ_PAY_SERVICE E ON E.EMP_ID = A.REQ_ID
|
|
48
|
LEFT JOIN TR_REQ_PAYMENT F ON E.REQ_PAY_ID = F.REQ_PAY_ID
|
|
49
|
WHERE A.PROCESS_ID ='APPROVE' AND ISNULL(F.AUTH_STATUS,'')='A'
|
|
50
|
) RP
|
|
51
|
GROUP BY RP.REQ_CODE, RP.TOTAL_AMT
|
|
52
|
|