1.6 SAO KE PHIEU YC MUA SAM 6 THANG DAU NAM 2021.txt
| 1 |
SELECT A.REQ_CODE AS N'Số phiếu yêu cầu', CONVERT(DATE, A.REQ_DT,103) AS NGAY_YEU_CAU,CONVERT(DATE, P.TRANFER_DT,103) AS NGAY_KIEM_SOAT , A.REQ_REASON AS N'Nội dung',X.SUM_MS_TOTRINH AS N'Chủ trương', X.SUM_MS_THUCTE AS N'Thực tế', A.USER_DVMS AS N'Người thực hiện mua sắm', BR.BRANCH_NAME AS N'Đơn vị yêu cầu', |
|---|---|
| 2 |
DP.DEP_NAME AS N'Phòng ban yêu cầu', |
| 3 |
CASE WHEN A.PROCESS_ID ='APPROVE' THEN N'Hoàn tất' |
| 4 |
WHEN A.PROCESS_ID ='DMMS' AND ISNULL(A.USER_DVMS,'') <> '' THEN N'Đang thực hiện' |
| 5 |
WHEN A.PROCESS_ID ='DMMS' AND ISNULL(A.USER_DVMS,'') = '' THEN N'Đang chờ điều phối' END AS N'Tình trạng thực hiện' |
| 6 |
FROM TR_REQUEST_DOC A |
| 7 |
INNER JOIN |
| 8 |
( |
| 9 |
SELECT REQ_DOC_ID,SUM(TOTAL_AMT) AS SUM_MS_THUCTE, SUM(TOTAL_AMT_ETM) AS SUM_MS_TOTRINH FROM TR_REQUEST_DOC_DT |
| 10 |
GROUP BY REQ_DOC_ID |
| 11 |
) X ON A.REQ_ID = X.REQ_DOC_ID |
| 12 |
INNER JOIN CM_BRANCH BR ON A.BRANCH_CREATE = BR.BRANCH_ID |
| 13 |
LEFT JOIN CM_DEPARTMENT DP ON A.DEP_CREATE = DP.DEP_ID |
| 14 |
INNER JOIN PL_REQUEST_PROCESS_CHILD P ON A.REQ_ID =P.REQ_ID |
| 15 |
WHERE CONVERT(DATE, P.TRANFER_DT, 103) >='2021-01-01' AND CONVERT(DATE, P.TRANFER_DT, 103) <='2021-05-31' |
| 16 |
AND P.TLNAME IN ('vanpt2','tanvt') AND TYPE_JOB ='KS'
|
| 17 |
ORDER BY BR.BRANCH_NAME |