BATCHNO

SELECT ARTID,
       RANK() OVER(PARTITION BY ARTID ORDER BY ROWID) BATCHNO,
       RECVSEQID,
       1,
       30148,
       20130528,
       PRICE,
       TOTAL
  FROM T_SCM_PU_RECV_ART RART
 WHERE RECVSEQID = 3;