Project

General

Profile

Download (279 Bytes)

Debug.txt

Luc Tran Van, 11/22/2022 11:14 AM

 
1 
SELECT ISNULL(SUM(DDT.TOTAL_AMT),0)
2 
        FROM dbo.PL_REQUEST_DOC_DT DDT
3 
        LEFT JOIN dbo.PL_REQUEST_DOC DOC ON DDT.REQ_ID = DOC.REQ_ID
4 
        WHERE DOC.PROCESS_ID NOT IN ('','SIGN','APPNEW','REJECT','APPROVE','SETTLMENT')
5 
        AND DDT.TRADE_ID = 'PLT000000283388'