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;
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;