APPS.INV_GENEALOGY_PUB dependencies on MTL_SYSTEM_ITEMS

Line 601: FROM mtl_system_items msi

597: END IF;
598:
599: SELECT msi.eam_item_type
600: INTO l_parent_item_type
601: FROM mtl_system_items msi
602: WHERE msi.inventory_item_id = l_parent_inventory_item_id
603: AND msi.organization_id = l_parent_org_id;
604:
605: IF l_parent_item_type IS NULL THEN

Line 622: FROM mtl_system_items msi

618: END IF;
619:
620: SELECT msi.eam_item_type
621: INTO l_child_item_type
622: FROM mtl_system_items msi
623: WHERE msi.inventory_item_id = l_inventory_item_id
624: AND msi.organization_id = l_org_id;
625:
626: IF l_child_item_type IS NULL THEN

Line 1947: FROM mtl_system_items_b

1943: IF (p_debug = 1) THEN mydebug('l_inventory_item_id is not null ' ); END IF;
1944:
1945: SELECT lot_control_code
1946: INTO l_child_lot_control_code
1947: FROM mtl_system_items_b
1948: WHERE inventory_item_id = l_inventory_item_id
1949: AND Organization_id = p_org_id;
1950:
1951: END IF;

Line 1985: FROM mtl_system_items_b

1981: END IF;
1982: IF l_parent_inventory_item_id is NOT NULL THEN
1983: SELECT lot_control_code
1984: INTO l_parent_lot_control_code
1985: FROM mtl_system_items_b
1986: WHERE inventory_item_id = l_parent_inventory_item_id
1987: AND Organization_id = p_parent_org_id;
1988:
1989: END IF;