APPS.INV_GENEALOGY_PUB dependencies on MTL_SYSTEM_ITEMS_B

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;