APPS.WMS_ATF_DESTINATION_LPN dependencies on WMS_OP_OPERTN_INSTANCES_HIST

Line 364: wms_op_opertn_instances_hist wooih,

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
368: where wzl.zone_id = l_pre_specified_zone_id

Line 386: from wms_op_opertn_instances_hist wooih2

382: and wdth.inventory_item_id = p_item_id
383: and wdth.status = 6 -- Completed task. lookup_type is WMS_TASK_STATUS
384: and wdth.transaction_id = wooih.source_task_id
385: and wooih.operation_sequence in (select max(operation_sequence)
386: from wms_op_opertn_instances_hist wooih2
387: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
388: and wooih2.operation_type_id in (2,9)
389: and wooih2.operation_status = 3)
390: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 406: wms_op_opertn_instances_hist wooih,

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
410: where wzl.zone_id = l_pre_specified_zone_id

Line 427: from wms_op_opertn_instances_hist wooih2

423: and wdth.organization_id = l_organization_id -- new
424: and wdth.status = 6 -- Completed task. lookup_type is WMS_TASK_STATUS
425: and wdth.transaction_id = wooih.source_task_id
426: and wooih.operation_sequence in (select max(operation_sequence)
427: from wms_op_opertn_instances_hist wooih2
428: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
429: and wooih2.operation_type_id in (2,9)
430: and wooih2.operation_status = 3)
431: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 447: wms_op_opertn_instances_hist wooih,

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
451: and wlpn.locator_id = wdth.dest_locator_id

Line 466: from wms_op_opertn_instances_hist wooih2

462: and wooih.organization_id = l_organization_id -- new
463: and wooih.to_subinventory_code = p_subinventory_code -- new
464: and wooih.to_locator_id = p_locator_id -- new
465: and wooih.operation_sequence in (select max(operation_sequence)
466: from wms_op_opertn_instances_hist wooih2
467: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
468: and wooih2.operation_type_id in (2,9)
469: and wooih2.operation_status = 3)
470: and wooih.op_plan_instance_id = wopih.op_plan_instance_id

Line 486: wms_op_opertn_instances_hist wooih,

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
490: and wlpn.locator_id = wdth.dest_locator_id

Line 505: from wms_op_opertn_instances_hist wooih2

501: and wooih.organization_id = l_organization_id -- new
502: and wooih.to_subinventory_code = p_subinventory_code -- new
503: and wooih.to_locator_id = p_locator_id -- new
504: and wooih.operation_sequence in (select max(operation_sequence)
505: from wms_op_opertn_instances_hist wooih2
506: where wooih2.op_plan_instance_id = wopih.op_plan_instance_id
507: and wooih2.operation_type_id in (2,9)
508: and wooih2.operation_status = 3)
509: and wooih.op_plan_instance_id = wopih.op_plan_instance_id