eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.WMS_ZONE_LOCATORS_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')