SELECT TB.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))/COUNT(TB.TRADE_ID)
    -
    (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 <> 'PLRD00000206101'
    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 <> 'PLRD00000206101'
    AND DDT.FR_TRADE_ID = TB.TRADE_ID) AS TOTAL_AMT_REMAIN,
		SUM(ISNULL(PLTF.TOTAL_AMT,0)) AS TOTAL_TF
		FROM dbo.PL_REQUEST_DOC_DT 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 dbo.PL_REQUEST_TRANSFER PLTF ON PLTF.FR_BRN_ID=PM.BRANCH_ID AND PLTF.FR_TRADE_ID=PT.TRADE_ID AND PLTF.REQ_DOC_ID=TB.REQ_ID
		WHERE TB.REQDT_TYPE='I' AND TB.REQ_ID='PLRD00000206101'
		GROUP BY TB.TRADE_ID