WMS item与LPN的关系:
select msi.segment1 item_num, wlpn.license_plate_number, wlc.quantity
from WMS_LPN_CONTENTS wlc,
WMS_LICENSE_PLATE_NUMBERS wlpn,
mtl_system_items_b msi
where wlc.organization_id = 1884
and wlc.inventory_item_id = 4572
and wlc.parent_lpn_id = wlpn.lpn_id
and wlc.organization_id = msi.organization_id
and wlc.inventory_item_id = msi.inventory_item_id
and wlpn.locator_id is not null;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13387766/viewspace-758287/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
开启EBS 帮助=>诊断
下一篇：
创建PO
请登录后发表评论
登录
全部评论
