select inventory_location_id,
organization_id,
description,
subinventory_code,
segment1 inventory_location_code
from MTL_ITEM_LOCATIONS
order by subinventory_code,
inventory_location_code
select inventory_location_id,
organization_id,
description,
subinventory_code,
segment1 inventory_location_code
from MTL_ITEM_LOCATIONS
order by subinventory_code,
inventory_location_code
转载于:https://www.cnblogs.com/st-sun/p/3778036.html