Translate update statement from MS SQL to Oracle

Hi All,

I am translating MS SQL procedure to Oracle/PL SQL procedure.

I need a help to translate the following update  to equivalent Oracle PL/SQL statement:

UPDATE #tmp

      SET change_row_nbr = t.change_row_nbr

     FROM #tmp

          JOIN (SELECT cn,

                       rn,

                       MIN(row_nbr)            AS change_row_nbr

                  FROM #tmp

                 WHERE cumul_cpr_qty >= cr_qty

                 GROUP BY cn,

                          rn

               )t

            ON #tmp.cn = t.cn

           AND #tmp.rn = t.rn

Thank you in advance.

Olivera