eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_OBJECT_GENEALOGY dependencies on MTL_LOT_NUMBERS

Line 11: FROM mtl_lot_numbers

7: BEGIN
8: BEGIN
9: SELECT 1
10: INTO l_retval
11: FROM mtl_lot_numbers
12: WHERE gen_object_id = p_object_id;
13: EXCEPTION
14: WHEN NO_DATA_FOUND THEN
15: BEGIN

Line 87: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln

83: , p_primary_uom
84: , p_inventory_item_id
85: , p_object_number
86: , l_status_id
87: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln
88: WHERE mln.gen_object_id = p_object_id
89: AND mln.inventory_item_id = msivl.inventory_item_id
90: AND mln.organization_id = msivl.organization_id;
91:

Line 260: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln

256: , p_primary_uom
257: , p_inventory_item_id
258: , p_object_number
259: , l_status_id
260: FROM mtl_system_items_vl msivl, mtl_lot_numbers mln
261: WHERE mln.gen_object_id = p_object_id
262: AND mln.inventory_item_id = msivl.inventory_item_id
263: AND mln.organization_id = msivl.organization_id;
264:

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