APPS.WMS_CONTROL_BOARD dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 440: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

436: CURSOR C_mmtt IS SELECT
437: transaction_temp_id
438: , wms_task_status
439: , task_priority
440: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
441: WHERE transaction_temp_id = p_transaction_temp_id
442: FOR UPDATE OF wms_task_status, task_priority NOWAIT;
443:
444: CURSOR C_wdt IS SELECT

Line 681: UPDATE mtl_material_transactions_temp

677: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
678: BEGIN
679: --dbms_output.put_line('in update_mmtt '|| p_transaction_temp_id || ':' || p_priority || ':' ||p_from_status || ':' ||p_to_status);
680:
681: UPDATE mtl_material_transactions_temp
682: SET
683: task_priority = p_priority
684: , wms_task_status = decode(p_to_status, NULL, p_from_status, p_to_status)
685: , last_updated_by = p_updated_by

Line 772: FROM mtl_material_transactions_temp

768: WHERE cycle_count_entry_id = p_transaction_temp_id;
769: ELSE
770: SELECT organization_id, standard_operation_id, wms_task_type, operation_plan_id, move_order_line_id
771: INTO l_org_id, l_user_task_type, l_wms_task_type, l_operation_plan_id, l_move_order_line_id
772: FROM mtl_material_transactions_temp
773: WHERE transaction_temp_id = p_transaction_temp_id;
774: END IF;
775:
776: --dbms_output.put_line('Before Insert into WMSDT');