View: WMS_ZONE_LOCATORS_ALL_V

Product:	WMS - Warehouse Management
Description:	WMS Zones View to return all the subinventory, locator details of a zone.
Implementation/DBA Data:	APPS.WMS_ZONE_LOCATORS_ALL_V

View Text

SELECT WZL.ZONE_ID
, MIL.INVENTORY_LOCATION_ID LOCATOR_ID
, WZL.SUBINVENTORY_CODE
, WZL.ORGANIZATION_ID
, WZL.ENTIRE_SUB_FLAG
, WZL.LAST_UPDATE_DATE
, WZL.LAST_UPDATED_BY
, WZL.CREATION_DATE
, WZL.CREATED_BY
, WZL.LAST_UPDATE_LOGIN
FROM WMS_ZONE_LOCATORS WZL
, MTL_ITEM_LOCATIONS MIL
WHERE WZL.SUBINVENTORY_CODE = MIL.SUBINVENTORY_CODE
AND WZL.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND NVL(WZL.ENTIRE_SUB_FLAG
, 'N') = 'Y' UNION ALL SELECT WZL.ZONE_ID
, WZL.INVENTORY_LOCATION_ID LOCATOR_ID
, WZL.SUBINVENTORY_CODE
, WZL.ORGANIZATION_ID
, WZL.ENTIRE_SUB_FLAG
, WZL.LAST_UPDATE_DATE
, WZL.LAST_UPDATED_BY
, WZL.CREATION_DATE
, WZL.CREATED_BY
, WZL.LAST_UPDATE_LOGIN
FROM WMS_ZONE_LOCATORS WZL
WHERE NVL(WZL.ENTIRE_SUB_FLAG
, 'N') = 'N'

Columns