APPS.INV_OBJECT_GENEALOGY dependencies on MTL_SERIAL_NUMBERS

Line 18: FROM mtl_serial_numbers

14: WHEN NO_DATA_FOUND THEN
15: BEGIN
16: SELECT 2
17: INTO l_retval
18: FROM mtl_serial_numbers
19: WHERE gen_object_id = p_object_id;
20: EXCEPTION
21: /*osfmint*/
22: WHEN NO_DATA_FOUND THEN

Line 157: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn

153: , p_unit_number
154: , p_object_number
155: , p_inventory_item_id
156: , l_status_id
157: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn
158: WHERE msn.gen_object_id = p_object_id
159: AND msn.inventory_item_id = msivl.inventory_item_id
160: AND msn.current_organization_id = msivl.organization_id;
161:

Line 340: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn

336: , x_wip_entity_id
337: , x_operation_seq_num
338: , x_intraoperation_step_type
339: , x_current_lot_number
340: FROM mtl_system_items_vl msivl, mtl_serial_numbers msn
341: WHERE msn.gen_object_id = p_object_id
342: AND msn.inventory_item_id = msivl.inventory_item_id
343: AND msn.current_organization_id = msivl.organization_id;
344:

Line 582: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

578: || serial_number
579: || l_genealogy_delimitter
580: || concatenated_segments
581: INTO l_object_number
582: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
583: WHERE msn.gen_object_id = p_object_id
584: AND msn.inventory_item_id = msikfv.inventory_item_id
585: AND msn.current_organization_id = msikfv.organization_id;
586: ELSIF l_genealogy_prefix_suffix = 2 THEN -- suffix

Line 593: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

589: || l_lot_number
590: || l_genealogy_delimitter
591: || serial_number
592: INTO l_object_number
593: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
594: WHERE msn.gen_object_id = p_object_id
595: AND msn.inventory_item_id = msikfv.inventory_item_id
596: AND msn.current_organization_id = msikfv.organization_id;
597: ELSIF l_genealogy_prefix_suffix = 3 THEN --None

Line 600: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

596: AND msn.current_organization_id = msikfv.organization_id;
597: ELSIF l_genealogy_prefix_suffix = 3 THEN --None
598: SELECT l_lot_number || DECODE(l_lot_number, NULL, '', l_genealogy_delimitter) || serial_number
599: INTO l_object_number
600: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
601: WHERE msn.gen_object_id = p_object_id
602: AND msn.inventory_item_id = msikfv.inventory_item_id
603: AND msn.current_organization_id = msikfv.organization_id;
604: END IF;

Line 608: FROM mtl_serial_numbers

604: END IF;
605: ELSE
606: SELECT l_lot_number || DECODE(l_lot_number, NULL, '', l_genealogy_delimitter) || serial_number
607: INTO l_object_number
608: FROM mtl_serial_numbers
609: WHERE gen_object_id = p_object_id;
610: END IF;
611: ELSIF p_object_type = 5 THEN
612: SELECT we.primary_item_id