APPS.INV_OBJECT_GENEALOGY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 593: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

589: -- Lot Genealogy is available even if WMS is not installed
590: IF l_genealogy_prefix_suffix = 1 THEN --Prefix
591: SELECT lot_number || l_genealogy_delimitter || concatenated_segments
592: INTO l_object_number
593: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
594: WHERE mln.gen_object_id = p_object_id
595: AND mln.inventory_item_id = msikfv.inventory_item_id
596: AND mln.organization_id = msikfv.organization_id;
597: ELSIF l_genealogy_prefix_suffix = 2 THEN --Suffix

Line 600: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

596: AND mln.organization_id = msikfv.organization_id;
597: ELSIF l_genealogy_prefix_suffix = 2 THEN --Suffix
598: SELECT concatenated_segments || l_genealogy_delimitter || lot_number
599: INTO l_object_number
600: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
601: WHERE mln.gen_object_id = p_object_id
602: AND mln.inventory_item_id = msikfv.inventory_item_id
603: AND mln.organization_id = msikfv.organization_id;
604: ELSIF l_genealogy_prefix_suffix = 3 THEN --None

Line 607: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

603: AND mln.organization_id = msikfv.organization_id;
604: ELSIF l_genealogy_prefix_suffix = 3 THEN --None
605: SELECT lot_number
606: INTO l_object_number
607: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
608: WHERE mln.gen_object_id = p_object_id
609: AND mln.inventory_item_id = msikfv.inventory_item_id
610: AND mln.organization_id = msikfv.organization_id;
611: END IF;

Line 618: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

614: AND p_object_type2 = 1 THEN -- Lot Serial controlled
615: BEGIN
616: SELECT lot_number
617: INTO l_lot_number
618: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
619: WHERE mln.gen_object_id = p_object_id2
620: AND mln.inventory_item_id = msikfv.inventory_item_id
621: AND mln.organization_id = msikfv.organization_id;
622: EXCEPTION

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 678: FROM mtl_system_items_kfv msikfv

674:
675: IF (l_item_id IS NOT NULL) THEN
676: SELECT concatenated_segments
677: INTO l_con_seg
678: FROM mtl_system_items_kfv msikfv
679: WHERE msikfv.inventory_item_id = l_item_id
680: AND msikfv.organization_id = l_orgn_id;
681: ELSE
682: l_con_seg := '';