WMS item与LPN的关系

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博客 ” ，链接：http://blog.itpub.net/13387766/viewspace-758287/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/13387766/viewspace-758287/