SELECT TB.FR_TRADE_ID ,SUM(TB.TOTAL_AMT) AS TOTAL_AMT_EXE,
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
FROM dbo.PL_REQUEST_TRANSFER TB
LEFT JOIN dbo.PL_TRADEDETAIL PT ON PT.TRADE_ID=TB.FR_TRADE_ID
WHERE  TB.REQ_DOC_ID='PLRD00001160758' AND TB.FR_BRN_ID='DV0001' AND 'DEP000000000023'=TB.FR_DEP_ID
GROUP BY TB.FR_TRADE_ID