摘要：
现有量= 可用量+保留量；1.现有量 --批次 CURSOR c_lot_number(l_organization_id NUMBER) IS SELECT mln.lot_number, mln.expiration_date FROM mtl_lot_numbers mln WHERE mln.inventory_item_id = p_inventory_item_id -- AND mln.status_id = 1 --有效合格批次 AND mln.organization_id = l... 阅读全文
