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_LPN_FOR_RULE

Source

View Text - Preformatted


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

View Text - HTML Formatted

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