2202: CURSOR get_item_info( l_org_id IN NUMBER
2203: , l_item_id IN NUMBER) IS
2204: SELECT tracking_quantity_ind
2205: , lot_control_code
2206: FROM mtl_system_items_b
2207: WHERE inventory_item_id = l_item_id
2208: AND organization_id = l_org_id;
2209: -- invConv changes end
2210:
2231:
2232: -- invConv change : this is included in the above cursor.
2233: -- SELECT lot_control_code
2234: -- into l_lot_control
2235: -- from mtl_system_items_b
2236: -- where inventory_item_id = p_item_id
2237: -- and organization_id = p_org_id;
2238:
2239: -- Added the below for 6633612
2935: , 9);
2936: END IF;
2937: SELECT lot_control_code
2938: into l_lot_control
2939: from mtl_system_items_b
2940: where inventory_item_id = p_item_id
2941: and organization_id = p_org_id;
2942:
2943: /* Added the below for bug 7193862 */