[Home] [Help]
View: WMS_ZONE_LPN_FOR_RULE
View Text
SELECT WZ.ZONE_NAME
, WZ.ZONE_ID
, WZL.SUBINVENTORY_CODE
, WZL.INVENTORY_LOCATION_ID
, WZL.ORGANIZATION_ID
, WLPN.LPN_ID
FROM WMS_ZONES_VL WZ
, WMS_ZONE_LOCATORS WZL
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE WZL.SUBINVENTORY_CODE = WLPN.SUBINVENTORY_CODE
AND WZL.ORGANIZATION_ID = WLPN.ORGANIZATION_ID
AND (WZL.ENTIRE_SUB_FLAG = 'Y' OR WZL.INVENTORY_LOCATION_ID = WLPN.LOCATOR_ID)
AND WZL.ZONE_ID = WZ.ZONE_ID
Columns
Name |
ZONE_NAME |
ZONE_ID |
SUBINVENTORY_CODE |
INVENTORY_LOCATION_ID |
ORGANIZATION_ID |
LPN_ID |