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 636: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

632: || serial_number
633: || l_genealogy_delimitter
634: || concatenated_segments
635: INTO l_object_number
636: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
637: WHERE msn.gen_object_id = p_object_id
638: AND msn.inventory_item_id = msikfv.inventory_item_id
639: AND msn.current_organization_id = msikfv.organization_id;
640: ELSIF l_genealogy_prefix_suffix = 2 THEN -- suffix

Line 647: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

643: || l_lot_number
644: || l_genealogy_delimitter
645: || serial_number
646: INTO l_object_number
647: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
648: WHERE msn.gen_object_id = p_object_id
649: AND msn.inventory_item_id = msikfv.inventory_item_id
650: AND msn.current_organization_id = msikfv.organization_id;
651: ELSIF l_genealogy_prefix_suffix = 3 THEN --None

Line 654: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv

650: AND msn.current_organization_id = msikfv.organization_id;
651: ELSIF l_genealogy_prefix_suffix = 3 THEN --None
652: SELECT l_lot_number || DECODE(l_lot_number, NULL, '', l_genealogy_delimitter) || serial_number
653: INTO l_object_number
654: FROM mtl_serial_numbers msn, mtl_system_items_kfv msikfv
655: WHERE msn.gen_object_id = p_object_id
656: AND msn.inventory_item_id = msikfv.inventory_item_id
657: AND msn.current_organization_id = msikfv.organization_id;
658: END IF;

Line 662: FROM mtl_serial_numbers

658: END IF;
659: ELSE
660: SELECT l_lot_number || DECODE(l_lot_number, NULL, '', l_genealogy_delimitter) || serial_number
661: INTO l_object_number
662: FROM mtl_serial_numbers
663: WHERE gen_object_id = p_object_id;
664: END IF;
665: ELSIF p_object_type = 5 THEN
666: SELECT we.primary_item_id