DBA Data[Home] [Help]

APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_OP_PLAN_INSTANCES_HIST

Line 363: from wms_op_plan_instances_hist wopih,

359: --
360: --
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

Line 405: from wms_op_plan_instances_hist wopih,

401: --
402: --
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

Line 446: from wms_op_plan_instances_hist wopih,

442: --
443: --
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

Line 485: from wms_op_plan_instances_hist wopih,

481: --
482: --
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