VIEW: APPS.WMS_ZONE_LOCATORS_ALL_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'