APPS.WIP_EAM_GENEALOGY_PVT dependencies on MTL_SYSTEM_ITEMS

Line 130: from mtl_system_items

126: -- the genealogy is not originating from eam
127: if (((p_from_eam is null) or (p_from_eam = FND_API.G_FALSE))
128: and ((p_object_id is null) and (p_serial_number is null))) then
129: select serial_number_control_code into l_serial_control
130: from mtl_system_items
131: where inventory_item_id = p_inventory_item_id and
132: organization_id = p_organization_id;
133:
134: if (l_serial_control = 1) then

Line 584: from mtl_system_items

580: end if;
581:
582: select restrict_subinventories_code
583: into l_sub_code
584: from mtl_system_items
585: where inventory_item_id = l_inventory_item_id
586: and organization_id = l_organization_id;
587:
588: if l_sub_code = 1 then