Product: | WMS - Warehouse Management |
---|---|
Description: | Built on WMS_ZONE_LOCATORS |
Implementation/DBA Data: | APPS.WMS_ZONE_LOCATORS_V |
SELECT WZL.ORGANIZATION_ID
, WZT.ZONE_NAME
, WZL.ZONE_ID
, WZL.SUBINVENTORY_CODE
, WZL.INVENTORY_LOCATION_ID
, DECODE(WZL.INVENTORY_LOCATION_ID
, NULL
, NULL
, MIL.CONCATENATED_SEGMENTS) LOCATOR_NAME
, MIL.PICKING_ORDER
, MIL.DROPPING_ORDER
, MSI.SUBINVENTORY_TYPE
, MIL.INVENTORY_LOCATION_TYPE
, MIL.DISABLE_DATE LOCATOR_DISABLE_DATE
, MIL.LOCATOR_STATUS
, MSI.STATUS_ID SUBINVENTORY_STATUS
FROM WMS_ZONE_LOCATORS WZL
, MTL_ITEM_LOCATIONS_KFV MIL
, MTL_SECONDARY_INVENTORIES MSI
, WMS_ZONES_TL WZT
WHERE WZL.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID (+)
AND WZL.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND MSI.SECONDARY_INVENTORY_NAME = WZL.SUBINVENTORY_CODE
AND MSI.ORGANIZATION_ID = WZL.ORGANIZATION_ID
AND WZL.ZONE_ID = WZT.ZONE_ID
AND WZT.LANGUAGE = USERENV('LANG')