Project

General

Profile

Download (440 Bytes)

Check Bug2.txt

Luc Tran Van, 08/09/2022 04:32 PM

 
1 
SELECT TB.FR_TRADE_ID ,SUM(TB.TOTAL_AMT) AS TOTAL_AMT_EXE,
2 
SUM(ROUND(ISNULL(PT.AMT_APP,0),0) +  ROUND(ISNULL(PT.AMT_RECEIVE_TF,0),0) -  ROUND(ISNULL(PT.AMT_TF,0),0) - ROUND(ISNULL(PT.AMT_ETM,0),0)) AS TOTAL_AMT_REMAIN
3 
FROM dbo.PL_REQUEST_TRANSFER TB
4 
LEFT JOIN dbo.PL_TRADEDETAIL PT ON PT.TRADE_ID=TB.FR_TRADE_ID
5 
WHERE  TB.REQ_DOC_ID='PLRD00001160758' AND TB.FR_BRN_ID='DV0001' AND 'DEP000000000023'=TB.FR_DEP_ID
6 
GROUP BY TB.FR_TRADE_ID