APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 366: wms_dispatched_tasks_history wdth,

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

Line 408: wms_dispatched_tasks_history wdth,

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

Line 448: wms_dispatched_tasks_history wdth,

444: cursor c_lpn_comp_wozone_witem is
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

Line 487: wms_dispatched_tasks_history wdth,

483: cursor c_lpn_comp_wozone_woitem is
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