2813: IF x_cascaded_table(n).item_id IS NOT NULL THEN
2814: BEGIN
2815: SELECT primary_unit_of_measure
2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;
2814: BEGIN
2815: SELECT primary_unit_of_measure
2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;
2822: EXCEPTION
2816: INTO temp_cascaded_table(current_n).primary_unit_of_measure
2817: FROM mtl_system_items
2818: WHERE mtl_system_items.inventory_item_id =
2819: temp_cascaded_table(current_n).item_id
2820: AND mtl_system_items.organization_id =
2821: temp_cascaded_table(current_n).to_organization_id;
2822: EXCEPTION
2823: WHEN no_data_found THEN
2824: temp_cascaded_table(current_n).error_status := 'W';