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.

APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_ZONE_LOCATORS

Line 221: wms_zone_locators wzl,

217: cursor c_lpn_active_wzone_witem is
218: select wlpn.outermost_lpn_id
219: from wms_license_plate_numbers wlpn,
220: mtl_material_transactions_temp mmtt,
221: wms_zone_locators wzl,
222: wms_op_plan_instances wopi,
223: wms_op_operation_instances wooi,
224: wms_op_operation_instances wooi2
225: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)

Line 260: wms_zone_locators wzl,

256: cursor c_lpn_active_wzone_woitem is
257: select wlpn.outermost_lpn_id
258: from mtl_material_transactions_temp mmtt,
259: wms_license_plate_numbers wlpn,
260: wms_zone_locators wzl,
261: wms_op_plan_instances wopi,
262: wms_op_operation_instances wooi,
263: wms_op_operation_instances wooi2
264: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)

Line 365: wms_zone_locators wzl,

361: cursor c_lpn_comp_wzone_witem is
362: select wlpn.outermost_lpn_id
363: from wms_op_plan_instances_hist wopih,
364: wms_op_opertn_instances_hist wooih,
365: wms_zone_locators wzl,
366: wms_dispatched_tasks_history wdth,
367: wms_license_plate_numbers wlpn
368: where wzl.zone_id = l_pre_specified_zone_id
369: and wzl.subinventory_code = wlpn.subinventory_code

Line 407: wms_zone_locators wzl,

403: cursor c_lpn_comp_wzone_woitem is
404: select wlpn.outermost_lpn_id
405: from wms_op_plan_instances_hist wopih,
406: wms_op_opertn_instances_hist wooih,
407: wms_zone_locators wzl,
408: wms_dispatched_tasks_history wdth,
409: wms_license_plate_numbers wlpn
410: where wzl.zone_id = l_pre_specified_zone_id
411: and wzl.subinventory_code = wlpn.subinventory_code