APPS.INV_GENEALOGY_PUB dependencies on MTL_SYSTEM_ITEMS

Line 599: FROM mtl_system_items msi

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

Line 620: FROM mtl_system_items msi

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

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;