2624: END IF;
2625:
2626: SELECT serial_number_control_code
2627: INTO l_serial_code
2628: FROM mtl_system_items
2629: WHERE inventory_item_id = p_inv_item_id
2630: AND organization_id = cs_std.get_item_valdn_orgzn_id;
2631:
2632: IF l_serial_code = 2
2661: l_ib_trackable_flag VARCHAR2 (1) ;
2662: BEGIN
2663: SELECT NVL (comms_nl_trackable_flag, 'N')
2664: INTO l_ib_trackable_flag
2665: FROM mtl_system_items
2666: WHERE inventory_item_id = p_inv_item_id
2667: AND organization_id = cs_std.get_item_valdn_orgzn_id;
2668:
2669: IF l_ib_trackable_flag = 'Y'