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 587: from mtl_system_items

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

Line 946: FROM MTL_SYSTEM_ITEMS

942:
943: SELECT
944: location_control_code,restrict_locators_code into
945: x_item_ctrl,x_restrict_flag
946: FROM MTL_SYSTEM_ITEMS
947: WHERE
948: inventory_item_id = p_item_id and
949: organization_id = p_org;
950: Exception