View: WMS_ZONE_LPN_FOR_RULE

Product:	WMS - Warehouse Management
Description:
Implementation/DBA Data:	APPS.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