APPS.INV_GENEALOGY_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 1924: FROM mtl_system_items_b

1920: IF (p_debug = 1) THEN mydebug('l_inventory_item_id is not null ' ); END IF;
1921:
1922: SELECT lot_control_code
1923: INTO l_child_lot_control_code
1924: FROM mtl_system_items_b
1925: WHERE inventory_item_id = l_inventory_item_id
1926: AND Organization_id = p_org_id;
1927:
1928: END IF;

Line 1962: FROM mtl_system_items_b

1958: END IF;
1959: IF l_parent_inventory_item_id is NOT NULL THEN
1960: SELECT lot_control_code
1961: INTO l_parent_lot_control_code
1962: FROM mtl_system_items_b
1963: WHERE inventory_item_id = l_parent_inventory_item_id
1964: AND Organization_id = p_parent_org_id;
1965:
1966: END IF;