UPDATE NP N
SET (NP,NP_SOURCE,UPDATE_DATETIME)
      = (SELECT S.NP, S.NP_SOURCE,SYSDATE
         FROM TEMP_PRICE S
         WHERE S.ITEM_SID = N.ITEM_SID
         AND S.INDEX_SID = N.INDEX_SID
         AND S.TV_SID = N.TV_SID
         AND S.iRM = N.IRM)    
WHERE item_sid in ( select item_sid from temp_net_price);

UPDATE (SELECT N.NET_PRICE,N.NET_PRICE_SOURCE,UPDATE_DATETIME,
         S.NET_PRICE as NEW_NET_PRICE, S.NET_PRICE_SOURCE as   NEW_NET_PRICE_SOURCE,SYSDATE AS NEW_UPDATE_DATETIME
         FROM TEMP_NET_PRICE S, NET_PRICE N
         WHERE S.ITEM = N.ITEM
         AND S.INDEX = N.INDEX
         AND S.TREE = N.TREE
         AND S.IRM = N.IRM )    
SET NET_PRICE = NEW_NET_PRICE,
    NET_PRICE_SOURCE = NEW_NET_PRICE_SOURCE,    
    UPDATE_DATETIME = NEW_UPDATE_DATETIME;

UPDATE STATEMENT ()	[NULL]
 UPDATE ()	NET_PRICE
  HASH JOIN ()	[NULL]
   TABLE ACCESS (FULL)	TEMP_NET_PRICE_ANU
   TABLE ACCESS (FULL)	NET_PRICE