1515: ,OOL.ORDER_QUANTITY_UOM
1516: ,OOL.ORDERED_QUANTITY)))
1517: INTO QTY
1518: FROM
1519: OE_ORDER_LINES_ALL OOL
1520: WHERE OPEN_FLAG = 'Y'
1521: AND VISIBLE_DEMAND_FLAG = 'Y'
1522: AND SHIPPED_QUANTITY IS NULL
1523: AND SHIP_FROM_ORG_ID = LV_ORG_ID