Oracle EBS-SQL (INV-1):库存货位列表.sql
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