[Home] [Help]
106: Nvl(op.loc_selection_criteria, g_op_dest_sys_suggested) dest_loc_sel_criteria,
107: op.loc_selection_api_id dest_loc_sel_api_id,
108: Nvl(op.drop_lpn_option, g_op_drop_lpn_optional) drop_lpn_option,
109: Nvl(op.consolidation_method_id, 2) consolidation_method_id -- xdock MDC default to within delivery
110: FROM mtl_material_transactions_temp mmtt,
111: (SELECT plan.operation_plan_id,
112: detail.loc_selection_criteria,
113: detail.loc_selection_api_id,
114: detail.drop_lpn_option,
405: --
406: -- Bug 4884284: Bulk pick can have multiple deliveries
407: -- so update dest sub/loc immediately
408: --
409: UPDATE mtl_material_transactions_temp
410: SET transfer_subinventory
411: = l_sug_dest_sub_table(l_task_count)
412: , transfer_to_location
413: = l_sug_dest_loc_id_table(l_task_count)
630: l_progress := '100';
631:
632: -- bulk update MMTT with new subinventory and locator
633: forall i IN 1..l_temp_id_table.COUNT
634: UPDATE mtl_material_transactions_temp
635: SET transfer_subinventory = l_sug_dest_sub_table(i),
636: transfer_to_location = l_sug_dest_loc_id_table(i)
637: --cartonization_id = l_sug_lpn_id_table(i) -- xdock MDC
638: -- mrana:bug5257431: the above update should not be committed
660: l_progress := '110';
661:
662: -- mrana:bug5257431: Bulk update MMTT with suggested MDC LPN
663: forall i IN 1..l_temp_id_table.COUNT
664: UPDATE mtl_material_transactions_temp
665: SET cartonization_id = l_sug_lpn_id_table(i) -- MDC
666: WHERE transaction_temp_id = l_temp_id_table(i);
667:
668: l_progress := '120';
722: Nvl(op.loc_selection_criteria, g_op_dest_sys_suggested) dest_loc_sel_criteria,
723: op.loc_selection_api_id dest_loc_sel_api_id,
724: Nvl(op.drop_lpn_option, g_op_drop_lpn_optional) drop_lpn_option,
725: Nvl(consolidation_method_id, 2) consolidation_method_id
726: FROM mtl_material_transactions_temp mmtt,
727: (SELECT plan.operation_plan_id,
728: detail.loc_selection_criteria,
729: detail.loc_selection_api_id,
730: detail.drop_lpn_option,