APPS.WMS_CONTROL_BOARD dependencies on STANDARD

Line 654: , standard_operation_id = p_user_task_type

650: SET
651: task_priority = p_priority
652: , last_updated_by = p_updated_by
653: , last_update_date= p_last_update_date /* Bug 2372652 */
654: , standard_operation_id = p_user_task_type
655: WHERE cycle_count_entry_id = p_cycle_count_entry_id;
656: commit;
657: EXCEPTION
658: WHEN no_data_found THEN

Line 687: , standard_operation_id = p_user_task_type

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
686: , last_update_date= SYSDATE
687: , standard_operation_id = p_user_task_type
688: , wms_task_type = p_task_type
689: WHERE transaction_temp_id = p_transaction_temp_id;
690: commit;
691: --dbms_output.put_line('did update_mmtt ');

Line 765: SELECT organization_id, standard_operation_id, 3 --task type

761:
762: -- Obtain org_id, user_task_type and task_type
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

Line 770: SELECT organization_id, standard_operation_id, wms_task_type, operation_plan_id, move_order_line_id

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
772: FROM mtl_material_transactions_temp
773: WHERE transaction_temp_id = p_transaction_temp_id;
774: END IF;