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_LICENSE_PLATE_NUMBERS

Line 219: from wms_license_plate_numbers wlpn,

215: --
216: --
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,

Line 259: wms_license_plate_numbers wlpn,

255: --
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

Line 297: wms_license_plate_numbers wlpn,

293: --
294: cursor c_lpn_active_wozone_witem is
295: select wlpn.outermost_lpn_id
296: from mtl_material_transactions_temp mmtt,
297: wms_license_plate_numbers wlpn,
298: wms_op_plan_instances wopi,
299: wms_op_operation_instances wooi,
300: wms_op_operation_instances wooi2
301: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)

Line 331: wms_license_plate_numbers wlpn,

327: --
328: cursor c_lpn_active_wozone_woitem is
329: select wlpn.outermost_lpn_id
330: from mtl_material_transactions_temp mmtt,
331: wms_license_plate_numbers wlpn,
332: wms_op_plan_instances wopi,
333: wms_op_operation_instances wooi,
334: wms_op_operation_instances wooi2
335: where wlpn.lpn_context = decode(l_is_in_inventory, 'Y', 1, 3)

Line 367: wms_license_plate_numbers wlpn

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
370: and wzl.subinventory_code = p_subinventory_code -- new
371: and wzl.organization_id = l_organization_id -- new

Line 409: wms_license_plate_numbers wlpn

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
412: and wzl.subinventory_code = p_subinventory_code -- new
413: and wzl.organization_id = l_organization_id -- new

Line 449: wms_license_plate_numbers wlpn

445: select wlpn.outermost_lpn_id
446: from wms_op_plan_instances_hist wopih,
447: wms_op_opertn_instances_hist wooih,
448: wms_dispatched_tasks_history wdth,
449: wms_license_plate_numbers wlpn
450: where wlpn.subinventory_code = wdth.dest_subinventory_code
451: and wlpn.locator_id = wdth.dest_locator_id
452: and wlpn.subinventory_code = p_subinventory_code -- new
453: and wlpn.locator_id = p_locator_id -- new

Line 488: wms_license_plate_numbers wlpn

484: select wlpn.outermost_lpn_id
485: from wms_op_plan_instances_hist wopih,
486: wms_op_opertn_instances_hist wooih,
487: wms_dispatched_tasks_history wdth,
488: wms_license_plate_numbers wlpn
489: where wlpn.subinventory_code = wdth.dest_subinventory_code
490: and wlpn.locator_id = wdth.dest_locator_id
491: and wlpn.subinventory_code = p_subinventory_code -- new
492: and wlpn.locator_id = p_locator_id -- new