UPDATE

                INVST_TRST_TRD ITT

                SET (ITT.NET_AMT, ITT.PRICE, ITT.REALISED_PL) =

                (SELECT ISA.NET_AMT, ISA.B_SUM_PRC, ISA.REALISED_PL

                FROM INVST_SPA_AWDATA ISA

                WHERE

                ISA.SEC_CD  = isa_sec_cd AND

                ISA.CLIENT_CD   = ITT.CLIENT_CD AND

                ISA.DSCR_CD = ITT.DSCR_CD AND

                ISA.VALUE_DT    = ITT.VALUE_DT

                )

                WHERE

                ITT.TRD_NO  = itt_trd_no AND

                ITT.CLIENT_CD   = itt_client_cd AND

                ITT.DSCR_CD = itt_dscr_cd AND

                ITT.VALUE_DT    = itt_value_dt

                ;