APPS.WMS_OP_RUNTIME_PUB_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 110: FROM mtl_material_transactions_temp mmtt,

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,

Line 410: UPDATE mtl_material_transactions_temp

406: --
407: -- Bug 4884284: Bulk pick can have multiple deliveries
408: -- so update dest sub/loc immediately
409: --
410: UPDATE mtl_material_transactions_temp
411: SET transfer_subinventory
412: = l_sug_dest_sub_table(l_task_count)
413: , transfer_to_location
414: = l_sug_dest_loc_id_table(l_task_count)

Line 614: UPDATE mtl_material_transactions_temp

610: END IF;
611:
612: END IF;
613:
614: UPDATE mtl_material_transactions_temp
615: SET transfer_subinventory
616: = l_sug_dest_sub_table(l_task_count)
617: , transfer_to_location
618: = l_sug_dest_loc_id_table(l_task_count)

Line 642: UPDATE mtl_material_transactions_temp

638: l_progress := '100';
639:
640: -- bulk update MMTT with new subinventory and locator
641: /* forall i IN 1..l_temp_id_table.COUNT
642: UPDATE mtl_material_transactions_temp
643: SET transfer_subinventory = l_sug_dest_sub_table(i),
644: transfer_to_location = l_sug_dest_loc_id_table(i)
645: --cartonization_id = l_sug_lpn_id_table(i) -- xdock MDC
646: -- mrana:bug5257431: the above update should not be committed

Line 672: UPDATE mtl_material_transactions_temp

668: l_progress := '110';
669:
670: -- mrana:bug5257431: Bulk update MMTT with suggested MDC LPN
671: forall i IN 1..l_temp_id_table.COUNT
672: UPDATE mtl_material_transactions_temp
673: SET cartonization_id = l_sug_lpn_id_table(i) -- MDC
674: WHERE transaction_temp_id = l_temp_id_table(i);
675:
676: l_progress := '120';

Line 735: FROM mtl_material_transactions_temp mmtt,

731: op.loc_selection_api_id dest_loc_sel_api_id,
732: Nvl(op.drop_lpn_option, g_op_drop_lpn_optional) drop_lpn_option,
733: Nvl(consolidation_method_id, 2) consolidation_method_id,
734: mmtt.organization_id organization_id --BUG13839132
735: FROM mtl_material_transactions_temp mmtt,
736: (SELECT plan.operation_plan_id,
737: detail.loc_selection_criteria,
738: detail.loc_selection_api_id,
739: detail.drop_lpn_option,