DECLARE @REQ_ID VARCHAR(20) = 'PLRD00000206101'
SELECT TB.TRADE_ID,
    TB.TOTAL_AMT AS TOTAL_AMT_EXE,
		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)
    -
    (SELECT ISNULL(SUM(DDT.TOTAL_AMT),0)
    FROM dbo.PL_REQUEST_DOC_DT DDT
    LEFT JOIN dbo.PL_REQUEST_DOC DOC ON DDT.REQ_ID = DOC.REQ_ID
    WHERE DOC.PROCESS_ID NOT IN ('','SIGN','APPNEW','REJECT','APPROVE','SETTLMENT')
    AND doc.REQ_ID <> @REQ_ID
    AND DDT.TRADE_ID = TB.TRADE_ID)
    -
    (SELECT ISNULL(SUM(DDT.TOTAL_AMT),0)
    FROM dbo.PL_REQUEST_TRANSFER DDT
    LEFT JOIN dbo.PL_REQUEST_DOC DOC ON DDT.REQ_DOC_ID = DOC.REQ_ID
    WHERE DOC.PROCESS_ID NOT IN ('','SIGN','APPNEW','REJECT','APPROVE','SETTLMENT')
    AND doc.REQ_ID <> @REQ_ID
    AND DDT.FR_TRADE_ID = TB.TRADE_ID) AS TOTAL_AMT_REMAIN,
		ISNULL(PLTF.TOTAL_AMT,0) AS TOTAL_TF
		FROM
    (
      SELECT TEMP1.TRADE_ID, TEMP1.REQ_ID, SUM(TEMP1.TOTAL_AMT) AS TOTAL_AMT FROM dbo.PL_REQUEST_DOC_DT TEMP1
      WHERE TEMP1.REQDT_TYPE='I' AND TEMP1.REQ_ID=@REQ_ID
      GROUP BY TEMP1.TRADE_ID,TEMP1.REQ_ID
    ) TB
		LEFT JOIN dbo.PL_TRADEDETAIL PT ON PT.TRADE_ID=TB.TRADE_ID
		LEFT JOIN dbo.PL_MASTER PM ON PM.PLAN_ID=PT.PLAN_ID
		LEFT JOIN 
    (
      SELECT SUM(TEMP2.TOTAL_AMT) AS TOTAL_AMT, TEMP2.FR_TRADE_ID, TEMP2.REQ_DOC_ID FROM dbo.PL_REQUEST_TRANSFER TEMP2
      GROUP BY TEMP2.FR_TRADE_ID, TEMP2.REQ_DOC_ID
		) PLTF ON PLTF.FR_TRADE_ID=PT.TRADE_ID AND PLTF.REQ_DOC_ID=TB.REQ_ID