客户要求打印条码时打印数量为订单数量取整,例如:
PO数量为10 则打印 10张条码;
PL/SQL 实现方法如下:
SELECT L.*
FROM PO_LINES_ALL L,
(SELECT ROWNUM RN
FROM DUAL
CONNECT BY ROWNUM <=
(SELECT L.QUANTITY
FROM PO_LINES_ALL L
WHERE L.PO_LINE_ID = 4830)) R
WHERE L.PO_LINE_ID = 4830
客户要求打印条码时打印数量为订单数量取整,例如:
PO数量为10 则打印 10张条码;
PL/SQL 实现方法如下:
SELECT L.*
FROM PO_LINES_ALL L,
(SELECT ROWNUM RN
FROM DUAL
CONNECT BY ROWNUM <=
(SELECT L.QUANTITY
FROM PO_LINES_ALL L
WHERE L.PO_LINE_ID = 4830)) R
WHERE L.PO_LINE_ID = 4830