DBA Data[Home] [Help]

APPS.INV_OBJECT_GENEALOGY dependencies on MTL_SYSTEM_ITEMS_KFV

Line 539: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

535: -- Lot Genealogy is available even if WMS is not installed
536: IF l_genealogy_prefix_suffix = 1 THEN --Prefix
537: SELECT lot_number || l_genealogy_delimitter || concatenated_segments
538: INTO l_object_number
539: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
540: WHERE mln.gen_object_id = p_object_id
541: AND mln.inventory_item_id = msikfv.inventory_item_id
542: AND mln.organization_id = msikfv.organization_id;
543: ELSIF l_genealogy_prefix_suffix = 2 THEN --Suffix

Line 546: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

542: AND mln.organization_id = msikfv.organization_id;
543: ELSIF l_genealogy_prefix_suffix = 2 THEN --Suffix
544: SELECT concatenated_segments || l_genealogy_delimitter || lot_number
545: INTO l_object_number
546: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
547: WHERE mln.gen_object_id = p_object_id
548: AND mln.inventory_item_id = msikfv.inventory_item_id
549: AND mln.organization_id = msikfv.organization_id;
550: ELSIF l_genealogy_prefix_suffix = 3 THEN --None

Line 553: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

549: AND mln.organization_id = msikfv.organization_id;
550: ELSIF l_genealogy_prefix_suffix = 3 THEN --None
551: SELECT lot_number
552: INTO l_object_number
553: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
554: WHERE mln.gen_object_id = p_object_id
555: AND mln.inventory_item_id = msikfv.inventory_item_id
556: AND mln.organization_id = msikfv.organization_id;
557: END IF;

Line 564: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv

560: AND p_object_type2 = 1 THEN -- Lot Serial controlled
561: BEGIN
562: SELECT lot_number
563: INTO l_lot_number
564: FROM mtl_lot_numbers mln, mtl_system_items_kfv msikfv
565: WHERE mln.gen_object_id = p_object_id2
566: AND mln.inventory_item_id = msikfv.inventory_item_id
567: AND mln.organization_id = msikfv.organization_id;
568: EXCEPTION

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

620:
621: IF (l_item_id IS NOT NULL) THEN
622: SELECT concatenated_segments
623: INTO l_con_seg
624: FROM mtl_system_items_kfv msikfv
625: WHERE msikfv.inventory_item_id = l_item_id
626: AND msikfv.organization_id = l_orgn_id;
627: ELSE
628: l_con_seg := '';