UPDATE prdd
SET   prdd.AMT_APP = pth.AMT_APP,
      prdd.AMT_EXE=pth.AMT_EXE,
      prdd.AMT_ETM=pth.AMT_ETM,
      prdd.AMT_TF=pth.AMT_TF,
      prdd.AMT_RECEIVE_TF=pth.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
--LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prdd.TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
LEFT JOIN PL_TRADEDETAIL_HIST pth ON prd.REQ_ID = pth.REQ_ID AND pt.TRADE_ID = pth.TRADE_ID
WHERE prd.PROCESS_ID IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND pth.AMT_APP IS NOT NULL
-------------------------------------------------------------------
UPDATE prt
SET   prt.FR_AMT_APP=pth.AMT_APP,
      prt.FR_AMT_EXE=pth.AMT_EXE,
      prt.FR_AMT_ETM=pth.AMT_ETM,
      prt.FR_AMT_TF=pth.AMT_TF,
      prt.FR_AMT_RECEIVE_TF=pth.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
--LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prt.FR_TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
LEFT JOIN PL_TRADEDETAIL_HIST pth ON prd.REQ_ID = pth.REQ_ID AND pt.TRADE_ID = pth.TRADE_ID
WHERE prd.PROCESS_ID IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND pth.AMT_APP IS NOT NULL
--------------------------------------------------------------------------------
UPDATE prt
SET   prt.TO_AMT_APP=pth.AMT_APP,
      prt.TO_AMT_EXE=pth.AMT_EXE,
      prt.TO_AMT_ETM=pth.AMT_ETM,
      prt.TO_AMT_TF=pth.AMT_TF,
      prt.TO_AMT_RECEIVE_TF=pth.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
--LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prt.TO_TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
LEFT JOIN PL_TRADEDETAIL_HIST pth ON prd.REQ_ID = pth.REQ_ID AND pt.TRADE_ID = pth.TRADE_ID
WHERE prd.PROCESS_ID IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND pth.AMT_APP IS NOT NULL
------------------------------------------------------------------------------
UPDATE prdd
SET  prdd.AMT_APP = pt.AMT_APP,
      prdd.AMT_EXE=pt.AMT_EXE,
      prdd.AMT_ETM=pt.AMT_ETM,
      prdd.AMT_TF=pt.AMT_TF,
      prdd.AMT_RECEIVE_TF=pt.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
--LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prdd.TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
WHERE prd.PROCESS_ID NOT IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND prd.AUTH_STATUS = 'A'
--------------------------------------------------------------------------------------------
UPDATE prt
SET  prt.FR_AMT_APP = pt.AMT_APP,
      prt.FR_AMT_EXE=pt.AMT_EXE,
      prt.FR_AMT_ETM=pt.AMT_ETM,
      prt.FR_AMT_TF=pt.AMT_TF,
      prt.FR_AMT_RECEIVE_TF=pt.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
--LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prt.FR_TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
WHERE prd.PROCESS_ID NOT IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND prd.AUTH_STATUS = 'A'
 ------------------------------------------------------------------------------------------------
UPDATE prt
SET  prt.TO_AMT_APP = pt.AMT_APP,
      prt.TO_AMT_EXE=pt.AMT_EXE,
      prt.TO_AMT_ETM=pt.AMT_ETM,
      prt.TO_AMT_TF=pt.AMT_TF,
      prt.TO_AMT_RECEIVE_TF=pt.AMT_RECEIVE_TF
FROM PL_REQUEST_DOC prd
--LEFT JOIN PL_REQUEST_DOC_DT prdd ON prd.REQ_ID = prdd.REQ_ID
LEFT JOIN PL_REQUEST_TRANSFER prt ON prt.REQ_DOC_ID = prd.REQ_ID
LEFT JOIN PL_TRADEDETAIL pt ON prt.TO_TRADE_ID = pt.TRADE_ID --OR prt.FR_TRADE_ID = pt.TRADE_ID OR prt.TO_TRADE_ID = pt.TRADE_ID
LEFT JOIN PL_MASTER pm ON pt.PLAN_ID = pm.PLAN_ID
WHERE prd.PROCESS_ID NOT IN ('APPROVE','SETTLMENT')
      AND pm.YEAR = '2022'
      AND prd.AUTH_STATUS = 'A'