APPS.WMS_CONTROL_BOARD dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 432: FROM MTL_CYCLE_COUNT_ENTRIES

428: CURSOR C_mcce IS SELECT --kkoothan
429: cycle_count_entry_id
430: , 1 -- status
431: , task_priority
432: FROM MTL_CYCLE_COUNT_ENTRIES
433: WHERE cycle_count_entry_id = p_transaction_temp_id
434: FOR UPDATE OF entry_status_code, task_priority NOWAIT;
435:
436: CURSOR C_mmtt IS SELECT

Line 563: FROM MTL_CYCLE_COUNT_ENTRIES

559: CURSOR C_mcce IS SELECT --kkoothan
560: cycle_count_entry_id
561: , 1 -- status
562: , task_priority
563: FROM MTL_CYCLE_COUNT_ENTRIES
564: WHERE cycle_count_entry_id = p_transaction_temp_id
565: FOR UPDATE OF entry_status_code, task_priority NOWAIT;
566:
567: recinfo_mcce C_mcce%ROWTYPE; --kkoothan

Line 649: UPDATE MTL_CYCLE_COUNT_ENTRIES

645:
646: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
647: BEGIN
648:
649: UPDATE MTL_CYCLE_COUNT_ENTRIES
650: SET
651: task_priority = p_priority
652: , last_updated_by = p_updated_by
653: , last_update_date= p_last_update_date /* Bug 2372652 */

Line 767: FROM mtl_cycle_count_entries

763: IF p_transaction_source_type_id =9 THEN --kkoothan
764: -- cycle count
765: SELECT organization_id, standard_operation_id, 3 --task type
766: INTO l_org_id, l_user_task_type, l_wms_task_type
767: FROM mtl_cycle_count_entries
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